C# 执行sql语句批量更新

时间:2023-03-10 03:13:52
C# 执行sql语句批量更新
              int x = db.Database.ExecuteSqlCommand(string.Format("update T_Pension SET UnitType = '{0}' WHERE  PensionId   between '{1}' and  '{2}'", value, startmaxid, endmaxid));
//update T_Pension SET UnitType = 0,CreateTime= convert(varchar(100),getdate(),120),CreateUserName='' WHERE PensionId between '1' and '30000'
int x = db.Database.ExecuteSqlCommand(string.Format("update T_Pension SET UnitType = {0},CreateTime= convert(varchar(100),getdate(),120),CreateUserName='{1}' WHERE PensionId between '{2}' and '{3}'",
value,UserInfo.UserName,startmaxid, endmaxid));
start.ToString("yyyy-MM-dd HH:mm:ss")