我正在使用EF Core 2.2.6。我有一个使用以下代码调用的存储过程:
var dateFromParam = new MySqlParameter("@DateFrom",dateFrom.ToShortDateString());
var dateToParam = new MySqlParameter("@DateTo",dateTo.ToShortDateString());
List<MyData> result = await context.Query<MyData>().AsnoTracking().FromSql("CALL MyStoredProcudure @p0,@p1",parameters: new [] { dateFromParam,dateToParam }).ToListAsync();
,我收到以下错误消息:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@p0,@p1' at line 1",
如何调用它并传递我拥有的两个参数?