public void TestExceptions()
{
// test exception: BeginTransaction, ExecuteQueryWithParams,
//ExecuteNonQuery, GetStringFromQuery, ExecuteNonQueryWithParams
//test exception
//stub: session.BeginTransaction() throw exception
try
{
simpleDB.BeginTransaction();
}
catch (System.Exception ex)
{
}
//test exception for ExecuteQueryWithParams
string wrongSQL = " SELECT CREATETIME,VALUE " +
" DATALOG_DP_LOG_TREND WHERE ENTITY_KEY = 1" +
" AND CREATETIME >= @StartDateValue" +
" AND CREATETIME <= @EndDateValue" +
" ORDER BY CREATETIME";
SqlParameter parameter1 = new SqlParameter();
parameter1.ParameterName = "StartDateValue";
parameter1.DbType = DbType.DateTime;
DateTime dtStart = DateTime.Now;
parameter1.Value = dtStart;
parameter1.Direction = System.Data.ParameterDirection.Input;
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(parameter1);
SqlParameter parameter2 = new SqlParameter();
parameter2.ParameterName = "EndDateValue";
parameter2.DbType = DbType.DateTime;
DateTime dtEnd = DateTime.Now;
parameter2.Value = dtEnd;
parameter2.Direction = System.Data.ParameterDirection.Input;
parameters.Add(parameter2);
System.Data.IDataReader drReader = simpleDB.ExecuteQueryWithParams(wrongSQL, parameters);
simpleDB.ExecuteNonQuery("select * entity");
simpleDB.GetStringFromQuery("select * entity");
simpleDB.ExecuteNonQueryWithParams("updat entity ", parameters);
}