How to do raw SQL queries in EF Core?
(FromSqlRaw, etc.)
- Use FromSqlRaw() or FromSqlInterpolated():
var products = context.Products
.FromSqlRaw("SELECT * FROM Products WHERE Price > {0}", 100)
.ToList();
(FromSqlRaw, etc.)
var products = context.Products
.FromSqlRaw("SELECT * FROM Products WHERE Price > {0}", 100)
.ToList();