private void btnReadFromSql_Click(object sender, EventArgs e)
{
lbFileOutput.Items.Clear();
var sqlConnectionString = Properties.Settings.Default.SqlConnectionString;
var dataTableQueryString = @"SELECT [CustomerID] ,[CompanyName] ,[ContactName] FROM [Customers]";
var conventionalAdo = new DatabaseDemonstrator.ConventionalAdo();
var runQueryTable = conventionalAdo.RunQueryTable(sqlConnectionString, dataTableQueryString);
foreach (DataRow dataRow in runQueryTable.Rows)
{
var displayString = $"ID:{dataRow[0]},\tCustomer Name:{dataRow[2]}";
lbFileOutput.Items.Add(displayString);
}
}
public void RunQueryTableTest()
{
// Arrange
var sqlConnectionString = Properties.Resources.SqlConnectionString;
var dataTableQueryString = @"SELECT [CustomerID] ,[CompanyName] ,[ContactName] FROM [Customers]";
// Act
var conventionalAdo = new DatabaseDemonstrator.ConventionalAdo();
var runQueryTable = conventionalAdo.RunQueryTable(sqlConnectionString, dataTableQueryString);
// Assert
runQueryTable.ShouldNotBeNull();
runQueryTable.Columns.Count.ShouldBe(3);
runQueryTable.Columns[0].ColumnName.ShouldBe("CustomerID");
runQueryTable.Columns[1].ColumnName.ShouldBe("CompanyName");
runQueryTable.Columns[2].ColumnName.ShouldBe("ContactName");
runQueryTable.Rows.Count.ShouldBeGreaterThan(0);
runQueryTable.Rows[0].ItemArray.Length.ShouldBe(3);
}
