public void TestBaseRepositoryBytesMappedNullCrudAsync()
{
// Setup
var entity = new BytesMapClass
{
SessionId = Guid.NewGuid(),
ColumnBinaryMapped = null,
ColumnImageMapped = null,
ColumnTinyIntMapped = null,
ColumnVarBinaryMapped = null
};
using (var repository = new BytesMapClassRepository(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.ColumnBinaryMapped);
Assert.IsNull(data.ColumnImageMapped);
Assert.IsNull(data.ColumnTinyIntMapped);
Assert.IsNull(data.ColumnVarBinaryMapped);
}
}
public void TestBaseRepositoryBytesMappedCrudAsync()
{
// Setup
var text = Helper.GetAssemblyDescription();
var bytes = Encoding.UTF8.GetBytes(text);
var entity = new BytesMapClass
{
SessionId = Guid.NewGuid(),
ColumnBinaryMapped = bytes,
ColumnImageMapped = bytes,
ColumnVarBinaryMapped = bytes,
ColumnTinyIntMapped = 128
};
using (var repository = new BytesMapClassRepository(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.ColumnBinaryMapped.Take(entity.ColumnBinaryMapped.Length).ToArray()));
Assert.AreEqual(text, Encoding.UTF8.GetString(data.ColumnImageMapped));
Assert.AreEqual(text, Encoding.UTF8.GetString(data.ColumnVarBinaryMapped));
Assert.AreEqual(entity.ColumnTinyIntMapped, data.ColumnTinyIntMapped);
}
}
