/// <summary> /// 创建一个实体 ///</summary> /// <param name="db">数据库上下文</param> /// <param name="entity">实体</param> public int Create(SysSample entity) { using (AppDBContainer db = new AppDBContainer()) { db.Set <SysSample>().Add(entity); return(db.SaveChanges()); } }
/// <summary> /// 修改一个实体 ///</summary> /// <param name="db">数据库上下文</param> /// <param name="entity">实体</param> public int Edit(SysSample entity) { using (AppDBContainer db = new AppDBContainer()) { db.Set <SysSample>().Attach(entity); db.Entry <SysSample>(entity).State = EntityState.Modified; return(db.SaveChanges()); } }
/// <summary> /// 删除一个实体 ///</summary> /// <param name="db">数据库上下文</param> /// <param name="entity">主键ID</param> public int Delete(string id) { using (AppDBContainer db = new AppDBContainer()) { SysSample entity = db.SysSample.SingleOrDefault(a => a.Id == id); db.Set <SysSample>().Remove(entity); return(db.SaveChanges()); } }