Introduction to Language Integrated Query (LINQ)

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

Audience

This course is intended for C# or VB.Net developers with experience building ASP.Net, Windows, or assembly projects. Students should also be familiar with basic relational database concepts.

Prerequisites

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

Length: 2 days

Objectives

Learn the fundamentals of LINQ
Using LINQ with relational databases
Take advantage of Object Modeling

Course 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

Persistence Frameworkds like LINQ allow designers to specify extensible, flexible, and reusable applications without burdening developers with tedious SQL.

LINQ not only provides a great persistence framework for developers, it also improves performance in increases security by preventing SQL Injection Attacks.