2015
Lynda
Olivia Chiu
1:36
English
Want an easy way to query and update data? To query different data stores with a single tool? LINQ is the answer. Language-Integrated Query (LINQ) extends Visual Studio with powerful query capabilities based on C# and Visual Basic. LINQ makes big data doable.
In LINQ with C# Essential Training, engineer Olivia Chiu introduces techniques for querying, updating, and transforming data with LINQ. She covers standard queries—such as finding overlaps in two datasets and creating hierarchies—as well as complex chained queries. She also shows how to group and join LINQ queries with lambda expressions, and use LINQ to query SQL databases and XML documents. Last but not least, Olivia provides tips for optimizing the performance of your queries.
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
lynda.com/LINQ-tutorials/LINQ-C-Essential-Training/397357-2.html
Download File Size:282.33 MB
|
