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.
Course info
Rating
(685)
Level
Intermediate
Updated
Jul 28, 2016
Duration
4h 22m
Table of contents
Course Overview
An Introduction
LINQ and C#
LINQ Queries
Filter, Ordering & Projecting
Joining, Grouping & Aggregating
LINQ to XML
LINQ and the Entity Framework
Description
Course info
Rating
(685)
Level
Intermediate
Updated
Jul 28, 2016
Duration
4h 22m
Description

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.

Course FAQ
Course FAQ
What is LINQ?

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.

What will I learn in this course?

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
Who is this course for?

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.

Are there prerequisites to this course?

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
About the author

Scott has over 15 years of experience in commercial software development and is a frequent speaker at national conferences, and local user groups. Scott is a Microsoft MVP and has authored books on several Microsoft technologies, including ASP.NET, C#, and Windows Workflow.

More from the author
ASP.NET Core Fundamentals
Beginner
5h 44m
Sep 27, 2019
ASP.NET MVC 5 Fundamentals
Beginner
5h 45m
Aug 29, 2019
More courses by Scott Allen
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi. This is Scott Allen, and welcome to my course on the Language Integrated Query features of C#, or LINQ. I have found LINQ to be an invaluable tool for everyday programming tasks, and in this course I want to walk you through all the fundamentals you need to know not just to use LINQ, but to use LINQ effectively. In this course, we will use LINQ to query various data sources with some real pragmatic examples, like finding the most fuel efficient cars in a set of over 1200 cars. We'll also learn about features in the C# language that form the foundation of LINQ, features like extension methods and lambda expressions. I'm also going to share some tips and tricks I've learned over the years, like tips to avoid performance problems and tricks to write more maintainable code. I'm also going to show you how LINQ works when we need to query XML or a relational database like SQL Server. By the end of the course, you'll be able to start using LINQ in your own applications, and I think you'll see LINQ can be used in many different scenarios. It can solve tough problems using just little bits of code. I do expect that you are already familiar with the C# language. In particular, understanding generics and using generic types will make this course easier. If you need a primer on the C# language or on generics specifically, I have courses on Pluralsight.com that can help there too.