Learning Tree International

Visual Studio and .NET Courses

0800 282 353 or +44 1372 364610
 

Request Info

Salutation

First Name

Last Name

Job Title

Company

Post Code

Country
List

Office Telephone

Extension

E-mail

A representative will contact you to follow up your request.

Save 50%
 

Programming C# Extended Features: Hands-On


Course 9734 days

  E-mail a Colleague  Print Friendly  FAQ  Course Details PDF

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 data processing
  • Exploit Language INtegrated Query (LINQ) keywords to filter and order data
  • Simplify complex logic with generic Func<T,R> delegates
  • 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 extended features enable programmers to streamline code, 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 initialisers
  • 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
  • Installing C#/LINQ stored procedures

Course 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 initialisers
  • 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
  • Parameterising 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

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

<< Back to Visual Studio and .NET Course List

Related Courses

 
Programming C# Extended Features
Programming C# Extended Features: Hands-On

Course Dates

3-6 AugLondon enrol
1-4 FebLondon enrol

Attend highlighted events
in person or online with Learning Tree AnyWareTM.

More Dates and locations.

On-Site &
Custom Training

Bring this or any Learning Tree course to your location or have it customised for your organisation.

Tuition

£ 1,825 Standard Tuition
Tuition with a Savings Plan
£ 1,000Flex-Training Pass
£ 1,00010-Day Training Pass
£ 1,520Voucher 10-Pack
£ 1,645Alumni Gold Discount
 
Programming C# Extended Features: Hands-On

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

 
"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. It's a concentrated period of time that gives you exactly what you need and more".

M. Young
Security Officer
ES (Air) DBI



Certification Core Course