public static void AddData1(CustomerOrderContext db)
{
for (int id = 0; id < 100; id++)
{
var balance = id;
// EF detects each of these as a discrete change, and processes in the insert statements one at a time
var customer = new Customer
{
Name = $"Customer Name",
Balance = balance
};
db.Customers.Attach(customer);
db.Entry(customer).State = EntityState.Added;
db.Entry(customer).State = EntityState.Modified;
db.Entry(customer).State = EntityState.Deleted;
}
db.SaveChanges();
}
public async Task Update(TModel entity)
{
var stored = await _customerOrderContext.FindAsync <TModel>(entity.Id);
if (stored == null)
{
return;
}
_customerOrderContext.Entry(stored).CurrentValues.SetValues(entity);
await _customerOrderContext.SaveChangesAsync();
}
public static void Delete1(CustomerOrderContext db)
{
var customers = db.Customers
.AsNoTracking()
.OrderByDescending(x => x.Id)
.Take(100)
.ToList();
foreach (var customer in customers)
{
db.Customers.Attach(customer);
db.Entry(customer).State = EntityState.Deleted;
}
}
public static void Delete1(CustomerOrderContext db)
{
var customerIds = db.Customers
.OrderByDescending(x => x.Id)
.Select(x => x.Id)
.Take(100)
.ToList();
foreach (var id in customerIds)
{
var customer = new Customer()
{
Id = id
};
db.Customers.Attach(customer);
db.Entry(customer).State = EntityState.Deleted;
}
}