public async Task MockDb_SalesOrder()
{
var log = new StringBuilder();
using (var db = await MockEmptySalesOrder.CreateAsync(CreateDb(log)))
{
Assert.AreEqual(0, db.SalesOrderHeader.CountAsync().Result);
Assert.AreEqual(0, db.SalesOrderDetail.CountAsync().Result);
}
}
public async Task DbTable_InsertScalarAsync_update_identity()
{
var salesOrder = NewSalesOrdersTestData(1);
var log = new StringBuilder();
using (var db = await MockEmptySalesOrder.CreateAsync(CreateDb(log)))
{
await db.SalesOrderHeader.InsertAsync(salesOrder, true);
}
Assert.AreEqual(1, salesOrder._.SalesOrderID[0]);
}
public async Task DbTable_InsertAsync_DataSet_update_identity()
{
var salesOrders = NewSalesOrdersTestData();
var log = new StringBuilder();
using (var db = await MockEmptySalesOrder.CreateAsync(CreateDb(log, LogCategory.All)))
{
var result = await db.SalesOrderHeader.InsertAsync(salesOrders, true);
Assert.AreEqual(2, result);
}
Assert.AreEqual(1, salesOrders._.SalesOrderID[0]);
Assert.AreEqual(2, salesOrders._.SalesOrderID[1]);
}
public async Task DbTable_InsertScalarAsync()
{
var log = new StringBuilder();
using (var db = await MockEmptySalesOrder.CreateAsync(CreateDb(log)))
{
await db.SalesOrderHeader.InsertAsync((m, _) =>
{
m.Select(_Int32.Param(1), _.CustomerID)
.Select(_DateTime.Now(), _.DueDate)
.Select(_String.Param("FLIGHT"), _.ShipMethod);
});
var result = await db.SalesOrderHeader.ToDataSetAsync();
Assert.AreEqual(1, result.Count);
}
}
