Passing date parameter to MySql Procedure using Asp.Net MVC

[Guri Singh]

Hi I am using MySQL with MVC for one of my dashboard project. All is working fine but now I stuck on a very simple step.

I just want to pass a date parameter to procedure using EF but cant able to do this.

I am using following method to call procedure.

var allData = dbObj.Database.SqlQuery<DayServiceWise>
("CALL SP_DayOperatorWise({dt})").ToList();

and in MySQL proc I have taken dt as date parameter.
Thanks