1.EF中Include方法的使用
使用Include方法,告诉EF连接查询哪个外键属性,生成Inner join连接
IQueryable<UsersAddress> addrs = db.UserAddresses.Include("User"); foreach(UsersAddress add in address) { Console.WriteLine(add.udAddress+":userName="+add.User.uName); }
2.EF中修改对象,不需要先查询,然后修改
User user = new User(){ uId=8,uName = "aa"}; //将对象加入EF容器中并获取当前实体对象的状态管理对象 DbEntityEntry<User> entry = db.Entry<User>(user); entry.State = System.Data.EntityState.Unchanged; //设置该对象的uName属性为修改状态 entry.Property("uName").IsModified = true; db.SaveChanges();
3.EF中删除操作
User user = new User(){ uId=8}; db.Users.Attach(user); db.Users.Remove(user); db.SaveChanges();
原文:http://www.cnblogs.com/yxlblogs/p/3567785.html