Thought Persistence

既然是ORM的测试, 就得体现这么几点 :
one-one, many-ony, many-many关系
typed query 类型化查询
entity crud 实体的crud
traverse entity list 实体集合的构造和遍历

从便利性上讲, 需要满足这样几点:
master-details: 保存master, 可以自动保存details, 删除master, 可以自动删除details, 但是还有一种master-details是弱关联, 必须区分开来, 所以测试用例中的delete必须要保证orderitem也删除
实体对象属性的透明获取

这里给出我的性能测试的dbschema和unit test

http://www.cnblogs.com/Files/progame/dbschema.rar

[Test]
public void TestCRUDPerformance()
{
Product p = new Product("CAR001");
Customer c = new Customer(DBContext.CustomerID);

List<Guid> ids = new List<Guid>();

// clear table
s.Delete(Domain.Order.OrderID.IsNotNull);
s.Delete(Domain.OrderItem.ItemID.IsNotNull);
s.Delete(Domain.ItemDetail.DetailID.IsNotNull);

DateTime dt = DateTime.Now;
int count = 100;

EntityList<Order> ol = null;

// create
for (int i = 0; i < count; i++)
{
Order o = new Order(Guid.NewGuid());

ids.Add(o.OrderID);

o.Amount = 100f;
o.OrderDate = DateTime.Today;
o.OrderNo = "PI_" + i.ToString("000");
o.Remark = "description";
o.Customer = c;
o.CreatedDateTime = DateTime.Now;

for (int j = 0; j < 10; j++)
{
OrderItem item = new OrderItem(Guid.NewGuid());
item.Amount = 100f;
item.Product = p;
item.Quantity = 10;
o.Items.Add(item);

for (int k = 0; k < 10; k++)
{
ItemDetail dtl = new ItemDetail(Guid.NewGuid());
dtl.Remark = "nothing at all";
item.Details.Add(dtl);
}
}
s.Insert(o);
}

TimeSpan ts = DateTime.Now - dt;
Console.WriteLine("test insert performance use: {0} ms", ts.TotalMilliseconds);

// typed query
dt = DateTime.Now;

for (int i = 0; i < count; i++)
{
ol = s.GetList<Order>(
Domain.Order.OrderDate == DateTime.Today &
Domain.Order.OrderID == ids[i] &
Domain.Order.Items.Include(
Domain.OrderItem.Details.Include(
Domain.ItemDetail.Remark.IsNotNull)));

Assert.AreEqual(1, ol.Count);

}
ts = DateTime.Now - dt;
Console.WriteLine("test typed query performance use: {0} ms", ts.TotalMilliseconds);

//enity list read
dt = DateTime.Now;

ol = s.GetList<Order>();

double? sum = 0f;
double? sum2 = 0f;
int detailcount = 0;

foreach (Order o in ol)
{
foreach (OrderItem item in o.Items)
{
sum += item.Amount;
sum2 += item.Order.Amount;
detailcount += item.Details.Count;
}
}

ts = DateTime.Now - dt;
Assert.IsTrue(Math.Abs(Convert.ToDouble(sum - 1000f * count)) < 0.00001f);
Assert.AreEqual(count * 10 * 10, detailcount);

Console.WriteLine("test read performance use: {0} ms", ts.TotalMilliseconds);

// single load
dt = DateTime.Now;

for (int i = 0; i < count; i++)
{
Order o = new Order(ids[i]);
s.Load(o);
}

ts = DateTime.Now - dt;
Console.WriteLine("test load performance use: {0} ms", ts.TotalMilliseconds);

// update all fields
dt = DateTime.Now;

for (int i = 0; i < count; i++)
{
Order o = new Order(ids[i]);
o.Amount = 200f;
s.Update(o, true);
}

ts = DateTime.Now - dt;
Console.WriteLine("test update all fields performance use: {0} ms", ts.TotalMilliseconds);

// update dirty fields only
dt = DateTime.Now;

for (int i = 0; i < count; i++)
{
Order o = new Order(ids[i]);
o.Amount = 200f;
s.Update(o);
}

ts = DateTime.Now - dt;
Console.WriteLine("test update dirty fields performance use: {0} ms", ts.TotalMilliseconds);

// delete
dt = DateTime.Now;

for (int i = 0; i < count; i++)
{
Order o = new Order(ids[i]);
s.Delete(o);
}

ts = DateTime.Now - dt;

IEntityList list = s.GetList<Order>();
Assert.AreEqual(0, list.Count);
list = s.GetList<OrderItem>();
Assert.AreEqual(0, list.Count);
list = s.GetList<ItemDetail>();
Assert.AreEqual(0, list.Count);

Console.WriteLine("test delete performance use: {0} ms", ts.TotalMilliseconds);

}