private void btnReadFromSql_Click(object sender, EventArgs e)
{
lbFileOutput.Items.Clear();
var sqlConnectionString = Properties.Resources.SqlConnectionString;
var dataTableQueryString = @"SELECT [CustomerID], [CompanyName] ,[ContactName] FROM [Customers]";
var conventionalAdo = new DatabaseAccess.ConventionalAdo();
var runQueryTable = conventionalAdo.RunQueryTable(sqlConnectionString, dataTableQueryString);
foreach (DataRow dataRow in runQueryTable.Rows)
{
lbFileOutput.Items.Add($"ID: {dataRow["CustomerID"]}, Customer Name: {dataRow["ContactName"]}");
}
}
public void RunQueryTableTest()
{
var sqlConnectionString = Properties.Resources.SqlConnectionString;
var dataTableQueryString = @"SELECT [CustomerID], [CompanyName] ,[ContactName] FROM [Customers]";
var conventionalAdo = new DatabaseAccess.ConventionalAdo();
var runQueryTable = conventionalAdo.RunQueryTable(sqlConnectionString, dataTableQueryString);
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);
}