public void TestDbRepositoryBytesMappedCrud()
{
// Setup
var text = "RepoDb"; // 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 DbRepository <SqlConnection>(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = repository.Insert(entity);
// Act Query
var data = repository.Query <BytesMapClass>(e => e.SessionId == (Guid)id).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);
}
}
public void TestBaseRepositoryBytesMappedNullCrud()
{
// 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 id = repository.Insert(entity);
// Act Query
var data = repository.Query(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnBinaryMapped);
Assert.IsNull(data.ColumnImageMapped);
Assert.IsNull(data.ColumnTinyIntMapped);
Assert.IsNull(data.ColumnVarBinaryMapped);
}
}
public void TestDbRepositoryBytesMappedNullCrudAsync()
{
// Setup
var entity = new BytesMapClass
{
SessionId = Guid.NewGuid(),
ColumnBinaryMapped = null,
ColumnImageMapped = null,
ColumnTinyIntMapped = null,
ColumnVarBinaryMapped = 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 <BytesMapClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnBinaryMapped);
Assert.IsNull(data.ColumnImageMapped);
Assert.IsNull(data.ColumnTinyIntMapped);
Assert.IsNull(data.ColumnVarBinaryMapped);
}
}
public void TestSqlConnectionBytesMappedCrudAsync()
{
// 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 connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = connection.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = connection.QueryAsync <BytesMapClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.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);
}
}