>I can't use this method because i must do a query to pass to SQL SERVER.

One other approach is to try the following...
I am not at my SQL box, so I can't actually
do the command but could act as a baseline...

select 
    identity(int,1,1) UniqueID, a.*
  from
    yourtable a
  where
    fld = 'test'
  having
    UniqueID = 1

You might have to play with the having (or even where) to

where identity( int, 1, 1 ) = 1 AND fld = 'test'
or 
having identity( int, 1,1 ) = 1