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