var cx_kcjs = from aa in sjklj.cfsfj
select aa;
foreach (var kk in cx_kcjs)
{
// sjklj.Entry(kk).State = System.Data.Entity.EntityState.Deleted;
string cmdtxt = "DELETE FROM cfsfj where ID=@id";
SqlParameter cs1 = new SqlParameter("@id", kk.ID);
SqlParameter[] cs = new SqlParameter[] { cs1};
bool tjjg = gj.sqltjscgx(conn, cmdtxt, cs);
if (!tjjg)//更新失败
{
pcwin.Text = "删除失败";
this.ASPxPopupControl1.Windows.Add(pcwin);
return;
}
}
// sjklj.SaveChanges();//超大批量数据的更新,删除和添加,用SQL语句,速度很快;逐条添加,修改,删除;非linq,否则可能死机而且速度很慢,看不到进展。用SQL可以了解数据库动态
System.Threading.Thread.Sleep(100);