/// <summary> /// Executes the query /// </summary> /// <param name="commandText">command to run</param> /// <returns>list of mapped records</returns> protected List <TReturnType> ExecuteQuery(string commandText) { using (SqlCommand _Command = QueryService.ConfigureStoredProcedureCommand(commandText, _Parameters, _ConnectionString)) { return(QueryService.MapResults(_Command, Mapper)); } }
/// <summary> /// Executes the command and returns a return code (usually the inserted/deleted item Id) /// </summary> /// <param name="commandText">command to run</param> /// <returns>output of the command</returns> protected int ExecuteNonQuery(string commandText) { var returnParam = new SqlParameter("@ReturnValue", SqlDbType.Int) { Direction = ParameterDirection.ReturnValue }; _Parameters.Add(returnParam); using (SqlCommand _Command = QueryService.ConfigureStoredProcedureCommand(commandText, _Parameters, _ConnectionString)) { _Command.ExecuteNonQuery(); QueryService.DisposeOfConnection(_Command); return((int)returnParam.Value); } }