Overview
-
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.
Syllabus
-
Introduction
- Welcome
- What you should know
- Use the exercise files
- What is LINQ?
- Common use cases
- Select a data source
- Create a query
- Execute a query
- Return results as a new type
- Perform operations on source elements
- Queries that use the source type
- Queries that change the source type
- Allow the compiler to select type
- 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
- 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
- Chaining
- Use the into keyword
- Use the let keyword
- Database setup
- Database query
- Database updates
- Tree creation
- Tree queries
- Use OfType to convert to IEnumerable
- Sequences, elements, and scalars
- Memory allocation
- Best practices
- Next steps
