Programming C# Extended Features: Hands-On Training Class

• 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 delegates
• Generate dynamic enumerations using IEnumerable within developer-written generic classes
• Leverage LINQ to write stored procedures in C# and simplify XML processing

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 Where, OrderBy 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 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
• Converting from IEnumerable to List

Adapting LINQ and EF

Comparing ADO.NET with LINQ

• DataSet objects vs. generic lists
• SqlDataReader vs. IEnumerable
• 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 and IEnumerator
• 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 int
  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
  • Installing C#/LINQ stored procedures