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