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();

posted @ 2017-07-25 13:35  屎壳螂  阅读(79)  评论(0)    收藏  举报