Extension methods were introduced in C# 3 and since then have become an indispensable part of the .NET platform. This enormously powerful feature has allowed us to build a whole framework built upon it called LINQ or Language Integrated Query. I’ve seen many code bases that avoid using LINQ and rely on the old procedural style of programming. If you still feel yourself uncomfortable with LINQ or you want to improve your understanding of LINQ, then this course is for you. As you might know, LINQ was inspired by functional paradigm and F# in particular. So, this course is not only about LINQ but about the fundamentals of functional programming as well. This course covers: •The basics of LINQ: extension methods, the idea of pipelining, IEnumerable, implementing our own extension, query syntax, pitfalls of LINQ operations, how to alter a list •Generating data streams: Enumerable class and its main operations, implementing your own extension which generates a stream of data •Filtering, ordering, projecting: parsing a CSV file, then, First, Last, Single, TakeWhile, SkipWhile, Any, All, Contains, SequenceEqual, Select and SelectMany •Joining, grouping, aggregating: Join, Group, GroupJoin, Zip, Sum, Average, Min, Max •Conversions: OfType, Cast, ToArray, ToList, ToDictionary, ToLookup, AsEnumerable, AsQueryable •LINQ to XML: overview, generating XML from a collection, reading XML •EF and LINQ: expression trees, inserting into and reading from a database •Extendibility in C#: what is functional programming (FP), purity and side effects, extending IDisposable, general-purpose extensions, extending StringBuilder, Primitive Obsession Enroll now and start learning LINQ and the fundamentals of functional programming. All the codes and supporting files for this course are available at - https://github.com/PacktPublishing/Complete-Practical-LINQ-Tutorial-in-C-