public async Task MockDb_ProductCategory()
{
var log = new StringBuilder();
using (var db = await MockProductCategory.CreateAsync(CreateDb(log)))
{
Assert.AreEqual(13, db.ProductCategory.CountAsync().Result);
}
}
public async Task DbTable_UpdateAsync_from_Scalar()
{
var log = new StringBuilder();
using (var db = await MockProductCategory.CreateAsync(CreateDb(log)))
{
var dataSet = await db.ProductCategory.ToDataSetAsync();
Assert.IsTrue(dataSet.Count > 1);
var newModifiedDate = new DateTime(2015, 11, 19);
dataSet._.ModifiedDate[0] = newModifiedDate;
await db.ProductCategory.UpdateAsync(dataSet, 0);
Assert.AreEqual(1, await db.ProductCategory.Where(x => x.ModifiedDate == newModifiedDate).CountAsync());
}
}
public async Task DbTable_UpdateAsync_without_source()
{
var log = new StringBuilder();
using (var db = await MockProductCategory.CreateAsync(CreateDb(log)))
{
var count = await db.ProductCategory.Where(x => x.ProductCategoryID > 2).CountAsync();
Assert.IsTrue(count > 0);
_DateTime newModifiedDate = new DateTime(2015, 11, 19);
await db.ProductCategory.UpdateAsync((builder, productCategory) =>
{
builder.Select(newModifiedDate, productCategory.ModifiedDate);
}, x => x.ProductCategoryID > 2);
Assert.AreEqual(count, await db.ProductCategory.Where(x => x.ModifiedDate == newModifiedDate).CountAsync());
}
}
public async Task DbTable_UpdateAsync_from_DataSet()
{
var log = new StringBuilder();
using (var db = await MockProductCategory.CreateAsync(CreateDb(log)))
{
var dataSet = await db.ProductCategory.ToDataSetAsync();
var count = dataSet.Count;
Assert.IsTrue(count > 1);
var newModifiedDate = new DateTime(2015, 11, 19);
for (int i = 0; i < count; i++)
{
dataSet._.ModifiedDate[i] = newModifiedDate;
}
await db.ProductCategory.UpdateAsync(dataSet);
Assert.AreEqual(count, await db.ProductCategory.Where(x => x.ModifiedDate == newModifiedDate).CountAsync());
}
}
