public void Delete(Customers entity)
{
Repository.Delete(entity);
}
public void Add(Customers entity)
{
Repository.Add(entity);
}
public void Attach(Customers entity)
{
Repository.Attach(entity);
}
private static void CustomerCRUD(TestPerformaceDBEntities dbcontext)
{
var cus = new Customers
{
CustomerID = "test",
CompanyName = "company name",
ContactName = "contact name",
Address = "address"
};
dbcontext.Customers.AddObject(cus);
dbcontext.SaveChanges();
cus.CompanyName = "update name";
dbcontext.SaveChanges();
dbcontext.Customers.DeleteObject(cus);
dbcontext.SaveChanges();
}
/// <summary>
/// Writes the test.
/// </summary>
/// <param name="repeatTime">
/// The repeat time.
/// </param>
/// <returns>
/// The write test.
/// </returns>
public long WriteTest(int repeatTime)
{
var sw = new Stopwatch();
sw.Reset();
sw.Start();
using (var db = new TestPerformaceDBEntities())
{
for (int i = 0; i < repeatTime; i++)
{
var cus = new Customers
{
CustomerID = "test",
CompanyName = "company name",
ContactName = "contact name",
Address = "address"
};
db.AddObject("Customers", cus);
db.SaveChanges();
cus.CompanyName = "update name";
db.SaveChanges();
var cat = new Categories { CategoryName = "Widgets", Description = "Widgets are the ……" };
// if we have fk
// db.AddToCategories(cat);
// db.SaveChanges();
var newProduct = new Products { ProductName = "Blue Widget", UnitPrice = 34.56M, Categories = cat };
db.AddObject("Products", newProduct);
db.SaveChanges();
// Update
cat.CategoryName = "testupdated";
db.SaveChanges();
newProduct.UnitPrice = 15.8M;
db.SaveChanges();
// Delete
db.DeleteObject(newProduct);
db.SaveChanges();
db.DeleteObject(cus);
db.SaveChanges();
db.DeleteObject(cat);
db.SaveChanges();
}
}
sw.Stop();
return sw.ElapsedMilliseconds;
}
public void Delete(Customers entity)
{
Repository.Delete(entity);
}
public void Attach(Customers entity)
{
Repository.Attach(entity);
}
public void Add(Customers entity)
{
Repository.Add(entity);
}
