private static void AddUserWithCreative() { var categories = GetCategories(); var category = categories[1]; var user = new User { Name = "Di", BirthDate = DateTime.Now.AddYears(-25), }; var crew = new Creative { CreativeName = "Another one genius", Category = category, User = user }; user.Creatives.Add(crew); using (var context = new TldrContext()) { context.Users.Add(user); context.SaveChanges(); } }
private static void DeleteUser(String name) { using (var context = new TldrContext()) { var user = context.Users.FirstOrDefault(c => c.Name == name); context.Users.Remove(user); context.SaveChanges(); } }
private static void UpdateUser() { using (var context = new TldrContext()) { var user = context.Users.FirstOrDefault(c => c.Name == "Diana"); user.BirthDate = DateTime.Now.AddYears(-25); context.SaveChanges(); GetUser(user.UserID); } }
private static void DeleteUsers(string v) { using (var context = new TldrContext()) { var users = context.Users.Where(c => c.Name == v).ToList(); foreach (var user in users) { context.Users.Remove(user); } context.SaveChanges(); } }
private static List <Category> GetCategories() { using (var context = new TldrContext()) { var category = new Category { CategoryName = "new" }; context.Categories.Add(category); context.SaveChanges(); return(context.Categories.ToList <Category>()); } }