Introduction to LINQ

• Language Integrated Query
• Structure of a LINQ Query
• Some LINQ Examples

Language Enhancements for LINQ

• LINQ and Languages
• Implicity Typed Local Variables and Object Initializers
• Lambda Expressions, Extension Methods, and Anonymous Types

LINQ to Objects

• Using LINQ with in-Memory Collections
• LINQ Operations and Extension Methods

LINQ to SQL

• LINQ and Relational Data
• Creating an Object Model
• Querying Data
• Modifying Data
• Using Stored Procedures
• LINQ to SQL vs. DataSets

More LINQ to SQL

• LINQ to SQL Advanced Features
• Using LINQ to SQL in a Windows Application
• Using LINQ to SQL in a Web Application

LINQ to DataSet

• Review of DataSets
• Querying Data with LINQ to DataSet
• LINQ to DataSet and DataViews
• Binding to Data

LINQ to XML

• Create and Manipulating XML Content
• Using LINQ to Query XML Content
• Transforming XML Using LINQ

LINQ to Entities

• Overview of Entry Framework
• Creating an Entity Data Model
• Querying Data
• Modify Data
• Using Stored Procedures

What You Can Expect

At the end of this course, delegates will be able to:

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