Introduction

• Review of object-oriented programming
• Implementing to an interface
• Existing data-access technologies
• Generic and non-generic collections

Harnessing New .NET 3.5 C# Language Features

Language shortcuts

• Applying auto-implemented properties
• Benefiting from implied-type declaration

Streamlining program logic

• Instantiating entity objects
• Simplifying construction with object initialisers
• Anonymous object construction

Employing Extension Methods for Middle-Tier Data Manipulation

Filtering and ordering data with lambda expressions

• Constructing lambda expressions
• Comparing delegates and lambda expressions
• Calling Where and OrderBy extension methods
• Passing types and functionality into methods

Applying extended features

• Making code more flexible with delegates
• Sorting with delegates
• Streamlining code with anonymous types

Leveraging LINQ Query Keywords

Syntax and semantics

• Coding LINQ queries
• Ordering data and objects
• Filtering using from, where and order by

Iterating collections

• Interfacing between C# and LINQ using IEnumerable<T>
• Converting from IEnumerable<T> to List<T>

Adapting LINQ to SQL

Comparing ADO.NET with LINQ

• DataSet objects vs. generic lists
• SqlDataReader vs. IEnumerable<T>
• Processing data-tier information

Connecting to and reading from a database

• Establishing a DataContext
• Attaching to a database with LINQ
• Correlating entity classes and data tables
• Preserving the object-oriented paradigm

The Object Relational Designer tool

• Publishing data tables to entity classes
• Establishing inheritance relationships

Updating a database

• Inserting, updating and deleting data
• Error handling and exceptions
• Committing and rolling back transactions

Enumerations and Generic Classes

Examining enum

• Comparing IEnumerable<T> and IEnumerator<T>
• Generating dynamic enumeration
• The yield keyword

Writing generic classes

• Reducing duplicate classes
• Implementing a generic fast enumerator

Processing Data with LINQ Queries

Manipulating data

• Combining and aggregating similar data with group by
• Performing inner and outer joins
• Generating data subsets with the into clause

Advanced LINQ techniques

• Creating anonymous query results
• Retrieving composite views using nested from clauses
• Simplifying LINQ queries using delegates and lambda expressions

Applying LINQ to Stored Procedures and XML

Exploiting stored procedures

• Writing stored procedures in C#
• Calling stored procedures

Processing XML

• Retrieving the document, elements and attributes
• Parsing an XML document using LINQ