Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

.NET/Visual Studio Training









Preferred method of contact?

Programming C# Extended Features

COURSE TYPE

Advanced

Course Number

973

Duration

4 Days

Enroll

About This Course: 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 Entity Framework (EF), to effectively integrate the object-oriented and data-manipulation capabilities.

You Will Learn How To

  • Streamline data-centric applications with C# extended features and the Entity Framework (EF)
  • Apply lambda expressions and extension methods
  • Exploit LINQ keywords to filter and order data
  • Generate dynamic enumerations in developer-written generic classes
  • Leverage LINQ to simplify XML processing

Course Outline

  • Introduction
  • 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
  • Employing Extension Methods for Middle-Tier Data Manipulation

Filtering and ordering data with lambda expressions

  • Comparing delegates and lambda expressions
  • Calling Count, Reverse, Union, Except and other extension 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 with from, where, orderby and group

Iterating collections

  • Interfacing between C# and LINQ using IEnumerable<T>
  • Issuing queries on entity and spatial types
  • Attaching to Databases via the Entity Framework

Comparing ADO.NET with LINQ

  • DataSet objects vs. generic lists
  • SqlDataReader vs. IEnumerable<T>
  • Implementing accessors to separate the data tier

Connecting to and reading from a database

  • Establishing an ObjectContext and DbContext objects
  • Correlating entity classes and data tables
  • Executing stored procedures and table-valued functions

The Object Relational Designer tool

  • Mapping data tables to entity classes (table-first) and object models to database tables (code-first)
  • Inheriting with many-per-table and table-per-type (TPT)

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
  • Issuing LINQ geographic/geometric queries on spatial types
  • Applying LINQ to XML

Processing XML

  • Loading XML dynamically via the web
  • Creating and saving XElement content
  • Parsing documents, elements and attributes
  • Walking an XML document using LINQ
Show complete outline
Show Less

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Dec 6 - 9 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Dec 19 - 22 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 17 - 20 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 7 - 10 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 14 - 17 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Apr 18 - 21 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 2 - 5 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 30 - Jun 2 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 20 - 23 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 8 - 11 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Sep 5 - 8 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2990

Government

$2659

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

“The instructor for C# Extended Features was exceptionally effective in his use of examples and presentation of the material … After taking this course, I feel prepared for the expansion of my programming duties at work and will be using .NET as the primary language for applications.”

- M. Accetta, Senior Programmer
The Bessemer Group

Prev
Next