Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Microsoft LINQ Using Visual Basic 2008
with Ken Getz and Robert Green


View the Course Outline

In this course, you’ll learn to use the exciting new .NET Framework 3.5 feature, Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, you’ll learn about the new language features added to Visual Basic in Visual Studio 2008 in order to make LINQ possible. More...

This course ships 11/17/2008 with the full 10+ hours of instructor-led training media. Courseware, labs, code and exams for this course will be available 12/31/2008.

Course includes 30+ hours of total training time...
  • 8 modules of training
  • Over 10 hours of media run time
  • Over 850 pages of printable courseware
  • Step-by-step hands-on-labs
  • Sample code
Format Modules Retail Price
Microsoft LINQ Using Visual Basic 2008
CD-ROM

 8 CD-ROMs

$495.00  
CD-ROM & Books

 8 CD-ROMs + Printed Books

$591.00  
DVD-ROM

 1 DVD-ROM

$495.00  
DVD-ROM & Books

 1 DVD-ROM + Printed Books

$591.00  
Read about Ken Getz and Robert Green..
Course Outline (Outlines are subject to change.)
Microsoft LINQ Using Visual Basic 2008
Modules Run Time Pages
8 10 hours 850

In this course, you’ll learn to use the exciting new .NET Framework 3.5 feature, Language Integrated Query (LINQ) to easily create complex data-independent queries. In addition, you’ll learn about the new language features added to Visual C# in Visual Studio 2008 in order to make LINQ possible. You’ll start by working through a quick overview of LINQ, and how it applies to working with collections of objects, retrieving data stored in SQL Server, and creating XML content. Subsequent topics introduce new LINQ-oriented language features, LINQ to Objects, LINQ to DataSets, LINQ to SQL, LINQ to XML, and LINQ to Entities. By the time you’ve completed the course, you’ll have a good understanding of now only how to construct LINQ queries to work with data, but also how to use the features added to Visual Basic that support LINQ.

In this course you will learn...
  • Create new XML content using LINQ to XML.
  • Iterate through collections of objects, using a single LINQ query.
  • Use anonymous types, lambda expressions, extension methods, object initializers, and implicit type declaration.
  • Query arrays, lists, dictionaries, and more using LINQ to Objects.
  • Use the extension methods provided by the System.Linq.Enumerable class to extend the behavior of collection classes.
  • Create an object model based on a SQL Server database and then query the database using LINQ to SQL.
  • Modify data and use stored procedures with LINQ to SQL.
  • Create XML content using classes in the System.Xml.Linq namespace.
  • Validate, query and transform XML content using LINQ to XML.
  • Transform XML content using LINQ to XML.
  • Create an Entity Data Model based on a data source and then query the data using LINQ to Entities.
  • Modify data and use stored procedures with LINQ to Entities.
Prerequisites:

This course assumes that students have familiarity with .NET in general, and with specifically with programming ADO.NET. The course makes no attempt to explain basic Visual Studio 2008 or .NET Framework concepts, and assumes that the student is at least familiar with all the concepts covered in the Introduction to Programming and Developing Applications with Visual Studio 2008 courses.

Introduction to LINQ

  • Motivate the Need for LINQ
  • Learn about the Various LINQ Providers
  • Investigate Simple LINQ to Objects, LINQ to SQL, and LINQ to XML Samples
Language Enhancements for LINQ
  • Investigate the New Language Features Required by LINQ
  • Learn about Impllicit Type Declaration
  • Use Object Initialization
  • Work with Lambda Expressions
  • Create and Use Extension Methods
  • Select Multiple Columns Using Anonymous Types
LINQ to Objects
  • Learn Various Techniques for Using LINQ to Query Collections of In-Memory Objects
  • Use LINQ with Arrays, Generic Lists, Generic Dictionaries, Strings, and Other Non-Generic Collections
  • Work with Examples Using Many of the System.Linq.Enumerable Extension Methods, and Compare these Methods to LINQ Keywords
LINQ to SQL
  • Learn How to Map a Data Model to an Object Model
  • Lean Various Techniques for Using LINQ to SQL to Query Data in a SQL Server Database
  • Explore How to Modify Data and Save Changes
  • See How to Use Stored Procedures to Modify Data
More LINQ to SQL
  • Explore Advanced Features of LINQ to SQL
  • Explore Using LINQ to SQL in a Windows Application
  • Explore Using LINQ to SQL in a Web Application
LINQ to DataSets
  • Learn Various Techniques for Using LINQ to DataSet to Query Data in a DataSet
  • See How to Use DataViews with the Results of a LINQ to DataSet Query
  • Explore How to Bind the Results of a LINQ to DataSet Query to Windows Forms Controls
LINQ to XML
  • Create XML Content Using Classes in the System.Xml.LINQ Namespace
  • Search Content Using XPath Expressions with the LINQ-Based API
  • Validate XML Content Using the LINQ-Based API
  • Query XML Content Using LINQ to XML
  • Transform XML Content Using LINQ to XML
LINQ to Entities
  • Understand the Relationship Between LINQ to Entities and the Entity Framework
  • Learn How to Map a Data Model to an Entity Data Model
  • Learn Various Techniques for Using LINQ to Entities to Query Data in a Database
  • Explore How to Modfiy Data and Save Changes
  • See How to Use Stored Procedures to Modify Data

back to top


Your Instructor

Ken Getz is a nationally renowned speaker and best-selling author who specializes in programming with Visual C# and Visual Basic. He has been working with for more than 10 years, and is the author and presenter of some of A most popular courses (click here for list of courses). Ken is also a senior consultant with MCW Technologies and the author or co-author of several best-selling books including Access 2002 Developer's Handbooks (with Paul Litwin and Mike Gunderloy (Sybex)), Access Cookbook (with Andy Baron and Paul Litwin (O'Reilly)), VBA Developer's Handbook (with Mike Gilbert (Sybex)), and ASP.NET Developer's JumpStart (with Paul D. Sheriff (Addison-Wesley)). Since the inception of the program, Ken has been selected each year as a Microsoft Support MVP and is a member of the INETA speaker's bureau, traveling to speak at .NET user groups throughout the country. Ken is a frequent speaker at technical conferences, including Microsoft's Tech-Ed, as well as VSLive and DevConnections. Ken is also a technical editor for Advisor Guide to Microsoft Access and Advisor Guide to Microsoft Visual Basic and is a columnist for both CoDe Magazine and MSDN Magazine.

Robert Green is a senior consultant with MCW Technologies, a Microsoft Certified Partner. Before joining MCW, Robert worked at Microsoft for 8 years, most recently as a Program Manager on the Visual Basic product team and previously as a Product Manager for several products including Visual Studio, Visual Basic, Visual Studio Tools for Office and Visual FoxPro. Prior to joining Microsoft, Robert was a Vice President and co-founder of The Information Management Group, a consulting and education services firm in Chicago. Robert has been a frequent speaker at technology conferences, including TechEd, VSLive, VSConnections and Advisor Live. His articles have appeared on MSDN and Advisor Publication’s VB.NET Advisor, and will appear in other venues as well throughout the year. Robert is the co-author and co-presenter of Visual Basic 2005 and Visual C# 2005 training, along with Ken Getz.

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
? Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy