Introduction to Language Integrated Query (LINQ)

Take this class

Click here to request this course on a different date.

This course provides students with the skills and knowledge required to maximize LINQ functionality in .Net applications.

Fundamentals of LINQ
Using LINQ with Databases
Taking advantage of Object Modeling

Audience

Students should have experience developing .Net applications in either C# or VB.Net

Length: 3 Days (4 Session via web)

Outline

C# 3.0 / VB 9.0 Language Features

Implicit typing of local variables
Extension Methods
Object Initialization Syntax
Collection Initialization Syntax
Anonymous Types
Lambda Expressions

Introduction to LINQ

The Role and Scope of LINQ
Use of Extension Methods / Lambdas with LINQ
Core LINQ Assemblies / Namespaces / Project Types
Examining LINQ Query Operators
The Query Operator - LINQ type relationship
Building LINQ Query Expressions
LINQ Over Objects
LINQ to SQL
LINQ-Centric Attributes and Types
The Role of Entity Classes
Creating Entity Classes using sqlmetal.exe / Visual Studio
The Role of the DataContext
Submitting Queries to Relational Databases
Invoking Stored Procedures

Best Practices

Data Context Management in ASP.NET
Patterns in LINQ
Performance issues