LINQ Fundamentals
Big changes have been made to C# thanks to LINQ. This course will give you everything you need to work with the Language Integrated Query (LINQ) features of C#, using practical examples and demonstrating some best practices.
What you'll learn
LINQ introduced radical changes to the C# language. In this course, LINQ Fundamentals you'll see features of the C# language that make LINQ work, as well as how to use LINQ effectively using practical examples. You'll start with seeing a demonstration of the power of LINQ along with some of the important features of the C# language for LINQ, including how to create and use extension methods and lambda expressions. Next, you'll focus on the behavior of LINQ queries and start to work with realistic data to learn how to filter, order, and project data. Finally, you'll see some demonstrations on how to use LINQ to XML as well as, how LINQ works with a remote datasource by using the Entity Framework against Microsoft SQL Server. By the end of this course, you'll be ready to process and query in-memory data, as well as work with XML and a SQL Server database.
Table of contents
- Introduction 1m
- Creating a Custom Filter Operator 6m
- Creating an Operator with Yield Return 6m
- Deferred Execution Explained 2m
- Taking Advantage of Deferred Execution 6m
- Avoiding Pitfalls of Deferred Execution 4m
- Exceptions and Deferred Queries 3m
- All About Streaming Operators 5m
- Querying Infinity 4m
- Summary 1m
- Introduction 0m
- A File Full of Fuel Efficiency 3m
- How to Process a CSV File with LINQ 2m
- Implementing a File Processor 9m
- Finding the Most Fuel Efficient Car 5m
- Filtering with Where and First 8m
- Quantifying Data with Any, All, Contains 3m
- Projecting Data with Select 7m
- Flattening Data with SelectMany 5m
- Summary 1m
- Introduction 0m
- Adding a Second Data Source 4m
- Joining Data with Query Syntax 6m
- Joining Data Using Method Syntax 7m
- Creating a Join with a Composite Key 3m
- Grouping Data 7m
- Using a GroupJoin for Hierarchical Data 7m
- Challenge Answer: Group by Country 3m
- Aggregating Data 4m
- Efficient Aggregation with Extension Methods 8m
- Summary 1m
Course FAQ
LINQ stands for Language Integrated Query. It is a Microsoft .NET Framework component for adding native data querying capabilities to .NET languages (C#), eliminating the mismatch between programming languages and databases.
In this LINQ course you will learn everything you need to work with the Language Integrated Query (LINQ) features of C#, including:
- What is LINQ
- The power of IEnumerable
- Lambda expressions
- LINQ queries
- Deferred execution
- Exceptions and deferred queries
- Filter, ordering, and projecting
- Joining, grouping, and aggregating
- Loading and querying XML with LINQ
- Setting up the Entity Framework
- Much more
This course is for anyone who wants to learn LINQ C#, how it works, and how to use LINQ effectively. If you want to learn how to process and query in-memory data and work with XML and SQL Server databases, this course is for you.
Before taking this course you should already be familiar with the C# language and principles, especially generics and using generic types. If you need a refresher, or you need to learn it for the first time, check out this C# course.
About the author
Scott has worked on everything from 8-bit embedded devices to large scale web sites during his 15+ years in commercial software development. Since 2001, Scott has focused on server-side and web technologies, like ASP.NET, ASP.NET AJAX, Windows Workflow, Silverlight, and LINQ. Scott is also a speaker at national conferences like VSLive!, as well as code camps and user groups near his hometown of Hagerstown, MD. Scott has been recognized as a Microsoft MVP since 2005, and has written or co-... more