/// <summary> /// Selects a single row from database given a condition /// </summary> /// <typeparam name="T">Model type to returned</typeparam> /// <param name="ProcedureName">SQL Procedure Name</param> /// <param name="Parameters">DyanmicParameters</param> /// <returns>Returns one record of type T</returns> public async Task <T> QuerySingle <T>(string ProcedureName, List <ParameterModel> ParameterList) { DynamicParameters parameters = ParameterManager.CreateParameters(ParameterList); using (IDbConnection connection = new SqlConnection(_connectionString)) { try { var result = await connection.QueryAsync <T>(ProcedureName, parameters, commandType : CommandType.StoredProcedure); return(result.FirstOrDefault()); } catch (System.Exception e) { //Throw Exception throw e; } } }
/// <summary> /// Common Execute Proc with results /// </summary> /// <param name="ProcedureName">SQL Procedure Name</param> /// <param name="Parameters">DyanmicParameters</param> /// <returns>Returns results from proc as int</returns> public async Task <T> ExecuteProc <T>(string ProcedureName, List <ParameterModel> ParameterList) { DynamicParameters parameters = ParameterManager.CreateParameters(ParameterList); using (IDbConnection connection = new SqlConnection(_connectionString)) { try { return(await connection.ExecuteScalarAsync <T>(ProcedureName, parameters, commandTimeout : _commandTimeout, commandType : CommandType.StoredProcedure)); } catch (System.Exception e) { //Throw Exception throw e; } } }