static void DeleteCustomersViaTrx() { using (var db = new ShoppingContext()) using (var transaction = db.Database.BeginTransaction()) { var customers = db.Customers.Include(b => b.Orders).ToList(); foreach (var customer in customers) { db.Entry(customer).State = Microsoft.EntityFrameworkCore.EntityState.Deleted; int recordsDeleted = db.SaveChanges(); Console.WriteLine("Number of records deleted:" + recordsDeleted); } transaction.Commit(); } }
private static async Task AddOrders() { using (var db = new ShoppingContext()) { var customer1 = new Customer() { CustomerName = "Onur" }; var customer2 = new Customer() { CustomerName = "Frisk" }; customer1.Orders.Add(new Order() { Item = "Beginning ASP.NET", Price = 35.55M }); db.Customers.Add(customer1); db.Customers.Add(customer2); await db.SaveChangesAsync(); } }