/// <summary> /// Get foo by foo id /// </summary> /// <param name="fooId"></param> /// <returns></returns> public async Task <Foo> GetFoo(int fooId) { var param = new OracleDynamicParameters(); param.Add("FOOID", fooId, OracleDbType.Int32, ParameterDirection.Input); param.Add("cursor_", dbType: OracleDbType.RefCursor, direction: ParameterDirection.Output); var record = await _queryFactory.QueryFirstOrDefaultAsync <Foo>(UrlConfigurations.GetFoo, param, null, null, CommandType.StoredProcedure); return(record); }