Rule reference

LinqContraband Rule Catalog

Full LinqContraband EF Core analyzer rule catalog grouped by query, materialization, loading, async, tracking, raw SQL, and schema design.

The source of truth for rule metadata lives in src/LinqContraband/Catalog/RuleCatalog.cs. This page is generated from that catalog and grouped by EF Core failure mode.

Bulk Operations & Set-Based Writes

Optimize: Use ExecuteDelete() instead of RemoveRange()

Use ExecuteUpdate for provable bulk scalar updates

Missing Where before bulk execute

Change Tracking & Context Lifetime

Performance: Missing AsNoTracking() in Read-Only path

N+1 Write Problem: SaveChanges inside loop

Disposed Context Query

Avoid AsNoTracking with Update/Remove

Potential DbContext lifetime mismatch

Avoid repeated SaveChanges on the same context

Avoid mixing tracking modes on the same context

AsNoTracking query mutated then SaveChanges — silent data loss

Execution & Async

N+1 Problem: Database execution inside loop

Sync-over-Async: Synchronous EF Core method in Async context

Missing CancellationToken in async call

DbContext captured by thread work item

Prefer await foreach over buffering async streams

Loading & Includes

Cartesian Explosion Risk: Multiple Collection Includes

Conditional Include Expression

Deep ThenInclude Chain

Avoid excessive eager loading

Complex query should be tagged

Missing Include: navigation accessed on materialized entity

Materialization & Projection

Premature query continuation after materialization

Prefer Any() over Count() existence checks

Performance: Consider using Select() projection

Nested collection materialization inside projection

Use Find/FindAsync for primary key lookups

Redundant identity Select

Unbounded Query Materialization

Use FrozenSet for provably read-only membership caches

Single entity query over-fetches one consumed property

Query Shape & Translation

Client-side evaluation risk: Local method usage in IQueryable

Deferred Execution Leak: IQueryable passed as IEnumerable

Multiple OrderBy calls

Avoid String.ToLower() or ToUpper() in LINQ queries

Deterministic Pagination: OrderBy required before Skip/Take

Avoid DateTime.Now/UtcNow in LINQ queries

Avoid untranslatable string comparison overloads

GroupBy with Non-Translatable Projection

Raw SQL & Security

Avoid FromSqlRaw with interpolated strings

Avoid IgnoreQueryFilters

Avoid ExecuteSqlRaw with interpolated strings

Avoid constructed raw SQL strings

Schema & Modeling

Design: Entity missing Primary Key

Missing Explicit Foreign Key Property