Mastering LINQ with C# Training Course

Introduction

LINQ Basics

• IEnumerable<T>
• IEnumerator<T>
• Projection, filtering, quantifiers, partitions, operations, etc.

Overview of LINQ Operators

• Immediate vs deferred executions
• Streaming vs non-streaming operators

Preparing the Development Environment

• Installing and configuring .NET
• Installing and configuring LINQPad

Simple LINQ Queries

• Selecting a data source
• Creating a query
• Executing a query

Data Transformation and Type Relationships

• Returning results as a type
• Performing operations on source elements
• Allowing the compiler to select types

Grouping and Joining LINQ Queries

• Grouping by multiple keys
• Extending a group query
• Grouping with custom keys
• Using inner join with composite key
• Using group join and inner group join

LINQ with Lambda Operators

• Understanding method syntax with Lambda operators
• Grouping by multi-keys
• Grouping by custom keys and custom objects
• Using inner join and composite join
• Using group join and group inner join

Standard and Complex Queries

• Filtering subsets
• Rearranging data with an operator
• Parsing basic groups
• Creating a hierarchy in a data set
• Chaining data
• Using into and let keywords

LINQ to SQL

• Setting up a database
• Querying a database
• Updating a database

LINQ to XML

• Creating a tree
• Using tree queries

Summary and Conclusion