1-888-THE-TREE (1-888-843-8733)
PRODUCTIVITY THROUGH EDUCATION®
 

Programming C# Extended Features: Hands-On

Streamlining Entity Framework Applications
 
Course: 973   Duration: 4 Days
 
 

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

Related Courses

  

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
Apr 17 - 20New York 
May 15 - 18Reston, VA
May 29 - Jun 1Rockville, MD
Jul 10 - 13New York 
Sep 11 - 14Reston, VA
Sep 18 - 21New York 
Oct 16 - 19Rockville, MD
Dec 18 - 21New York 

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


For complete schedule, please visit www.learningtree.ca
http://www.learningtree.ca/courses/973pf.htm
 
 
1-888-THE-TREE (1-888-843-8733)
PRODUCTIVITY THROUGH EDUCATION®
 

Programming C# Extended Features: Hands-On

Streamlining Entity Framework Applications
 
Course: 973   Duration: 4 Days
 
 
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
http://www.learningtree.ca/courses/973pf.htm
 
 
1-888-THE-TREE (1-888-843-8733)
PRODUCTIVITY THROUGH EDUCATION®
 

Programming C# Extended Features: Hands-On Tuition

Streamlining Entity Framework Applications
 
Course: 973   Duration: 4 Days
 
 
Course 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

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
  
 

Tuition Savings Plans

2-Course Passport
  • 2 Courses in 12 months for $4,590
  • As little as $2,295 per course
  • Savings up to 35% per course
3-Course Passport
  • 3 Courses in 24 months for $5,500
  • As little as $1,835 per course
  • Savings up to 50% per course
4-Course Passport
  • 4 Courses in 24 months for $7,035
  • As little as $1,760 per course
  • Savings up to 50% per course
Training Vouchers
  • Save as much as $1,080 per course
  • Fully transferable
  • As low as $2,895 per course
Exact savings may vary depending on courses selected.

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!

Enrol 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 enrolment. Pay after you've taken the course, and then only if you are 100% satisfied.
http://www.learningtree.ca/courses/973pf.htm