1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Programming LINQ and C# Extended Features: Hands-On

Streamlining Data-Centric Applications
 
Course: 973   Type: Hands-On Training   Duration: 4 Days
 
 

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. .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 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

Related Courses

  

Upcoming Dates

Mar 3 - 6, 2009
 New York
Mar 17 - 20, 2009
 Washington, DC (Alexandria, VA)
Mar 24 - 27, 2009
 Los Angeles
Mar 24 - 27, 2009
 Ottawa
Apr 21 - 24, 2009
 Chicago (Schaumburg)
Apr 28 - May 1, 2009
 Washington, DC (Reston, VA)
May 26 - 29, 2009
 Toronto
Jun 2 - 5, 2009
 Washington, DC (Rockville, MD)
Jun 9 - 12, 2009
 New York
Jun 23 - 26, 2009
 Washington, DC (Alexandria, VA)
Jul 14 - 17, 2009
 Ottawa
Jul 21 - 24, 2009
 Los Angeles
Jul 28 - 31, 2009
 Chicago (Schaumburg)
Aug 4 - 7, 2009
 Washington, DC (Reston, VA)
Aug 25 - 28, 2009
 Toronto

For complete schedule, please visit www.learningtree.com
 
http://www.lerningtree.com/courses/973pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Programming LINQ and C# Extended Features: Hands-On

Streamlining Data-Centric Applications
 
Course: 973   Type: Hands-On Training   Duration: 4 Days
 
 
Course 973 Content
 

Introduction

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

Harnessing 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, outer and group 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
 
http://www.lerningtree.com/courses/973pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Programming LINQ and C# Extended Features: Hands-On Tuition

Streamlining Data-Centric Applications
 
Course: 973   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 45%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,625 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.lerningtree.com/courses/973pf.htm