Entity Framework Core Interview Question #142

How can stored procedures be used with EF Core?

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

Quick Interview Answer

EF Core can work with stored procedures through relational SQL APIs, and supported provider features can also map certain persistence operations to stored procedures. Stored procedures may be useful for existing database logic or provider-specific functionality. Their parameters, result shape, deployment, and versioning should be treated as an explicit contract.

Detailed Explanation

EF Core can work with stored procedures through relational SQL APIs, and supported provider features can also map certain persistence operations to stored procedures. Stored procedures may be useful for existing database logic or provider-specific functionality. Their parameters, result shape, deployment, and versioning should be treated as an explicit contract.

Code Example

var rows = await db.ProductReportRows
    .FromSql($"EXEC dbo.GetProductsByCategory @CategoryId={categoryId}")
    .ToListAsync();