public void TestBaseRepositoryOthersNullCrud()
{
// Setup
var entity = new OthersClass
{
SessionId = Guid.NewGuid(),
ColumnHierarchyId = null,
ColumnSqlVariant = null,
ColumnUniqueIdentifier = null,
ColumnXml = null
};
using (var repository = new OthersClassRepository(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = repository.Insert(entity);
// Act Query
var data = repository.Query(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnHierarchyId);
Assert.IsNull(data.ColumnSqlVariant);
Assert.IsNull(data.ColumnUniqueIdentifier);
Assert.IsNull(data.ColumnXml);
}
}
public void TestBaseRepositoryOthersCrud()
{
// Setup
var entity = new OthersClass
{
SessionId = Guid.NewGuid(),
ColumnHierarchyId = "/",
ColumnSqlVariant = "This is variant!",
ColumnUniqueIdentifier = Guid.NewGuid(),
ColumnXml = "<xml><person><id>1</id><name>Michael</name></person><person><id>2</id><name>RepoDb</name></person></xml>"
};
using (var repository = new OthersClassRepository(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = repository.Insert(entity);
// Act Query
var data = repository.Query(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnHierarchyId.ToString(), data.ColumnHierarchyId?.ToString());
Assert.AreEqual(entity.ColumnSqlVariant, data.ColumnSqlVariant);
Assert.AreEqual(entity.ColumnUniqueIdentifier, data.ColumnUniqueIdentifier);
Assert.AreEqual(entity.ColumnXml, data.ColumnXml);
}
}