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