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