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.
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 enrollments, please register at least 10 days prior to the start of the course.


For complete schedule, please visit www.learningtree.com
 
http://www.learningtree.com/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.com/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
$ 2,890Standard Tuition
Tuition with a Savings Plan
$ 1,700Premium-Pass
$ 1,833Training Passport
$ 2,250Voucher 10-Pack
$ 2,267Triple-Pack
$ 2,573Government Discount
$ 2,600Alumni Gold 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,833 per course
  • Savings as much as 40%
  • Only $5,500
Premium Pass
  • 4 courses in 24 months
  • As little as $1,700 per course
  • Save as much as 45%
Training Vouchers
  • Save as much as $1,040 per course
  • Fully transferable
  • As low as $2,250 per course
Triple-Pack
  • 3 courses for anyone in your organization
  • As little as $2,266 per course
  • Only $6,799
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $320 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.learningtree.com/courses/973pf.htm