Mid EF Core

How to execute stored procedures (if possible)?

  • Stored procedures can be called via raw SQL or FromSqlRaw:

var orders = context.Orders

.FromSqlRaw("EXEC GetOrdersByCustomer @CustomerId = {0}",

customerId)

.ToList();

  • For non-query SPs, use Database.ExecuteSqlRaw().

More from Entity Framework Core Tutorial

All questions for this course