public void TestIntParametrization()
{
DBHelper dbHelper = new DBHelper(DatabaseType.MicrosoftSQLServer);
SetupTestDatabaseForMSSQL(dbHelper);
Query q = new Query("INSERT INTO test_table (ID, Description) " +
"VALUES (@id, 'ettal')");
q.addIntParameter("id", 1);
SqlResult result = dbHelper.executeQuery(q);
Assert.IsNotNull(result);
Query q2 = new Query("SELECT Description " +
"FROM test_table " +
"WHERE ID=@id");
q2.addIntParameter("id", 1);
result = dbHelper.executeQuery(q2);
Assert.IsNotNull(result);
Assert.IsTrue(result.DataRemaining());
result.NextRow();
var strResult = result.ReadString("Description");
Assert.AreEqual("ettal", strResult);
Query q3 = new Query("DELETE FROM test_table " +
"WHERE ID=1");
result = dbHelper.executeQuery(q3);
Assert.IsNotNull(result);
}
