Course Information

Overview

LINQ is the part of the .NET Framework that provides a generic approach to querying data from different data sources. It has quickly become the next must-have skill for .NET developers. This course has the detail you need to grasp Microsoft's new querying technology, and concise explanations to help you learn it quickly.

Prerequisites

Experience with developing ADO.NET using C#.

Outline

  • Implicitly typed variables
  • Extension methods
  • Object initialization syntax
  • Anonymous types
  • Lambda expressions
  • LINQ expressions
  • Using via extension methods
  • Filtering
  • Sorting
  • Aggregation
  • Skip and Take operators
  • Joins
  • Benefits and drawbacks
  • IEnumerable vs IQueryable
  • Using across tiers
  • Single result value
  • Existing types
  • Anonymous types
  • Grouping
  • New XML classes
  • Generating XML
  • Querying XML
  • Using data projection
  • Combining with XPath
  • Attributes and mapping
  • Creating a DataContext
  • Deferred loading
  • Saving changes
  • Inserts and deletes
  • Transactions
  • Concurrenc
  • Handling exceptions
  • ADO.NET Entity Framework
  • Differences from LINQ to SQL
  • Available providers
  • Defining an Entity Data Model (EDM)
  • Database-first vs. Model-first
  • Object Services
  • Change tracking
  • Using EntityClient
  • Using stored procedures
  • N-tier and service-based applications
Dates and Prices

There are currently no public dates for this course. This course can be run as a private course either at one of our training centers or at your offices. To get pricing for this use our quote wizard to generate a customised quote or call us on 0118 324 3000 to discuss your requirements.

image
2 Days

Testimonials

  • Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

    Marianne Seager-Wincanton
  • This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!

    Joris Latinne-Oracle