public void TestSqlConnectionStringsMappedCrud()
{
// Setup
var text = Helper.GetUnicodeString();
var entity = new StringsMapClass
{
SessionId = Guid.NewGuid(),
ColumnCharMapped = text,
ColumnNCharMapped = text,
ColumnNTextMapped = text,
ColumnNVarCharMapped = text,
ColumnTextMapped = text,
ColumnVarCharMapped = text
};
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = connection.Insert(entity);
// Act Query
var data = connection.Query <StringsMapClass>(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnCharMapped, data.ColumnCharMapped.Trim());
Assert.AreEqual(entity.ColumnNCharMapped, data.ColumnNCharMapped.Trim());
Assert.AreEqual(entity.ColumnNTextMapped, data.ColumnNTextMapped);
Assert.AreEqual(entity.ColumnNVarCharMapped, data.ColumnNVarCharMapped);
Assert.AreEqual(entity.ColumnTextMapped, data.ColumnTextMapped);
Assert.AreEqual(entity.ColumnVarCharMapped, data.ColumnVarCharMapped);
}
}
public void TestDbRepositoryStringsMappedCrudAsync()
{
// Setup
var text = Helper.GetUnicodeString();
var entity = new StringsMapClass
{
SessionId = Guid.NewGuid(),
ColumnCharMapped = text,
ColumnNCharMapped = text,
ColumnNTextMapped = text,
ColumnNVarCharMapped = text,
ColumnTextMapped = text,
ColumnVarCharMapped = text
};
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 <StringsMapClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.AreEqual(entity.ColumnCharMapped, data.ColumnCharMapped.Trim());
Assert.AreEqual(entity.ColumnNCharMapped, data.ColumnNCharMapped.Trim());
Assert.AreEqual(entity.ColumnNTextMapped, data.ColumnNTextMapped);
Assert.AreEqual(entity.ColumnNVarCharMapped, data.ColumnNVarCharMapped);
Assert.AreEqual(entity.ColumnTextMapped, data.ColumnTextMapped);
Assert.AreEqual(entity.ColumnVarCharMapped, data.ColumnVarCharMapped);
}
}
public void TestSqlConnectionStringsMappedNullCrudAsync()
{
// Setup
var entity = new StringsMapClass
{
SessionId = Guid.NewGuid(),
ColumnCharMapped = null,
ColumnNCharMapped = null,
ColumnNTextMapped = null,
ColumnNVarCharMapped = null,
ColumnTextMapped = null,
ColumnVarCharMapped = null
};
using (var connection = new SqlConnection(Database.ConnectionStringForRepoDb))
{
// Act Insert
var insertResult = connection.InsertAsync(entity);
var id = insertResult.Result;
// Act Query
var queryResult = connection.QueryAsync <StringsMapClass>(e => e.SessionId == (Guid)id);
var data = queryResult.Result.FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnCharMapped);
Assert.IsNull(data.ColumnNCharMapped);
Assert.IsNull(data.ColumnNTextMapped);
Assert.IsNull(data.ColumnNVarCharMapped);
Assert.IsNull(data.ColumnTextMapped);
Assert.IsNull(data.ColumnVarCharMapped);
}
}
public void TestDbRepositoryStringsMappedNullCrud()
{
// Setup
var entity = new StringsMapClass
{
SessionId = Guid.NewGuid(),
ColumnCharMapped = null,
ColumnNCharMapped = null,
ColumnNTextMapped = null,
ColumnNVarCharMapped = null,
ColumnTextMapped = null,
ColumnVarCharMapped = null
};
using (var repository = new DbRepository <SqlConnection>(Database.ConnectionStringForRepoDb))
{
// Act Insert
var id = repository.Insert(entity);
// Act Query
var data = repository.Query <StringsMapClass>(e => e.SessionId == (Guid)id).FirstOrDefault();
// Assert
Assert.IsNotNull(data);
Assert.IsNull(data.ColumnCharMapped);
Assert.IsNull(data.ColumnNCharMapped);
Assert.IsNull(data.ColumnNTextMapped);
Assert.IsNull(data.ColumnNVarCharMapped);
Assert.IsNull(data.ColumnTextMapped);
Assert.IsNull(data.ColumnVarCharMapped);
}
}
