public void TestBaseRepositoryOthersMappedNullCrudAsync()
{
// Setup
var entity = new OthersMapClass
{
SessionId = Guid.NewGuid(),
ColumnHierarchyIdMapped = null,
ColumnSqlVariantMapped = null,
ColumnUniqueIdentifierMapped = null,
ColumnXmlMapped = null
};
using (var repository = new OthersMapClassRepository(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = repository.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = repository.QueryAsync(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnHierarchyIdMapped);
Assert.IsNull(data.ColumnSqlVariantMapped);
Assert.IsNull(data.ColumnUniqueIdentifierMapped);
Assert.IsNull(data.ColumnXmlMapped);
}
}
public void TestBaseRepositoryOthersMappedCrudAsync()
{
// Setup
var entity = new OthersMapClass
{
SessionId = Guid.NewGuid(),
ColumnHierarchyIdMapped = "/",
ColumnSqlVariantMapped = "This is variant!",
ColumnUniqueIdentifierMapped = Guid.NewGuid(),
ColumnXmlMapped = "<xml><person><id>1</id><name>Michael</name></person><person><id>2</id><name>RepoDb</name></person></xml>"
};
using (var repository = new OthersMapClassRepository(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = repository.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = repository.QueryAsync(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnHierarchyIdMapped.ToString(), data.ColumnHierarchyIdMapped?.ToString());
Assert.AreEqual(entity.ColumnSqlVariantMapped, data.ColumnSqlVariantMapped);
Assert.AreEqual(entity.ColumnUniqueIdentifierMapped, data.ColumnUniqueIdentifierMapped);
Assert.AreEqual(entity.ColumnXmlMapped, data.ColumnXmlMapped);
}
}
