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.
LINQ introduced radical changes to the C# language. In this course, LINQ Fundamentals with C# 6.0, 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.
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.
Hi, this is Scott Allen, and welcome to my course on the language integrated query features of C#. I’ve 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 to not just use LINQ, but use LINQ effectively.
In this course we’ll use LINQ to query various datasoruces, with some real, pragmatic examples, like fidning 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. Finally, we’ll also how LINQ works when we need to query XML or a relational database elike 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, and how just little buits of code can solve tough problems. I do expect that you are already somewhat 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 PLualsight.com that can help there, too.