Introduction
Welcome
()
What you should know
()
Use the exercise files
()
1. Introduction to LINQ
What is LINQ?
()
Common use cases
()
2. Basic LINQ Queries
Select a data source
()
Create a query
()
Execute a query
()
3. Data Transformation
Return results as a new type
()
Perform operations on source elements
()
4. Type Relationships
Queries that use the source type
()
Queries that change the source type
()
Allow the compiler to select type
()
5. Standard Queries
Subsets with the filter operator
()
Rearrange data with the orderby operator
()
Parse basic groups
()
Find overlap between datasets
()
Create hierachy in a dataset
()
Output data with the select operator
()
6. Lambda Expressions
Lambda expressions
()
Index and distinct operators
()
Take and skip operators
()
Order queries with lambda expressions
()
Group queries with lambda expressions
()
Join queries with lambda expressions
()
Select queries with lambda expressions
()
7. Complex Queries
Chaining
()
Use the into keyword
()
Use the let keyword
()
8. LINQ to SQL
Database setup
()
Database query
()
Database updates
()
9. LINQ to XML
Tree creation
()
Tree queries
()
10. Other Operators
Use OfType to convert to IEnumerable
()
Sequences, elements, and scalars
()
11. Performance
Memory allocation
()
Best practices
()
Ex_Files_LINQ_CSharp_EssT.zip
(5.5 MB)