VS2013实体模型增删改查
//增加
using (Model1 entities = new Model1())
{
T_AuditorInfo auditorInfo = new T_AuditorInfo();
auditorInfo.Auditor=auditor;
auditorInfo.CompanyId = companyID;
auditorInfo.Password = password;
entities.T_AuditorInfo.Add(auditorInfo);
entities.SaveChanges();
}
//删除
using (Model1 entities = new Model1())
{
T_AuditorInfo少数民族考研 auditor = entities.T_AuditorInfo.First<T_AuditorInfo>(a => a.Id == id);
entities.T_AuditorInfo.Remove(auditor);
entities.SaveChanges();
}
创建文明校园
横塘古诗//修改
using (Model1 entities = new Model1())
{
简单的情歌
T_AuditorInfo auditorinfo = entities.T_AuditorInfo.First<T_AuditorInfo>(a => a.Id == id);
auditorinfo.Auditor = auditor;
auditorinfo.Password = password;
entities.SaveChanges();
婚礼微信邀请函
}
//查询
using (Model1 entities = new Model1())复音程
{
颜色英文var data = from r in entities.T_AuditorInfo
where r.CompanyId == "1"
炸肉丸子的家常做法lect r;
//绑定数据
dataGridView1.DataSource = data.ToList();
}