/// <summary> /// Get IEnumerable of all foos /// </summary> /// <returns></returns> public async Task <IEnumerable <Foo> > GetFoos() { var param = new OracleDynamicParameters(); param.Add("cursor_", dbType: OracleDbType.RefCursor, direction: ParameterDirection.Output); var record = await _queryFactory.QueryAsync <Foo>(UrlConfigurations.GetFoos, param, null, null, CommandType.StoredProcedure); return(record); }