Entities,Linq 执行sql语句

来源:互联网 发布:java高级程序设计下载 编辑:程序博客网 时间:2024/06/05 08:57


            schoolEntities db = new schoolEntities();
            var parStudentUnitCode = new System.Data.SqlClient.SqlParameter[]
            {
                new System.Data.SqlClient.SqlParameter("@Dormitory",dorid),
            };
            string updateStudentUnitCode = @"DELETE FROM [DormitoryOnDuty] WHERE Dormitory=@Dormitory";
            db.ExecuteStoreCommand(updateStudentUnitCode, parStudentUnitCode);