public void TestQueryDataTableException() { //arrange bool expect = true; bool actual = true; IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString); DataTable result; DataAccessCommand command = new DataAccessCommand(); string errMessage = ""; //act command.SqlCommand = @"SELECT * FROM TABLE WHERE COLUMNNAME=:ROOM_ID"; command.AddParameter("ggdg", "fdsfsd"); command.AddParameter("efe", "434"); command.AddParameter("fe23", "fdr3sfsd"); try { result = target.QueryWithDataTable(command); } catch (CommandExecutionExeception ex) { errMessage = ex.DetailErrorMessage; actual = (errMessage != ""); } //assert Assert.AreEqual(expect, actual); }
public void TestQueryDataTableWithParameter() { //arrange bool expect = true; bool actual = true; IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString); DataTable result; DataAccessCommand command = new DataAccessCommand(); //act command.SqlCommand = @" SELECT * FROM TABLE WHERE ID=:ROOM_ID"; command.AddParameter("ROOM_ID", 150376); result = target.QueryWithDataTable(command); actual = (result != null); //assert Assert.AreEqual(expect, actual); }
public void TestQueryDataTable() { //arrange bool expect = true; bool actual = true; IDatabaseAccess target = new OracleClientDataAccess(this._ConnectionString); DataTable result; DataAccessCommand command = new DataAccessCommand(); //act command.SqlCommand = "SELECT SYSDATE FROM DUAL"; result = target.QueryWithDataTable(command); actual = (result != null); //assert Assert.AreEqual(expect, actual); }