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 ExplicitLoading() { using (var context = new TldrContext()) { var user = context.Users.Where(u => u.UserID == 34).First(); context.Entry(user).Collection(c => c.Creatives).Load(); Console.WriteLine("User {0} have {1} creatives", user.Name, user.Creatives.Count); } }
private static void GetUser(int v) { using (var context = new TldrContext()) { var user = context.Users.Find(v); Console.WriteLine(user.Name); Console.WriteLine(user.BirthDate); } }
private static void LazyLoading() { using (var context = new TldrContext()) { context.Configuration.LazyLoadingEnabled = true; var user = context.Users.Where(u => u.UserID == 34).First(); Console.WriteLine("User {0} have {1} creatives", user.Name, user.Creatives.Count); } }
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 GetUsersNames() { using (var context = new TldrContext()) { foreach (var user in context.Users) { Console.WriteLine("{0} - {1} - {2}", user.Name, user.CreateDate, user.ModifyDate); } } }
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>()); } }
private static void EagerLoading() { using (var context = new TldrContext()) { var eagerLoadGraph1 = context.Users.Include(u => u.Creatives).ToList(); var eagerLoadGraph2 = context.Users.Include("Creatives").ToList(); var eagerLoadGraph3 = context.Users.Include("Creatives.Parts").ToList(); var eagerLoadGraph4 = context.Users .Where(u => u.Creatives.Any()) .Include(u => u.Creatives.Select(c => c.Parts)) .ToList(); var user = eagerLoadGraph4[0]; } }
private static void LoadWithProjection() { using (var context = new TldrContext()) { var userCreativeGraph = context.Users .Select(u => new { u, u.Creatives }) .ToList(); var user = userCreativeGraph[0].u; var userWithCreative = context.Users .Select(u => new { u, FirstCrew = u.Creatives.FirstOrDefault() }) .ToList(); } }