public void ExecuteDataSet_MultiResultSet_BySqlString()
{
var sql = string.Concat(GetOrdersSql, ";", GetOrderDetailsSql);
using (var cmd = NorthwindAdoRepository.GetSqlStringCommand(sql))
using (var ds = NorthwindAdoRepository.ExecuteDataSet(cmd)) {
Assert.AreEqual(2, ds.Tables.Count);
ds.Tables.Cast <DataTable>().All(table => table.HasErrors == false).Should().Be.True();
}
}
public void ExecuteDataTableAsList_BySqlString()
{
var sql = string.Concat(GetOrdersSql, ";", GetOrderDetailsSql);
using (var cmd = NorthwindAdoRepository.GetSqlStringCommand(sql)) {
var tables = NorthwindAdoRepository.ExecuteDataTableAsList(cmd);
tables.Count.Should().Be(2);
tables.All(table => table.HasErrors == false).Should().Be.True();
}
}