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();
            }
        }