/// <summary> /// Gets stored procedure result. /// </summary> /// <typeparam name="TEntity">Type of entity.</typeparam> /// <typeparam name="TResult">Type of result.</typeparam> /// <param name="name">name of stored procedure</param> /// <param name="parameters">parameters of stored procedure</param> /// <param name="storedProcedureReturnData">stored procedure return data type</param> /// <returns>result</returns> private async Task <TResult> GetSpResult <TEntity, TResult>( string name, IEnumerable <KeyValuePair <string, object> > parameters, StoredProcedureReturnData storedProcedureReturnData) where TEntity : class { var sp = SpHelper.CreateSp(name, parameters, storedProcedureReturnData); var dbResult = await this.ExecuteAsync <TEntity>(sp); var result = SpHelper.GetResult <TResult>(dbResult); return(result); }