LINQ (Language Integrated Query) Training Course

Overview

Introduction to Language Integrated Query training class teaches participants all the skills necessary for using LINQ effectively in their .NET applications. After the class, participants will be able to use LINQ to work with in-memory objects, XML, and relational data. New .NET 4.0 features such as the Entity Framework's POCO support and Parallel LINQ (PLINQ) are covered for clients running Visual Studio 2010 or later.

Objectives

At the end of LINQ Training course, participants will:

• Understand the architecture and benefits of using LINQ
• Become proficient with the new language features added to support LINQ
• Write a variety of LINQ expressions to sort, filter, and re-shape data
• Leverage LINQ’s differed execution capability in an n-tier application
• Use LINQ to XML to create, query, and transform XML data
• Understand the options for using LINQ with relational data
• Learn about the ADO.NET Entity Framework and it's new support for Plain-Old CLR Objects (POCO) [.NET 4.0 only]
• Use Parallel LINQ (PLINQ) and learn to recognize when it's appropriate to use [.NET 4.0 only]

Suggested Audience - This class is intended for experienced C# software developers. No knowledge of LINQ is assumed.

Duration - 2 Days

Prerequisites - All participants should have prior experience developing applications in .NET 2.0 or later using C# or Visual Basic and some familiarity with the use of interfaces and generics

Syllabus

1. Language Extensions Implicitly typed variables Extension methods Object initialization syntax Anonymous types Lambda expressions	2. Introduction to LINQ LINQ expressions Using via extension methods Filtering Sorting Aggregation Skip and Take operators Joins
3. Deferred Execution Benefits and drawbacks IEnumerable vs IQueryable Using across tiers	4. Data Projection Single result value Existing types Anonymous types Grouping
5. LINQ to XML New XML classes Generating XML Querying XML Using data projection Combining with XPath	6. LINQ to SQL Attributes and mapping Creating a DataContext Deferred loading Saving changes Inserts and deletes Transactions Concurrency Handling exceptions
7. LINQ to Entities ADO.NET Entity Framework Differences from LINQ to SQL Available providers Defining an Entity Data Model (EDM) Database-first vs. Model-first Object Services Change tracking Using EntityClient Using stored procedures Plain-Old CLR Object support (POCO) [.NET 4.0 only] N-tier and service-based applications	8. Parallel LINQ (PLINQ) [.NET 4.0 only Introduction to the Task Parallel Library (TPL) Using PLINQ with in-memory objects PLINQ and XML PLINQ with relational providers