protected override void PopulateDb(dba odbcDba)
{
tblTestRow [] rows = new tblTestRow [] {
new tblTestRow(1, "Number one."),
new tblTestRow(2, "Number two."),
new tblTestRow(3, "Number three.")
};
odbcDba.ExecuteSqlCommand(_sqlCreateTable);
foreach (tblTestRow row in rows)
{
OdbcParameter[] parameters = new OdbcParameter [] {
new OdbcParameter("@idParam", row.Id),
new OdbcParameter("@descriptionParam", row.Description)
};
odbcDba.ExecuteSqlCommand(_sqlInsertRow, parameters);
}
string [] columnData = odbcDba.GetColumnAsStringArray("tblTest", "description");
Assert.AreEqual(columnData.Length, 3, "Inserted 3 rows and retrieved {0}", new object[] { columnData.Length });
}
private static void PopulateSQLite(SQLiteDba sqliteDba)
{
tblTestRow [] rows = new tblTestRow [] {
new tblTestRow(1, "Number one."),
new tblTestRow(2, "Number two."),
new tblTestRow(3, "Number three.")
};
sqliteDba.ExecuteSqlCommand(_sqlCreateTable);
foreach (tblTestRow row in rows)
{
DbParameter[] parameters = new DbParameter [] {
new SQLiteParameter("@id", row.Id),
new SQLiteParameter("@description", row.Description)
};
sqliteDba.ExecuteSqlCommand(_sqlInsertRow, parameters);
}
string [] columnData = sqliteDba.GetColumnAsStringArray("tblTest", "description");
Assert.AreEqual(columnData.Length, 3, "Inserted 3 rows and retrieved {0}", new object[] { columnData.Length });
}
protected override void PopulateDb(dba odbcDba)
{
tblTestRow [] rows = new tblTestRow [] {
new tblTestRow(1, "Number one."),
new tblTestRow(2, "Number two."),
new tblTestRow(3, "Number three.")
};
odbcDba.ExecuteSqlCommand(_sqlCreateTable);
foreach(tblTestRow row in rows) {
OdbcParameter[] parameters = new OdbcParameter [] {
new OdbcParameter("@idParam", row.Id),
new OdbcParameter("@descriptionParam", row.Description)
};
odbcDba.ExecuteSqlCommand(_sqlInsertRow, parameters);
}
string [] columnData = odbcDba.GetColumnAsStringArray("tblTest", "description");
Assert.AreEqual(columnData.Length, 3, "Inserted 3 rows and retrieved {0}", new object[] {columnData.Length});
}
private static void PopulateSQLite(SQLiteDba sqliteDba)
{
tblTestRow [] rows = new tblTestRow [] {
new tblTestRow(1, "Number one."),
new tblTestRow(2, "Number two."),
new tblTestRow(3, "Number three.")
};
sqliteDba.ExecuteSqlCommand(_sqlCreateTable);
foreach(tblTestRow row in rows) {
DbParameter[] parameters = new DbParameter [] {
new SQLiteParameter("@id", row.Id),
new SQLiteParameter("@description", row.Description)
};
sqliteDba.ExecuteSqlCommand(_sqlInsertRow, parameters);
}
string [] columnData = sqliteDba.GetColumnAsStringArray("tblTest", "description");
Assert.AreEqual(columnData.Length, 3, "Inserted 3 rows and retrieved {0}", new object[] {columnData.Length});
}
