Course Outline
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
Requirements
- An understanding of programming
Audience
- Web Developers
Testimonials (5)
Class was informative and easy to follow.
Najeeda Motala - Multichoice
Course - Advanced C# for Automation Test Engineers
Tailored to our needs
Rafal - Haleon
Course - C#.Net
Flexible approach and tailoring exercises to questions and issues raised by training participants.
Maciej - DataConsult S.A.
Course - Advanced Programming in C#
Machine Translated
Approach of the trainer, lack of time pressure, pleasant atmosphere, conveying knowledge through examples, and verifying knowledge through engaging tasks.
Karolina Kaskosz - Politechnika Morska Szczecin
Course - Programming in C# 7.0 with Visual Studio 2019/2022
Machine Translated
Comprehensive - covered everything we were interested in. Able to work through examples.