Learn it from developers who built it.
Tutorials, how-tos and deep dives on AI, .NET, C#, cloud and developer tools, written by the community.
Learn the difference between IEnumerable and IQueryable in C# with simple examples. Understand how LINQ queries are executed, how Entity Framework Core translates IQueryable queries into SQL, and why choosing the right approach can improve application performance.

Learn the difference between Intersect() and Where() + Distinct() in C# LINQ, with examples, use cases, duplicate handling, and guidance for choosing the right method.

Explore .NET 11's FullJoin in LINQ for explicit full outer joins. Optimize database queries with EF Core translation and understand performance implications.

Unlock LINQ's power in C#! Discover hidden performance costs and learn practical techniques for efficient, production-ready code.

Unlock advanced JavaScript! Master closures, async, prototypes, event loop, & functional programming for scalable & efficient web applications. Level up your skills!

Unlock multi-core performance in C# with Parallel LINQ (PLINQ). Learn how to parallelize LINQ queries with .AsParallel() for CPU-bound tasks and improve performance. Explore its advantages and disadvantages.

Understand the crucial difference between First() and FirstOrDefault() in LINQ for C#. Learn when to use each method for robust, exception-safe .NET applications. Avoid common mistakes!

Explore the key differences between Stored Procedures and LINQ in .NET for database interactions. Optimize your ASP.NET Core apps for performance and maintainability.

Unlock peak .NET performance! Compare LINQ & ZLINQ for querying data. Discover when ZLINQ's zero-allocation approach crushes LINQ in speed and memory efficiency.

Discover LINQ in C#: a powerful feature for streamlined data querying. Learn how it simplifies data access, improves code readability, and boosts .NET application performance.

Discover LINQ in C#: Simplify data querying, boost code readability, and enhance performance in .NET applications. Ideal for scalable enterprise systems.

Unlock LINQ performance! Discover the crucial differences between IEnumerable and IQueryable for efficient data querying in .NET. Optimize your ASP.NET Core apps!

Unlock C# LINQ's full potential! Master advanced techniques for efficient querying, performance optimization, and avoiding common pitfalls. Elevate your .NET skills!

Unlock C# LINQ performance! Discover the crucial differences between .ToList() and .ToListAsync() for optimal threading, scalability, and I/O efficiency. Boost your app's responsiveness!

Unlock the power of LINQ in .NET! Learn foundational concepts, syntax options, standard query operators, and how it revolutionizes data querying. #LINQ #dotnet

Unlock C# performance! Discover when to use Any() vs. Count() for checking collection emptiness. Learn the O(1) vs. O(n) complexities and crucial exceptions for Lists & arrays.

Unlock the power of LINQ! This article provides a comprehensive guide on how LINQ translates your C# code into efficient SQL queries. Learn with practical examples demonstrating filtering, joining, ordering, and grouping. Understand deferred execution and the difference between LINQ to Entities and LINQ to Objects. Master LINQ and optimize your database interactions in .NET!

Finally! .NET 10 and EF Core 10 introduce native LeftJoin and RightJoin LINQ methods, simplifying data queries and eliminating verbose workarounds. Learn how to use these game-changing features for cleaner, more readable code, mirroring SQL's LEFT JOIN functionality.


Language Integrated Query (LINQ) is a game-changer in C#. It brings SQL-like data querying capabilities directly into your C# code, making data manipulation more intuitive, type-safe, and readable.

In this article, we are going to learn about the importance of LINQ features of select and SelectMany and the difference between them.

Learn the behavioral, performance, and error-handling differences between LINQ's FirstOrDefault and SingleOrDefault methods, and when to use each in C#.

This article explains the difference between deferred and immediate execution, outlines the execution order, and shares best practices to write efficient and optimized LINQ queries for real-world applications.

Learn LINQ in C# with 101 essential operations for beginners. Simple examples of filtering, sorting, and joining data to make your code better and faster. Perfect for new C# developers.

PLINQ (Parallel LINQ) is a powerful feature in .NET that enables parallel processing of queries to improve performance on multi-core processors.

Discover the latest LINQ features in .NET 9 that enhance query performance, simplify data manipulation, and introduce new methods for better efficiency.

This article will discuss The Lazy loading related topic: Difference between IEnumerable and IQueryable

Quantifier operations in LINQ simplify logical evaluations of collections using methods like `Any`, `All`, and `Contains`. They enhance readability, reduce boilerplate, and support efficient data validation and filtering.

In this article, I will showcase the new methods: Index, CountBy, and AggregateBy. These powerful additions in .NET 9 bring significant enhancements to LINQ, aimed at improving your coding experience and simplifying data manipulation tasks.

.NET 9 introduces the CountBy method, a powerful addition to LINQ that enhances querying capabilities. This feature allows developers to count elements based on specified conditions efficiently.
Everything on LINQ, not only its articles: the LINQ page →
Write an article and earn +1,000 SHARP when it is approved.
Write an article