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 TestDbRepositoryOthersNullCrudAsync()
{
// Setup
var entity = new OthersClass
{
SessionId = Guid.NewGuid(),
ColumnHierarchyId = null,
ColumnSqlVariant = null,
ColumnUniqueIdentifier = null,
ColumnXml = null
};
using (var repository = new DbRepository <SqlConnection>(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = repository.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = repository.QueryAsync <OthersClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.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);
}
}
public void TestSqlConnectionOthersCrudAsync()
{
// 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 connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = connection.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = connection.QueryAsync <OthersClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.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);
}
}
