New Horizons Computer Learning Center
410-597-9722

Microsoft Language Integrated Query (LINQ)

Course Length: 2 Days

Overview:
The forthcoming .NET 3.5 Framework SDK will ship with numerous updates to the C# and VB programming languages. In this course, attendees will dive into the current Community Technology Preview (CTP) and explore these new programming constructs first hand. Once the core language features have been examined, the remainder of the course will examine LINQ (Language Integrated Query) and the core APIs which represent it: LINQ over Objects, LINQ to SQL and LINQ to XML.

Course Objectives:
Upon successful completion of this course, students will be able to:

• Learn C# 3.0 language features
• Learn VB 9.0 language features
• Learn the LINQ API

Course Content

Lesson 1: 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

Lesson 2: 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

Lesson 3: LINQ to SQL (aka, DLINQ)

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

Lesson 4: LINQ to XML (aka, XLINQ)

• XLINQ-Centric Attributes and Types
• Generating and persisting XML documents
• XLINQ as a Better DOM
• Navigation of XML data
• Inserting, Updating, Deleting XML Content

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com