Language Integrated Query (LINQ) Training

LINQ Training Overview
LINQ training classes teaches attendees how to use Language Integrated Query to query arrays, enumberable classes, relational databases, and a wide variety of other relational and object-based data sources.
Prerequisites
      Basic Understanding Knowledge of .NET 2.0 or 3.5 using C# or VB.NET
LINQ Training Objectives

       Master new features in the latest releases of C# and/or VB.NET

       Learn the fundamentals of the LINQ syntax and how to build queries in LINQ
       Discover how to use LINQ to query relational databases
       Understand how to use LINQ to query XML data sources
LINQ Training Outline
1.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

2.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

3.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

4.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

5.Advanced 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

6. 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

7.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