public void TestBaseRepositoryBytesNullCrudAsync()
{
// Setup
var entity = new BytesClass
{
SessionId = Guid.NewGuid(),
ColumnBinary = null,
ColumnImage = null,
ColumnTinyInt = null,
ColumnVarBinary = null
};
using (var repository = new BytesClassRepository(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = repository.InsertAsync(entity);
var id = insertResult.Result.Extract();
// Act Query
var queryResult = repository.QueryAsync(e => e.SessionId == (Guid)id);
var data = queryResult.Result.Extract().FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnBinary);
Assert.IsNull(data.ColumnImage);
Assert.IsNull(data.ColumnTinyInt);
Assert.IsNull(data.ColumnVarBinary);
}
}
public void TestBaseRepositoryBytesCrudAsync()
{
// Setup
var text = Helper.GetAssemblyDescription();
var bytes = Encoding.UTF8.GetBytes(text);
var entity = new BytesClass
{
SessionId = Guid.NewGuid(),
ColumnBinary = bytes,
ColumnImage = bytes,
ColumnVarBinary = bytes,
ColumnTinyInt = 128
};
using (var repository = new BytesClassRepository(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = repository.InsertAsync(entity);
var id = insertResult.Result.Extract();
// Act Query
var queryResult = repository.QueryAsync(e => e.SessionId == (Guid)id);
var data = queryResult.Result.Extract().FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(text, Encoding.UTF8.GetString(data.ColumnBinary.Take(entity.ColumnBinary.Length).ToArray()));
Assert.AreEqual(text, Encoding.UTF8.GetString(data.ColumnImage));
Assert.AreEqual(text, Encoding.UTF8.GetString(data.ColumnVarBinary));
Assert.AreEqual(entity.ColumnTinyInt, data.ColumnTinyInt);
}
}
