//插入数据
Tbl_CH chm = new Tbl_CH() //Tbl_CH 为表名
{
EgNumber = "OYZH",
MName = "欧阳震华"
};
it.dt.Tbl_CH.InsertOnSubmit(chm);
it.dt.SubmitChanges();
//删除数据 where 可跟多个条件 "并且"用&& "或者"用 ||
int cout = 0;
try
{
Tbl_CH tc = new Tbl_CH();
tc = it.dt.Tbl_CH.Single(p => p.id == 165);//查找单个实例
it.dt.Tbl_CH.DeleteOnSubmit(tc);
it.dt.SubmitChanges();
cout = 1;
}
catch (Exception x)
{
cout = 0;
}
if (cout > 0)
{
Response.Write("成功");
}
else
{
Response.Write("失败");
}
//更新
Tbl_CH uptbl = new Tbl_CH();
uptbl = it.dt.Tbl_CH.Single(p => p.id == 13);
uptbl.EgNumber = "YCL";
it.dt.SubmitChanges();
var kk = from cc in it.dt.CRM_CUSTOMER
join cls in it.dt.CRM_Linkman
on cc.CustomerID equals cls.CustomerID
into bb
from bbb in bb.DefaultIfEmpty()
select new
{
customerName = cc.NAME,
linkName = bbb != null ? bbb.NAME : "",
};
LinQ To SQL(增,删,改,查)
最新推荐文章于 2021-10-13 19:43:13 发布