Explains the performance and readability benefits of ordering LINQ queries as Where.Select instead of Select.Where in C#.
Explains how to filter on JSON array columns in Entity Framework Core 7 using SQL workarounds when LINQ translation fails.
Explains how .NET 6's TryGetNonEnumeratedCount method works to get an element count without enumeration, using internal interfaces like IIListProvider.
A guide to six practical C# extension methods for IEnumerable, including IsNullOrEmpty, Partition, Median, and Mode.
Explores using SIMD instructions and Vector<T> to accelerate LINQ queries in C# for high-performance data processing.
Explains the Skip and Take methods in C# LINQ for implementing pagination and limiting query results.
A comprehensive guide to the various collection-like types in .NET (C#), explaining their differences, use cases, and best practices for selection.
A collection of technical infographics covering .NET, C#, Entity Framework, exceptions, operators, and query safety.
A .NET developer explains why formatting LINQ queries vertically (tall) improves readability and maintainability over horizontal (wide) formatting.
An eBook explaining LINQ (Language Integrated Query) in C# using visual sketches and code samples, with over 30 pages of content.
A visual guide explaining core LINQ functions in C#/.NET with sketches and examples, including Select, Where, Aggregate, and more.
Explains core C# concepts essential for LINQ and IEnumerable, including boxing, extension methods, lambdas, and closures.
An introduction to .NET's Language Integrated Query (LINQ), covering its architecture, generic types, query syntax, and operations for unified data querying.
Explains the key differences between IEnumerable and IQueryable in C#/.NET, focusing on in-memory vs. remote query execution.
A guide to dynamically building OR expressions in LINQ queries using Expression Trees, with a reusable helper class for combining predicates.
A guide to translating NHibernate LINQ queries to SQL without executing them, using a custom ToSql() extension method for debugging.
Explains how to use EF Core 5.0's ToQueryString() method to translate LINQ queries to SQL without executing them against the database.
Explains why LINQ Join is faster than nested loops or Select for merging data in C#, focusing on performance with large datasets.
A technical guide on implementing a repository-like querying interface directly within an Entity Framework Core DbContext, avoiding custom repository classes.
A quick C# tip showing how to use an extension method to get the current index inside a foreach loop, combining the benefits of foreach and for.
