EF执行SQL语句

2023年6月21日发(作者：)

EF执⾏SQL语句使⽤EF框架的过程中，有时需要执⾏SQL语句来提升查询性能，如执⾏存储过程，进⾏复杂查询等。下⾯介绍如何在EF中执⾏SQL语句。执⾏ SQL查询string sql = "SELECT sStuID,sStuName FROM [dbo].[Students] WHERE sClassID = @classID";var student = ry>( sql, new SqlParameter("@classID ", classID));var result = ((pageIndex - 1) * pageSize).Take(pageSize).ToList();执⾏SQL操作string sql = "DELETE FROM [dbo].[Students] WHERE sClassID = @ classID AND sStuID=@stuID";SqlParameter[] args = new SqlParameter[2]; args[0] = new SqlParameter("@classID", classID); args[1] = new SqlParameter("@stuID", stuID);int result = eSqlCommand(sql,args);

2023年6月21日发(作者：)

EF执⾏SQL语句使⽤EF框架的过程中，有时需要执⾏SQL语句来提升查询性能，如执⾏存储过程，进⾏复杂查询等。下⾯介绍如何在EF中执⾏SQL语句。执⾏ SQL查询string sql = "SELECT sStuID,sStuName FROM [dbo].[Students] WHERE sClassID = @classID";var student = ry>( sql, new SqlParameter("@classID ", classID));var result = ((pageIndex - 1) * pageSize).Take(pageSize).ToList();执⾏SQL操作string sql = "DELETE FROM [dbo].[Students] WHERE sClassID = @ classID AND sStuID=@stuID";SqlParameter[] args = new SqlParameter[2]; args[0] = new SqlParameter("@classID", classID); args[1] = new SqlParameter("@stuID", stuID);int result = eSqlCommand(sql,args);