private static void AddUser(UsersContext db, string name) { var admins = db.Groups.Where(x => x.GroupName == "Admins").ToList(); if (admins.Count == 0) { db.Groups.Add(new Group() { GroupName = "Admins" }); db.SaveChanges(); admins = db.Groups.Where(x => x.GroupName == "Admins").ToList(); } User user = new User() { UserName = name, GroupId = admins[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(); }
/// <summary> /// a local db should be created on the computer, use SQL Server Object Explorer to see it /// </summary> static void Main(string[] args) { using (var db = new UsersContext()) { DeleteGroupsAndUsers(db); AddUser(db, "Lol"); 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); } } }