1-800-THE-TREE (1-800-843-8733)
 

Programming C# Extended Features: Hands-On

Streamlining Data-Centric Applications with LINQ

 
Course: 973     Type: Hands-On Training     Duration: 4 Days

Quick Enroll    

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 initializers
  • 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 973 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 initializers
  • 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

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save as much as $2,350 on a Triple-Pack!

Programming C# Extended Features: Hands-On
Upcoming Dates
Jul 15 - 18, 2008
 Washington, DC (Reston, VA)
Aug 5 - 8, 2008
 Los Angeles
Aug 12 - 15, 2008
 Ottawa
Aug 19 - 22, 2008
 Toronto
Aug 19 - 22, 2008
 Washington, DC (Rockville, MD)
Sep 2 - 5, 2008
 New York
Sep 9 - 12, 2008
 Washington, DC (Alexandria, VA)
Sep 23 - 26, 2008
 Chicago (Schaumburg)
Oct 14 - 17, 2008
 Washington, DC (Reston, VA)
Nov 11 - 14, 2008
 Los Angeles

Programming C# Extended Features: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,650 Standard Tuition
Tuition with a Savings Plan
$ 1,660 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,385 Alumni Gold Discount
$ 2,360 Government Discount
 

 

Programming C# Extended Features: Hands-On
Programming C# Extended Features: Hands-On
Participants integrating the object-oriented and relational models in C#.

CPE 23 Credits 1 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733