public void MultiLayerTest()
{
//assign
var validData = TestDataSupplier.GetMultiLayerData();
//arrange
var mappedData = _ctx.MultiLayerModel.GetSingle("test query 3 multi", CommandType.Text);
//assert
Assert.AreEqual(mappedData, validData);
}
public void MappedObjectShouldContainTheSameMultiSetValuesWithMultiRows()
{
//assign
var validData = TestDataSupplier.GetMultiResultSetMappedDataWithMultiRows();
//arrange
var mappedData = _ctx.MultiResultSetMapping2.GetSingle("test query 2 multi", CommandType.Text);
//assert
Assert.AreEqual(mappedData, validData);
}
public void MappedObjectShouldContainTheSameGrouppedValues()
{
//assign
var validData = TestDataSupplier.GetSingleResultSetMappedDataWithGrouppedData();
//arrange
var mappedData = _ctx.SingleResultSetWithGroupModel.GetSingle("test query 3", CommandType.Text);
//assert
Assert.AreEqual(mappedData, validData);
}
public void MappedObjectShouldContainTheSameMultiRowsValues()
{
//assign
var validData = TestDataSupplier.GetSingleResultSetMappedWithMultiRows();
//arrange
var mappedData = _ctx.SingleResultSetMapping.Search("test query 2", CommandType.Text).ToList();
//assert
CollectionAssert.AreEqual(mappedData, validData);
}
public void CommandResultShouldReturnTheSameValueBeforeMapping()
{
//assign
var dataToExpect = TestDataSupplier.GetSingleResultSetQueryData();
//arrange
var mappedData = _ctx.GetData("test query 1", CommandType.Text).FirstOrDefault();
//assert
CollectionAssert.AreEquivalent(mappedData.Columns.ToList(), dataToExpect.ToList());
}
public void CommandResultShouldReturnTheSameListValuesWithMultiRowsBeforeMapping()
{
//assign
var dataToExpect = TestDataSupplier.GetMultiResultSetQueryDataWithMultipleRows();
var mappedData = _ctx.GetData("test query 2 multi", CommandType.Text);
//arrange
var actualData = dataToExpect.SelectMany(s => s.ToKeyValuePairs()).ToList();
var mappedColumns = mappedData.SelectMany(s => s.Columns.ToKeyValuePairs()).ToList();
//assert
CollectionAssert.AreEquivalent(mappedColumns, actualData);
}
public void CommandResultShouldReturnTheSameValueBeforeMappingWithGroupData()
{
//assign
var dataToExpect = TestDataSupplier.GetSingleResultSetWithGrouppedData();
var mappedData = _ctx.GetData("test query 3", CommandType.Text);
//arrange
var actualData = dataToExpect.SelectMany(s => s.ToKeyValuePairs()).ToList();
var data = mappedData.SelectMany(s => s.Columns.ToKeyValuePairs()).ToList();
//assert
CollectionAssert.AreEquivalent(data, actualData);
}
