Execute sql statement or procedure in .net entity framework core-CodePudding

I created ASP.NET 5.0 Core-Web-API project and use package Microsoft.EntityFrameworkCore version 5.0.13. Additionally I created a stored procedure with 2 parameters of type DATE. The procedure runs in sql management studio without errors.

var p1 = new SqlParameter("@From", System.Data.SqlDbType.DateTime);
p1.Value = new DateTime(2021, 11, 07);
var p2 = new SqlParameter("@To", System.Data.SqlDbType.DateTime);
p1.Value = new DateTime(2021, 12, 07);
List<MapTableDimvw> myList = myDbContext.MyTable.FromSqlRaw("EXEC myProc @From, @To", p1, p2).ToList();

CodePudding user response：

I think you can do with the following :

var blogs = context.myTable
.FromSqlRaw($"Select Id, colA, colB From myTable")
.ToList();
// or AsEnumerable();
var blogs = context.myTable
.FromSqlRaw($"Select Id, colA, colB From myTable")
.AsEnumerable();

Source: Raw SQL Queries

Otherwise, you can try to add something like this :

var simple = _context.myTable.FromSqlInterpolated($"Select Id, colA, colB From myTable").ToList();

Regards.