LINQ with C# Essential Training

Learn how to easily query and update multiple data stores, including SQL and XML, with a single tool: LINQ, Visual Studio's Language-Integrated Query framework.

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

Conclusion

• Next steps