Training Courses
Course Outline for LINQ Using C# Training

What is LINQ?

Language Integrated Query was introduced as new component of .Net framework 3.5. The basic function of LINQ is to add native data querying capabilities to .Net Framework by using the syntax similar to SQL. LINQ allows you to define statements that query a data source to generate the requested result set. LINQ is a programming model that is used to provide a consistent method to obtain and manipulate data. LINQ is a programming model that is used to provide a consistent method to obtain and manipulate data. In C#, you can use LINQ directly within query expressions, which are used to query and transform data from a LINQ enabled data source.

CURRICULUM

LINQ

Module

Module

  • 2.1 LINQ expressions
  • 2.2 Using via extension methods
  • 2.3 Filtering
  • 2.4 Sorting
  • 2.5 Aggregation
  • 2.4 Skip and Take operators
  • 2.5 Joins
    •

Module

  • 3.1 Benefits and drawbacks
  • 3.2 IEnumerable vs IQueryable
  • 3.3 Using across tiers
    •

Module

  • 4.1 Single result value
  • 4.2 Existing types
  • 4.3 Anonymous types
  • 4.4 Grouping

Module

  • 5.1 New XML classes
  • 5.2 Generating XML
  • 5.3 Querying XML
  • 5.4 Using data projection
  • 5.5 Combining with XPath
    •

Module

  • 6.1 Attributes and mapping
  • 6.2 Creating a DataContext
  • 6.3 Deferred loading
  • 6.3 Saving changes
  • 6.3 Inserts and deletes
  • 6.3 Transactions
  • 6.3 Concurrency
  • 6.3 Handling exceptions
    •

Module

  • 7.1 ADO.NET Entity Framework
  • 7.2 Differences from LINQ to SQL
  • 7.3 Available providers
  • 7.4 Defining an Entity Data Model (EDM)
  • 7.5 Database-first vs. Model-first
  • 7.6 Object Services
  • 7.7 Change tracking
  • 7.8 Using EntityClient
  • 7.9 Using stored procedures
  • 7.10 N-tier and service-based applications
    •
;