public void TestBaseRepositoryStringsNullCrud()
{
// Setup
var entity = new StringsClass
{
SessionId = Guid.NewGuid(),
ColumnChar = null,
ColumnNChar = null,
ColumnNText = null,
ColumnNVarChar = null,
ColumnText = null,
ColumnVarChar = null
};
using (var repository = new StringsClassRepository(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.ColumnChar);
Assert.IsNull(data.ColumnNChar);
Assert.IsNull(data.ColumnNText);
Assert.IsNull(data.ColumnNVarChar);
Assert.IsNull(data.ColumnText);
Assert.IsNull(data.ColumnVarChar);
}
}
public void TestBaseRepositoryStringsCrud()
{
// Setup
var text = Helper.GetUnicodeString();
var entity = new StringsClass
{
SessionId = Guid.NewGuid(),
ColumnChar = text,
ColumnNChar = text,
ColumnNText = text,
ColumnNVarChar = text,
ColumnText = text,
ColumnVarChar = text
};
using (var repository = new StringsClassRepository(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.ColumnChar, data.ColumnChar.Trim());
Assert.AreEqual(entity.ColumnNChar, data.ColumnNChar.Trim());
Assert.AreEqual(entity.ColumnNText, data.ColumnNText);
Assert.AreEqual(entity.ColumnNVarChar, data.ColumnNVarChar);
Assert.AreEqual(entity.ColumnText, data.ColumnText);
Assert.AreEqual(entity.ColumnVarChar, data.ColumnVarChar);
}
}
