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();
}