Customer Service or Enrol: 0800 282 353 or +44 1372 364610
 

Programming C# Extended Features: Hands-On
Streamlining Data-Centric Applications with LINQ

Course: 973   Type: Hands-On   Duration: 4 Days
Quick Enrol  

You Will Learn How To

  • Streamline data-centric applications with C# extended features including LINQ
  • Apply lambda expressions and extension methods for middle-tier data processing
  • Exploit Language Integrated Query (LINQ) keywords to filter and order data
  • Access databases with DataContext objects and advanced LINQ-to-SQL techniques
  • Generate dynamic enumeration using IEnumerable<T> within developer-written generic classes
  • Leverage LINQ to write stored procedures in C# and simplify XML processing

Course Benefits
C# has evolved since its introduction into a full data-manipulation language. New .NET 3.5 extended features enable programmers to streamline code, increase productivity and improve overall performance of applications. In this course, you apply .NET 3.5 extended features, including LINQ, to effectively integrate the object-oriented and data-manipulation capabilities of C# 3.0.

Who Should Attend
Experienced C# programmers who want to improve their software development capabilities by using the new and extended language features, and in particular Language Integrated Query (LINQ). C# programming experience at the level of Course 419, "C# Programming: Hands-On", is assumed.

Hands-on Training
Exercises using a progressive case study provide experience applying C# extended features and include:
  • Applying implied properties and object initialisers
  • Writing lambda expressions and extension methods
  • Implementing the data tier with LINQ
  • Employing DataContext objects and LINQ query keywords to access and update a database
  • Publishing entity classes using the O/R Designer
  • Achieving dynamic enumerations with yield
  • Parsing XML documents using LINQ
  • Installing C#/LINQ stored procedures

Course Content
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 orderby
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 groupby
  • 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
  

request more info Salutation*:

First Name*:

Last Name*:

Job Title:

Company*:

Post Code*:

Country*:
   Codes
Office Telephone*:

Extension:

E-mail*:

* Required

A Learning Tree representative will contact you to follow up your request for information.

Save 55%
Programming C# Extended Features
Course Schedule
26 - 29 Aug, 2008
London
21 - 24 Oct, 2008
London
6 - 9 Jan, 2009
London
31 Mar - 3 Apr, 2009
London

Participants integrating the object-oriented and relational models in C#.

£ 1,695 - Standard Tuition
Savings Plans
£ 1,080 - 10-Day Training Pass
£ 995 - Flex-Training Passport
£ 1,215 - 10-Training Vouchers
£ 1,300 - 5-Training Vouchers
£ 1,525 - Alumni Gold Tuition

 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610