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()); } }