EF CORE
保存、批量保存
List<int> listEntId = new List<int>();
foreach (EnterpriseManagement entity in list)
{
myDbContext.Entry(entity).State = EntityState.Added;
myDbContext.EnterpriseManagements.Add(entity);
}
myDbContext.SaveChanges();
await transction.CommitAsync();
新增一条 去掉循环 实例化单个对象 进行SaveChanges()
删除、批量删除
var ent= myDbContext.EnterpriseManagements.Find(1);
myDbContext.EnterpriseManagement.Remove(ent);
myDbContext.SaveChanges();
-------------------------------------------------------------------------------------------
var ent= new EnterpriseManagements { Id= 4 };
myDbContext.Remove(ent);
myDbContext.SaveChanges();
-------------------------------------------------------------------------------------------
var ent= new EnterpriseManagements { Id= 3 };
myDbContext.Entry(ent).State = EntityState.Deleted;
myDbContext.SaveChanges();
-------------------------------------------------------------------------------------------
using (var db = new myDbContext())
{
var allIds = myDbContext.EnterpriseManagements.ToListAsync();
myDbContext.EnterpriseManagements.RemoveRange(allIds .Result);
myDbContext.SaveChanges();
}
时间格式定义
ef实体模型中 时间格式字段设置 可空类型
如果不设置可空 不传值会报错
public Nullable SetMainDate { get; set; }
public DateTime? SetMainDate { get; set; }
原文链接:原文链接