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().