Toll Free: 800-735-7418
Local: 303-377-9333
info@hartmannsoftware.com
 
 

 
COMPLETE LINQ

Course Description  
.NET 3.5 introduces significant updates to the C# and VB programming languages, many of which are specifically used to enable Language Integrated Query (LINQ). This course begins by detailing each of these new language features (including extension methods and lambda expressions). Once the foundation has been laid, students will learn to build query expressions using LINQ query operators and the underlying LINQ object model. The remainder of the class will examine how to apply these query expressions to object containers, relational databases and XML documents.

Course Length: 2 Days
Course Tuition: $790 (US)
Prerequisites
A solid understanding of Object Oriented Programming using C# or VB is required.
Course Outline  


• Core .NET 3.5 Language Features
Introducing the Core .NET 3.5 Language Changes
Introducing Implicitly Types Local Variables
C# and Implicit Typing
Visual Basic and Implicit Typing
Final Details of Implicit Typing
Understanding Extension Methods
Extending Interfaces with Extension Methods
Understanding Object Initialization Syntax
Understanding Anonymous Types
Internal Composition of Anonymous Types
Understanding the Role of Lambda Expressions
A First Look at Lambda Expressions
Dissecting a Lambda Expression
Lambdas with Multiple Arguments/No Arguments
C#-Specific Lambdas Operations

• An Introduction to LINQ
Understanding the Role of LINQ
Visual Studio 2008 LINQ Query Support
LINQ Assemblies and Namespaces
A First Look at a LINQ Query Expression
Introducing LINQ to Objects
LINQ Over Non-Generic Collections using the OfType() Method
Introducing the LINQ Query Operators
Basic LINQ Selection Statements
Obtaining Filtered Subsets
Projecting New Forms of Data
Reversing and Sorting Results
Obtaining a Count for a Result Set
Obtaining Differences, Intersections, and Unions of LINQ Result Sets
Aggregation Operations
The Role of Deferred Execution
Forcing Immediate Execution
The Internal Representation of a LINQ Query


• Introduction to LINQ to ADO.NET
Understanding the Role of LINQ to ADO.NET
Introducing LINQ to DataSet
Programming with LINQ to DataSet
The Role of LINQ to SQL
The Role of Entity Classes
The [Table] and [Column] Attributes
The Role of the DataContext Type
Programming with LINQ to SQL
Generating Entity Classes Using SqlMetal.exe
Generating Entity Classes Using Visual Studio

• An Introduction to LINQ to XML
Introducing LINQ to XML
Introducing the LINQ to XML Object Model
Creating New XML Documents
Loading Existing XML Documents into Memory
Navigating an In-Memory XML Document
Inserting and Removing Data
Understanding Visual Basic XML Literal Syntax
Blending Programming within an XML Literal
Creating XML Content Using VB XML Literals
XML Literal Syntax and LINQ Query Integration
The Role of VB XML Axis Properties

Contact us for course schedules or more information.
 

Registration and Pricing
The Virtual Classroom
Mentoring Services


Fresh Off The Press MySQL Admin/Dev
Sharepoint for Developers
Advanced XML
Securing Java Web Services
Exploring Design Patterns
Fast Track to Java EE
Ajax using C# (VS 2008) Oracle 11G New Features Complete LINQ