Entity Framework Core Interview Question #140

When might raw SQL be preferable to LINQ in EF Core?

Performance, Raw SQL, Stored Procedures & Advanced Queries Senior Advanced

Quick Interview Answer

Raw SQL can be appropriate for complex provider-specific queries, carefully tuned reporting SQL, database features not conveniently exposed through LINQ, or integration with existing stored procedures and views. LINQ remains preferable for many application queries because it is strongly typed and composable. Choose based on maintainability, required database features, and measured performance.

Detailed Explanation

Raw SQL can be appropriate for complex provider-specific queries, carefully tuned reporting SQL, database features not conveniently exposed through LINQ, or integration with existing stored procedures and views. LINQ remains preferable for many application queries because it is strongly typed and composable. Choose based on maintainability, required database features, and measured performance.

Code Example

// Use raw SQL when it provides a clear technical benefit.
// Keep inputs parameterized and document provider dependencies.