I'm using Adapter and I want to have 'WITH (READPAST)' on a SELECT so that the query doesn't block on locked rows.
I remembered how I dealt with this once before actually - I just wrapped a basic SELECT with the lock hint in a view and generated a corresponding LLBLGen entity from the view. Then whenever the entity is used it will always come with the lock hint.