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 via the Entity Framework (EF)
  • Generate dynamic enumerations 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 C# 3.0 extended features, including LINQ, to effectively integrate the object-oriented and data-manipulation capabilities.

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," is assumed.

Hands-On Training
Exercises using a progressive case study provide experience applying C# extended features and include:
  • Applying auto-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
  • Mapping 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 C# 3.0 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, OrderBy and other extension methods
  • Passing types and functionality into methods
Applying extended features
  • Making code more flexible with delegates
  • Parameterizing delegates and lambda expressions
  • Streamlining code with anonymous types
Leveraging LINQ Query Keywords
Syntax and semantics
  • Coding LINQ queries
  • Ordering data and objects
  • Filtering using from, where, orderby and group
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 databases via the Entity Framework (EF)
  • Correlating entity classes and data tables
  • Preserving the object-oriented paradigm
The Object Relational Designer tool
  • Mapping 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
  • 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
  • Enhancing 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

Related Courses
  
 
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 an EXTRA $200 on a 10-Day Training Pass!

Programming C# Extended Features: Hands-On
Upcoming Dates
Sep 2 - 5, 2008
 New York
Oct 14 - 17, 2008
 Washington, DC (Reston, VA)
Nov 11 - 14, 2008
 Los Angeles
Nov 18 - 21, 2008
 Toronto
Nov 18 - 21, 2008
 Washington, DC (Rockville, MD)
Dec 2 - 5, 2008
 New York
Dec 9 - 12, 2008
 Washington, DC (Alexandria, VA)
Dec 16 - 19, 2008
 Ottawa
Jan 13 - 16, 2009
 Chicago (Schaumburg)
Jan 20 - 23, 2009
 Washington, DC (Reston, VA)

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

Course Tuition
$ 2,650 Standard Tuition
Tuition with a Savings Plan
$ 1,580 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#.


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