private static void AddUser(UsersContext db, string name) { var gods = db.Groups.Where(x => x.GroupName == "Gods").ToList(); if (gods.Count == 0) { db.Groups.Add(new Group() { GroupName = "Gods" }); db.SaveChanges(); gods = db.Groups.Where(x => x.GroupName == "Gods").ToList(); } User user = new User() { UserName = name, GroupId = gods[0].GroupId }; db.Users.Add(user); db.SaveChanges(); }
private static void DeleteGroupsAndUsers(UsersContext db) { var toDelete = from us in db.Users select us; foreach (var item in toDelete) { db.Users.Remove(item); } var groupsToDelete = from gr in db.Groups select gr; foreach (var item in groupsToDelete) { db.Groups.Remove(item); } db.SaveChanges(); }