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