Language Integrated System

QTarget Audience/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.
Course Description: In this course, you will 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 will learn about the new language features added to Visual C# in Visual Studio 2008 in order to make LINQ possible. You will 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 have completed the course, you will 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 C# that support LINQ.

LINQ Intro
• Introduction
• Data Access In the Past
• Data Access APIs
• Object/Relational Mapping
• But Challenges Still Remain
• LINQ
• LINQ and Visual Basic/C#
• LINQ and Language Features
• LINQ Overview
• LINQ Providers
• Structure of a LINQ Query
• Three Stages of a LINQ Query
• Demo: Numbers > 5
• The Data Source
• XML as Data Source
• SQL as Data Source
• The Query
• The Query Execution
• Returning Multiple Values
• Demo: Multiple Values
• Using an Anonymous Type
• Demo: Anonymous Type
• Deferred Execution
• Demo: Deferred Execution
• Force Execution
• Demo: Forcing Execution
• Summary
LINQ Examples
• Introduction
• LINQ to Objects
• Demo: LINQ to