ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Learn how Visual Basic .NET’s LINQ to Objects lets you write declarative, readable queries over in‑memory collections while keeping performance comparable to hand‑written loops.
Stop manually adding .Where(x => !x.IsDeleted) to every query. Learn how to use EF Core Global Query Filters to implement a robust, systemic soft-delete pattern.
Learn how to implement database-level pagination in NHibernate using IQueryable to prevent memory bloat and reduce network latency in large datasets.
Use NHibernate LINQ Fetch and FetchMany to load associations in one query instead of triggering a select for every row.
EF Core AsSplitQuery avoids Cartesian explosion by running one SQL query per included collection. Learn the mechanism, configuration, and limits.
Reduce LINQ-to-SQL translation overhead in EF Core using compiled queries to lower latency in high-throughput .NET applications.
Learn how to use EF Core Compiled Queries to eliminate LINQ-to-SQL translation overhead in high-throughput services, including a worked example and performance trade-offs.
Eager-loading two or more collections with Include can multiply result rows into a cartesian explosion. Here's how AsSplitQuery fixes it, with a worked example and the trade-offs to weigh.
Bounding Large Datasets with Query Expressions When working with large datasets in F# using Entity Framework Core (version 6.0+), the standard approach to pagination involves utilizing Skip and Take clauses within query expressions to bound the result set. While these constructs typically map to SQL OFFSET and FETCH clauses, there is uncertainty regarding ho
entityframeworkcore
dotnet
nhibernate