4.35 out of 5
4.35
19 reviews on Udemy

Complete Practical LINQ Tutorial in C#

LINQ to Entities, LINQ to Objects, LINQ to XML, Functional Programming and LINQ
Instructor:
Engineer Spock
294 students enrolled
English [Auto-generated]
Understand all the LINQ operations
Filtering, Ordering, Projecting with LINQ
Aggregating with LINQ
Joining, Grouping, Aggregating with LINQ
Converting with LINQ
Generate Data Streams
LINQ to XML
LINQ to Entities
Fundamentals of Functional Programming

Extension methods were introduced in C# 3 and since then became an indispensable part of the .NET platform. That enormously powerful feature allowed to build a whole framework built upon it called LINQ or Language Integrated Query. I’ve seen many code bases which avoid using LINQ and rely on 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, ThenBy, 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

In short, this is a great course, so enroll right now and start learning LINQ and the fundamentals of functional programming.

Introduction to LINQ

1
Download Source Code
2
Outline
3
LINQ Intro
4
Extension Methods
5
Pipelining
6
Why LINQ?
7
The role of IEnumerable
8
Implementing our own LINQ Extensions
9
Parsing a CSV-file
10
Named Methods vs Anonymous Methods vs Lambda
11
Query Syntax
12
Classification of LINQ Operators
13
Yield Return
14
LINQ. Deferred Execution
15
Exceptions and Deferred Execution
16
LINQ. Closures with for and foreach loops
17
Multiple Enumeration Pitfall
18
Altering Lists
19
Conclusion

Generating Data Streams

1
Outline
2
Empty, Range, Repeat
3
Custom Generator
4
Conclusion

Filtering, Ordering, Projecting

1
Outline
2
Select
3
Where
4
ThenBy
5
First, Last, Single, OrDefault
6
TakeWhile, SkipWhile
7
SequenceEqual
8
Distinct
9
Any, All, Contains
10
SelectMany
11
ElementAt and Counting
12
Conclusion

Joining, Grouping, Aggregating

1
Outline
2
Join
3
GroupBy
4
GroupJoin
5
Zip
6
Min, Max, Sum, Average
7
Concat and Union
8
Intersect and Except
9
Conclusion

Conversions

1
Outline
2
OfType and Cast
3
ToArray, ToList, ToDictionary, ToLookup
4
Pitfalls of Conversion
5
Conclusion

LINQ to XML

1
Outline
2
XML Document Structure
3
Creating XML from a Collection
4
Refactoring Code
5
Reading XML
6
Conclusion

LINQ to Entities

1
Outline
2
Preparing Project
3
Inserting and Reading
4
Pitfalls of LINQ to Entities
5
Expressions, AsEnumerable and AsQueryable
6
Conclusion

Extendibility in C#

1
Outline
2
Defining Functional Programming
3
Functions, Functions, and Functions Again
4
Why Functional Programming
5
Immutability
6
Purity and Side Effects
7
Extending IDisposable
8
General Extensions
9
Extending StringBuilder
10
Primitive Obsession
11
Conclusion
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.4
4.4 out of 5
19 Ratings

Detailed Rating

Stars 5
9
Stars 4
7
Stars 3
3
Stars 2
0
Stars 1
0
6c60062a3c8df50686d25e3523ecb747
30-Day Money-Back Guarantee

Includes

5 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion