public void DeleteByGuidId_WhenItemExists_ItemIsDeletedFromAllTables()
{
var id = new Guid("35F3060A-DE6F-4BED-BFB9-D523EA98C49E");
var item = new SimpleGuidItem { Id = id, Key = "A" };
using (var unitOfWork = Database.CreateUnitOfWork())
{
unitOfWork.Insert(item);
unitOfWork.Commit();
}
using (var unitOfWork = Database.CreateUnitOfWork())
{
unitOfWork.DeleteById<SimpleGuidItem>(id);
unitOfWork.Commit();
}
var structureTable = GetStructureTableName<SimpleGuidItem>();
var structureRowCount = DbHelper.RowCount(structureTable, "Id = '{0}'".Inject(id));
Assert.AreEqual(0, structureRowCount);
var indexesTable = GetIndexesTableName<SimpleGuidItem>();
var indexesRowCount = DbHelper.RowCount(indexesTable, "StructureId = '{0}'".Inject(id));
Assert.AreEqual(0, indexesRowCount);
var uniquesTable = GetUniquesTableName<SimpleGuidItem>();
var uniquesRowCount = DbHelper.RowCount(uniquesTable, "StructureId = '{0}'".Inject(id));
Assert.AreEqual(0, uniquesRowCount);
}
public void DeleteByGuidId_WhenItemExists_ReturnsTrue()
{
bool wasDeleted;
using (var unitOfWork = Database.CreateUnitOfWork())
{
var item = new SimpleGuidItem { Key = "A" };
unitOfWork.Insert(item);
unitOfWork.Commit();
wasDeleted = unitOfWork.DeleteById<SimpleGuidItem>(item.Id);
unitOfWork.Commit();
}
Assert.IsTrue(wasDeleted);
}
