private static void AddAndRemoveCustomer(KmdDb ctx)
{
var myCustomer = ctx.Customers.Find(544);
myCustomer.CompanyName = "Firebrand";
ctx.SaveChanges();
ctx.Customers.RemoveRange(ctx.Customers.Where(c => c.CompanyName == "Firebrand"));
ctx.SaveChanges();
Top10Customer(ctx);
}
private static void InsertToCategories(KmdDb ctx)
{
ctx.ProductCategories.Add(new ProductCategory
{
Name = "Pepe",
ModifiedDate = DateTime.Now,
rowguid = Guid.NewGuid()
}
);
if (ctx.ProductCategories.Where(p => p.Name == "Pepe2").Count() == 0)
{
ctx.ProductCategories.Add(new ProductCategory
{
Name = "Pepe2",
ModifiedDate = DateTime.Now,
rowguid = Guid.NewGuid()
}
);
}
ctx.SaveChanges();
}
