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();
}
static void Main(string[] args)
{
using (var db = new UsersContext())
{
DeleteGroupsAndUsers(db);
AddUser(db, "Superman");
var query = from us in db.Users
select us;
foreach (var item in query)
{
Console.WriteLine("Name: {0}, Group: {1}", item.UserName, item.GroupId);
}
foreach (var group in db.Groups)
{
Console.WriteLine("GroupId:{0}, GroupName: {1}", group.GroupId, group.GroupName);
}
}
}
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();
}
