Introduction to Language Integrated Query (LINQ)

AUDIENCE: Engineers, Developers, Programmers, and Software Development Professionals.
PREREQUISITES: The course is designed for existing .Net developers in any .Net language.
DURATION: 3 days. Hands on.
OBJECTIVES: The .NET 3.5 Framework SDK comes with numerous updates to the C# and VB programming languages. In this course, attendees will explore these new programming constructs first hand. Once the core language features have been examined, the remainder of the course will examine LINQ (Language Integrated Query) and the core APIs which represent it: LINQ over Objects, LINQ to SQL and LINQ to XML.
On completion, delegates will:
- Learn C# 3.0 language features
- Learn VB 9.0 language features
- Learn the LINQ API
COURSE CONTENT:
.NET 3.5 Language Features
Understand implicitly typed local variables
Understand the role of extension methods
Understand object initialization syntax
Understand anonymous types
Understand lambda expressions

An Introduction to LINQ
Understand the motivation behind LINQ
Visual Studio 2008 LINQ support
Debugging LINQ query expressions
Work with query operators and query expressions
Program with LINQ to Objects
Understand deferred and immediate execution
Know the role of the System.Linq.Enumerable type
Know the role of the System.Func delegate type
Understanding the query operators / delegates / lambda relationship

LINQ to ADO.NET
Define LINQ to ADO.NET
Apply LINQ queries to ADO.NET DataSets
Work with the DataRowExtensions and DataTableExtensions types
Know the role of LINQ to SQL
Know the role of entity classes
Entity class-centric attributes
Know the role of data context objects
Generate entity classes via sqlmetal.exe and Visual Studio 2008
Apply LINQ queries to relational databases

LINQ to XML
Understand the role of LINQ to XML
Work with the LINQ to XML object model
Examine the System.Xml.Linq namespace
Use LINQ to XML to create, query and save XML documents
Insert and remove XML data using LINQ to XML
Examine VB''s XML literal syntax
Work with VB XML axis properties
Understand the LINQ to XML / XML literal relationship

PG08/01