public async Task <List <AccountBalance> > GetAccountBalances(List <long> accountIds) { var accountParametersTable = new AccountIdUserTableParam(accountIds); accountParametersTable.Add("@allowancePercentage", _configuration.TransferAllowancePercentage, DbType.Decimal); var result = await _db.Value.Database.Connection.QueryAsync <AccountBalance>( sql : "[employer_financial].[GetAccountBalance_ByAccountIds]", param : accountParametersTable, transaction : _db.Value.Database.CurrentTransaction.UnderlyingTransaction, commandType : CommandType.StoredProcedure); return(result.ToList()); }
public async Task <List <AccountBalance> > GetAccountBalances(List <long> accountIds) { var result = await WithConnection(async c => { var parameters = new AccountIdUserTableParam(accountIds); return(await c.QueryAsync <AccountBalance>( "[employer_financial].[GetAccountBalance_ByAccountIds]", parameters, commandType: CommandType.StoredProcedure)); }); return(result.ToList()); }