Entity Framework 增删改 文档.docxVIP

接口：publicinterfaceIRepositoryTEntitywhereTEntity : IEntity{IEnumerableTEntity FindAll();TEntityFindById(int id);void Add(TEntity entity);void Delete(TEntity entity);void Update(TEntity entity);}protectedDbSetTEntity DbSet{get { returnm_dbContext.SetTEntity(); }}publicIEnumerableTEntity FindAll(){returnDbSet;}publicTEntityFindById(int id){returnDbSet.SingleOrDefault(entity = entity.Id == id);}publicvoid Add(TEntity entity){DbSet.Add(entity);m_dbContext.SaveChanges();}publicvoid Delete(TEntity entity){DbSet.Remove(entity);m_dbContext.SaveChanges();}varheros = repository.FindAll();var hero = heros.First(h = h.Id == 1);varheroNew = new Hero{ Id = hero.Id, Name = hero.Name, Race = hero.Race};repository.Update(heroNew);查找：string city = London; using (Entities entities = new Entities()) { var query = entities（数据库）.Customers.Where(r = r.Address.City == city); ?foreach (Customers c in query) ?Console.WriteLine(c.CompanyName); }dimdb As New Entitiesdim aObj as 实体类添加aObj.属性=值db.addobject(aObj)db.savechanges()’查dim aObj as 实体类=(from iObj in db.实体集 where 实体ID=ID select iObj).first()删除dim aObj as 实体类=(from iObj in db.实体集 where 实体ID=ID select iObj).first()db.DeleteObject(aobj)db.savechanges()改dim aObj as 实体类=(from iObj in db.实体集 where 实体ID=ID select iObj).first()aObj.属性=值db.savechanges()本节，直接写通过代码来学习。这些基本操作都比较简单，与这些基本操作相关的内容在之前的1至6节基本介绍完毕。??????????? 增加：方法1：使用AddToXXX(xxx)方法：实例代码如下：using (var edm = newNorthwindEntities()) {Customers c = newCustomers { CustomerID = c#, City = 成都市, Address = 中国四川省, CompanyName = cnblogs, Country = 中国, Fax = 10086, Phone = 1008611, PostalCode = 610000, Region = 天府广场, ContactName = 风车车.Net }; edm.AddToCustomers(c);int result = edm.SaveChanges();Assert.AreEqual(result, 1);Customers addc = edm.Customers.FirstOrDefault(cc = cc.CustomerID == c#);Console.WriteLine(CustomerId={0},City={1}, addc.CustomerID, addc.City); }方法2：使用ObjectContext的AddObject(string entitySetName, object entity)方法。实例代码如下：using (var edm = n