/// <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);
}