private static void ViewData5() { using (var ctx = new EFRecipesEntities5()) { var all = ctx.PictureCategories.ToList(); var roots = all.Where(x => x.ParentCategory == null).ToList(); // var rootBoost = ctx.PictureCategories.AsNoTracking().ToList(); roots.ForEach(root => Print(root, 0)); var entry = ctx.Entry(all.FirstOrDefault()); var cv = entry.CurrentValues["Name"]; } }
private static void AddData5() { using (var ctx = new EFRecipesEntities5()) { var louvre = new PictureCategory { Name = "Louvre" }; var child = new PictureCategory { Name = "Egyptian Antiquites" }; louvre.Subcategories.Add(child); child = new PictureCategory { Name = "Sculptures" }; louvre.Subcategories.Add(child); child = new PictureCategory { Name = "Paintings" }; louvre.Subcategories.Add(child); var paris = new PictureCategory { Name = "Paris" }; paris.Subcategories.Add(louvre); var vacation = new PictureCategory { Name = "Summer Vacation" }; vacation.Subcategories.Add(paris); ctx.PictureCategories.Add(paris); ctx.SaveChanges(); /* * PictureCategory pc1 = new PictureCategory() { Name = "L1a" }; * PictureCategory pc2 = new PictureCategory() { Name = "L1b" }; * PictureCategory pc3 = new PictureCategory() { Name = "L1c" }; * PictureCategory pc4 = new PictureCategory() { Name = "L1d" }; * pc4.Subcategories.Add(new PictureCategory { Name = "L2a" }); * pc4.Subcategories.Add(new PictureCategory { Name = "L2b" }); * PictureCategory pc = new PictureCategory() { Name = "L" };// Subcategories = new List<PictureCategory> { pc1, pc2, pc3, pc4 } }; * pc.Subcategories.Add(pc1); * pc.Subcategories.Add(pc2); * pc.Subcategories.Add(pc3); * ctx.PictureCategories.Add(pc); * ctx.SaveChanges();*/ } }