public static void Initialize(IServiceProvider serviceProvider) { using (var context = new PechShopContext( serviceProvider.GetRequiredService <DbContextOptions <PechShopContext> >())) { if (context.Products.Any() || context.Customers.Any() || context.Orders.Any()) { return; } context.Products.AddRange( new Product() { Name = "Хлеб", MinimalNumber = 3, Price = 10000, Url = "https://sports.ru", TransportationCost = (decimal)25.4, AdditionalInfo = "Старый, невкусный" }, new Product() { Name = "Водка", MinimalNumber = 2, Price = 1, Url = "https://yandex.ru" }, new Product() { Name = "Жвачка", MinimalNumber = 20, Price = (decimal)0.5, TransportationCost = (decimal)1000, Url = "https://google.com" } ); context.Customers.AddRange( new Customer() { FirstName = "Автандил", LastName = "Муштантоид-Рыкин", AdditionalInfo = "Играет на скрипке" }, new Customer() { FirstName = "Иван", LastName = "Иванов", AdditionalInfo = "Боится трехколесных велосипедов" } ); context.Orders.AddRange( new Order() { CustomerId = 1, ProductId = 1, ProductsNumber = 3 }, new Order() { CustomerId = 2, ProductId = 2, ProductsNumber = 1000 } ); context.SaveChanges(); } }
public static Task <Order> FindDuplicateOrder(this PechShopContext context, int productId, int customerId) { return(context.Orders.SingleOrDefaultAsync(o => (o.CustomerId == customerId) && (o.ProductId == productId))); }