public void TestDateTime()
{
DBHelper dbHelper = new DBHelper(DatabaseType.MicrosoftSQLServer);
SetupTestDatabaseForMSSQL(dbHelper);
Query q = new Query("INSERT INTO test_table (ID, DateCreated) " +
"VALUES (1, @dateCreated)");
q.addDateTimeParameter("datecreated", DateTime.Today.Date);
SqlResult result = dbHelper.executeQuery(q);
Assert.IsNotNull(result);
Query q2 = new Query("SELECT DateCreated " +
"FROM test_table " +
"WHERE ID=1");
result = dbHelper.executeQuery(q2);
Assert.IsNotNull(result);
Assert.IsTrue(result.DataRemaining());
result.NextRow();
Assert.AreEqual(DateTime.Today.Date, result.ReadDateTime("DateCreated"));
Query q3 = new Query("DELETE FROM test_table " +
"WHERE ID=1");
result = dbHelper.executeQuery(q3);
Assert.IsNotNull(result);
}
