public void SelectTable_SelectWholeTable()
{
OleDbQuery odd = new OleDbQuery();
Assert.IsTrue(odd.TestConnection(connectionString, true, false));
Assert.IsNotNull(odd.SelectTable("SELECT * FROM TestTable;"));
Assert.IsNullOrEmpty(odd.LastOperationErrorMessage);
}
public void SelectTable_SelectTableUsingArguments()
{
OleDbQuery odd = new OleDbQuery();
Assert.IsTrue(odd.TestConnection(connectionString, true, false));
Assert.AreEqual("a", odd.SelectTable("SELECT f1 FROM TestTable WHERE f1=@param;", new OleDbParameter("@param", 'a')).Rows[0].ItemArray[0]);
Assert.IsNullOrEmpty(odd.LastOperationErrorMessage);
}
public void ChangeData_CreateTable()
{
OleDbQuery odd = new OleDbQuery();
Assert.IsTrue(odd.TestConnection(connectionString, true, false));
if (odd.SelectTable("SELECT * FROM test;") != null)
{
odd.ChangeData(sqlDropTestTable);
}
Assert.GreaterOrEqual(0, odd.ChangeData(sqlTestTableStatement));
Assert.IsNullOrEmpty(odd.LastOperationErrorMessage);
}
