ef 执行存储过程
SqlParameter BeginYear = new SqlParameter("@BeginYear", "2016");
SqlParameter BeginMonth = new SqlParameter("@BeginMonth", "4");
SqlParameter EndYear = new SqlParameter("@EndYear", "2016");
SqlParameter EndMonth = new SqlParameter("@EndMonth", "11");
var MCContext = new MailControllerDataContext();
var ListAttendence =
MCContext.Database.SqlQuery<AttendanceSumInfo>(
"exec [usp_GetAttendanceInfo] @BeginYear,@BeginMonth,@EndYear,@EndMonth", BeginYear, BeginMonth,
EndYear, EndMonth).ToList();

浙公网安备 33010602011771号