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