private void Remove() { using (var cxt = new ManyToManyRemoveContext()) { var user = cxt.Users.FirstOrDefault(x => x.LastName.ToString().ToUpper() == "LIN"); cxt.Users.Remove(user); cxt.SaveChanges(); } }
private void RemoveManyToMany() { using (var cxt = new ManyToManyRemoveContext()) { var user = cxt.Users.FirstOrDefault(x => x.LastName.ToString().ToUpper() == "LIN"); var roles = new List <Role>(); roles.AddRange(user.Roles.Select(x => x)); foreach (var role in roles) { user.Roles.Remove(role); } cxt.Users.Remove(user); cxt.SaveChanges(); } }
private void Add() { List <Role> roles; using (var cxt = new ManyToManyRemoveContext()) { roles = cxt.Roles.ToList(); cxt.Users.Add(new User { Id = 3, FirstName = "jerimy", LastName = "Lin", CreatedOn = DateTime.Now, Roles = roles.Where(x => x.Name == "管理员").ToList() }); cxt.SaveChanges(); } }
private void button6_Click(object sender, EventArgs e) { using (var cxt = new ManyToManyRemoveContext()) { List <User> User_List = cxt.Users.ToList(); foreach (var item in User_List) { cxt.Users.Remove(item); } List <Role> Role_List = cxt.Roles.ToList(); foreach (var item in Role_List) { cxt.Roles.Remove(item); } cxt.SaveChanges(); } }