public void TestBaseRepositoryBytesNullCrud() { // 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 id = repository.Insert(entity); // Act Query var data = repository.Query(e => e.SessionId == (Guid)id).FirstOrDefault(); // Assert Assert.IsNotNull(data); Assert.IsNull(data.ColumnBinary); Assert.IsNull(data.ColumnImage); Assert.IsNull(data.ColumnTinyInt); Assert.IsNull(data.ColumnVarBinary); } }
public void TestBaseRepositoryBytesCrud() { // 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 id = repository.Insert(entity); // Act Query var data = repository.Query(e => e.SessionId == (Guid)id).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); } }