30% OFF - Use code HANDSON30 for 30% off any course or Dometrain Pro! Browse courses →
  • Courses
  • Learning Paths
  • Blogs
  • Authors
  • Leaderboard
  • Dometrain Pro
  • Shopping Basket

    Your basket is empty

  • Business Portal
  • From Zero to Hero: LINQ in .NET

    Learn everything about LINQ in .NET, from the basics to advanced techniques. This course covers efficient data querying, filtering, ordering and optimizing operations for high-performance applications

    About This Course

    C# 3 added one of the most revolutionary features of any programming language, and that's none other than LINQ. LINQ has been a flagship feature of C#. Data querying is a fundamental feature of any programming language, but not every language gives developers the tools to do it in an elegant way that reads naturally and is extremely powerful. Even though most developers will get introduced to LINQ early in their C# journey, only a few know how to use it effectively and get the most out of it with the least amount of code. With heavy Microsoft investment, LINQ is improving in every .NET version with better performance and adding new features. In this course, Hannes Lowette will teach you everything there is to know about LINQ and equip you with the knowledge to tackle and querying tasks, whether big or small.

    Course Curriculum

    4h 9m 10 sections
    Welcome
    00:35 Free preview
    What will you learn in this course?
    00:34 Free preview
    Who is the course for and prerequisites
    00:32 Free preview
    Why do we have LINQ?
    05:36
    A language for querying data
    02:02
    A first LINQ example
    05:21
    Why would you want to use LINQ?
    03:34
    Section recap
    00:37
    Introduction to our demo solution
    03:05
    Using a simple where clause
    04:29
    Refactoring statements into functions
    03:45
    Chaining multiple where clauses
    03:18
    Ordering data
    04:00
    Multi-level ordering
    03:24
    Using a custom comparer to order
    02:56
    Section recap
    00:54
    What is deferred execution in LINQ?
    09:33
    Retrieving all results
    09:48
    Retrieving a single item
    10:40
    Projecting the data to another shape
    11:22
    Section recap
    00:43
    Introduction to getting partial results
    02:57
    Splitting results into chunks
    06:20
    Using Skip, Take and TakeWhile to retrieve a specific result
    07:30
    Dividing results into logical parts with GroupBy
    07:30
    Section recap
    00:55
    Introduction
    02:00
    Removing duplicates
    03:10
    Checking for a single item
    03:09
    Verifying all items
    04:10
    Using aggregate functions
    09:51
    Checking if 2 sequences are equal
    02:51
    Section recap
    00:39
    Introduction
    01:26
    Concatenate two results
    01:50
    Set operations on queries with the same type
    10:02
    Exploding a subquery with SelectMany
    07:00
    Join operations between 2 results
    25:25
    Section recap
    00:42
    Introduction
    01:02
    IQueryable vs IEnumerable
    04:38
    What can we write LINQ against?
    03:48
    Making some IEnumerable methods ourselves
    09:07
    IQueryable behind the scenes
    10:47
    Section recap
    01:12
    Why would we want to parallelize our queries?
    02:26
    Introduction to PLINQ
    14:19
    Things to consider when using PLINQ
    06:47
    Potential pitfalls
    07:44
    Section recap
    00:58
    Conclusion
    01:24

    Meet Your Instructor

    Hannes Lowette

    Hannes Lowette

    With 20 years in .NET development, Hannes has always been passionate about performance, databases, distributed systems and large-scale applications. When it comes to architecture, his opinions have become a bit more nuanced, and the "it depends" card, however boring, gets played in many technical discussions. Hannes has always had a passion for sharing knowledge. It doesn't matter whether it is one-to-one while pair programming, on a conference stage giving a talk or when he's helping people succeed in their careers as a coach. In his free time, when he's not building LEGO® castles with his three kids, he likes to stream his guitar building on Twitch and spends too much time playing online chess and doing all-around geeky stuff. You can always lure him into a chat over a glass of great Whisky.

    View all courses by Hannes Lowette

    What's New

    Getting Started: Model Context Protocol (MCP)
    course

    Getting Started: Model Context Protocol (MCP)

    Learn how to get started with the Model Context Protocol (MCP) and integrate it into your applications.

    Learn more about Getting Started: Model Context Protocol (MCP)
    Hands-On: Learn TypeScript
    course

    Hands-On: Learn TypeScript

    Learn TypeScript through hands-on coding exercises. Practice what you learn with interactive challenges designed for every level.

    Learn more about Hands-On: Learn TypeScript
    Hands-On: Learn JavaScript
    course

    Hands-On: Learn JavaScript

    Learn JavaScript through hands-on coding exercises. Practice what you learn with interactive challenges designed for every level.

    Learn more about Hands-On: Learn JavaScript
    Hands-On: Data Structures & Algorithms in C#
    course

    Hands-On: Data Structures & Algorithms in C#

    Master data structures and algorithms through hands-on coding exercises in C#. Free to enroll for 7 days!

    Learn more about Hands-On: Data Structures & Algorithms in C#
    Blogsmith.ai
    feature

    Blogsmith.ai

    Turn your videos into blogs and newsletters with AI. Check out our new product at blogsmith.ai.

    Learn more about Blogsmith.ai
    Leaderboard
    feature

    Leaderboard

    See how you stack up against other learners. Track your progress, climb the ranks, and compete with the Dometrain community.

    Learn more about Leaderboard
    Hands-On: Learn PostgreSQL
    course

    Hands-On: Learn PostgreSQL

    Learn PostgreSQL through hands-on coding exercises. Practice what you learn with interactive challenges designed for every level.

    Learn more about Hands-On: Learn PostgreSQL
    Free Hands-On: C# for Beginners
    course

    Free Hands-On: C# for Beginners

    Learn C# through hands-on coding exercises. Practice what you learn with interactive challenges designed for everyone, from beginners to experts.

    Learn more about Free Hands-On: C# for Beginners
    Getting Started: AI for .NET Developers
    course

    Getting Started: AI for .NET Developers

    Get started with integrating AI into your .NET applications effectively using the latest LLM best practices.

    Learn more about Getting Started: AI for .NET Developers
    Getting Started: Building .NET Applications on AWS
    course

    Getting Started: Building .NET Applications on AWS

    Learn how to build and deploy .NET applications on AWS using CDK, Lambda, DynamoDB, S3, and more.

    Learn more about Getting Started: Building .NET Applications on AWS
    What's new in C# 14
    blog

    What's new in C# 14

    This guide covers every new C# 14 feature, explains its benefits, and provides practical code examples to help you navigate how you can use them.

    Learn more about What's new in C# 14
    Let's Build It: AI Chatbot with RAG in .NET Using Your Data
    course

    Let's Build It: AI Chatbot with RAG in .NET Using Your Data

    Build a Retrieval-Augmented Generation (RAG) chatbot that can answer questions using your data.

    Learn more about Let's Build It: AI Chatbot with RAG in .NET Using Your Data
    From Zero to Hero: SignalR in .NET
    course

    From Zero to Hero: SignalR in .NET

    Enable enterprise-grade real-time communication for your web apps with SignalR.

    Learn more about From Zero to Hero: SignalR in .NET
    Deep Dive: Solution Architecture
    course

    Deep Dive: Solution Architecture

    Master solution architecture and turn business needs into scalable, maintainable systems.

    Learn more about Deep Dive: Solution Architecture
    Migrating: ASP.NET Web APIs to ASP.NET Core
    course

    Migrating: ASP.NET Web APIs to ASP.NET Core

    A step-by-step process to migrate ASP.NET Web APIs from .NET Framework to ASP.NET Core.

    Learn more about Migrating: ASP.NET Web APIs to ASP.NET Core
    Getting Started: Caching in .NET
    course

    Getting Started: Caching in .NET

    Let's make the hardest thing in programming easy for .NET software engineers.

    Learn more about Getting Started: Caching in .NET
    From Zero to Hero: Testing with xUnit in C#
    course

    From Zero to Hero: Testing with xUnit in C#

    Learn how to test any codebase in .NET with the latest version of xUnit, the industry-standard testing library.

    Learn more about From Zero to Hero: Testing with xUnit in C#
    Create a ChatGPT Console AI Chatbot in C#
    blog

    Create a ChatGPT Console AI Chatbot in C#

    This walkthrough is your hands-on entry point to create a basic C# console application that talks to ChatGPT using the OpenAI API.

    Learn more about Create a ChatGPT Console AI Chatbot in C#