public void Seed() { ctx.Database.EnsureCreated(); if (!ctx.Products.Any()) { // Need to create sample data var filepath = Path.Combine(hosting.ContentRootPath, "Data/art.json"); var json = File.ReadAllText(filepath); var products = JsonConvert.DeserializeObject <IEnumerable <Product> >(json); ctx.Products.AddRange(products); var order = new Order() { OrderDate = DateTime.Now, OrderNumber = "00001", //User = user, Items = new List <OrderItem>() { new OrderItem() { Product = products.First(), Quantity = 5, UnitPrice = products.First().Price } } }; ctx.Orders.Add(order); ctx.SaveChanges(); var orderCheck = ctx.Orders.Where(o => o.Id == 1).FirstOrDefault(); if (orderCheck != null) { orderCheck.Items = new List <OrderItem>() { new OrderItem() { Product = products.First(), Quantity = 5, UnitPrice = products.First().Price } }; } ctx.SaveChanges(); } }
public bool SaveAll() { return(ctx.SaveChanges() > 0); }