Request Info

Salutation

First Name

Last Name

Job Title

Department

Mailstop

Company

Address

P.O. Box

City

Province

Postal Code

Country
List

Work Telephone

Ext.

E-mail Address

Information provided will be used to communicate with you about our products.
Privacy Statement

A representative will contact you to follow up your request.

 
Special offer: Free Courses with Training Vouchers.

 

Programming C# Extended Features:
Hands-On

Streamlining Entity Framework Applications


Course 9734 Days

 E-mail E-mail  Print Print  Q&A Q&A  PDF PDF  Facebook Facebook  Twitter Twitter

Quick Enrol

You Will Learn How To

  • Streamline data-centric applications with C# extended features and the Entity Framework (EF)
  • Apply lambda expressions and extension methods for middle-tier processing
  • Exploit Language Integrated Query (LINQ) keywords to filter and order data
  • Transfer complex logic with generic Func<T,R> delegates
  • Generate dynamic enumerations using IEnumerable<T> within developer-written generic classes
  • Leverage LINQ to simplify XML processing

Course Benefits

C# has evolved since its introduction into a full data-manipulation language. .NET extended features enable programmers to streamline data access, increase productivity and improve overall performance of applications. In this course, you apply C# extended features, including LINQ and EF, 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) in conjunction with the Entity Framework. 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 and EF
  • 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
  • Accessing stored procedures with C#/LINQ

Course 973 Content

Introduction

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

Harnessing 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 Count, Reverse, Union, Except 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 Func<T,R> generic delegates

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 and EF

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 an ObjectContext
  • 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
  • Importing stored procedures

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 XML

Exploiting the XML Namespace

  • Loading XML dynamically via the Web
  • Creating and saving XElement content

Processing XML

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

<< Back to C#, C++ and Perl Course List
 

Related Courses

 
Programming C# Extended Features: Hands-On

Training Dates

Live online classroom training. Participate in person or in live, online events (highlighted) via Learning Tree AnyWareTM.

US Dates

Mar 6 - 9Rockville, MD enrol
Apr 17 - 20New York enrol
May 15 - 18Reston, VA enrol
May 29 - Jun 1Rockville, MD enrol
Jul 10 - 13New York enrol
Sep 11 - 14Reston, VA enrol
Sep 18 - 21New York enrol
Oct 16 - 19Rockville, MD enrol
Dec 18 - 21New York enrol

For AnyWare enrolments, please register at least 10 days prior to the start of the course.

More Dates and Locations.

Tuition

$ 3,220Standard Tuition
Tuition with a Savings Plan
$ 2,2952-Course Passport
$ 1,8353-Course Passport
$ 1,7604-Course Passport
$ 2,950Voucher 5-Pack
$ 2,830Government Discount

On-Site &
Custom Training

Bring this or any Learning Tree course to your location or have it customized for your organization.

Programming C# Extended Features: Hands-On

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


Average Attendee Evaluation

Evaluations in the last 12 months

5 stars:
80%
4 stars:
20%
3 stars:   0%
2 stars:   0%
1 star:   0%

 
"I recommend Learning Tree because everything is concise. You learn a lot and get a wealth of experience—more than if you were just reading from a book."

– M. Young
ES (Air) DBI

 
Ten Questions to Ask Your Training Provider - Position Paper

Certification Core Course