I'm wondering if there's any capability of the generated entity objects to provide locking hints for dynamically generated SELECT statements. I see that the Transaction object has an argument for IsolationLevel. But, I'm wondering if there's a way to specify the equivelant of a "WITH(NOLOCK)" (for a dirty read) at the select statement level at runtime.
Basically, I'd like to have the power to run SELECTs with dirty reads as appropriate without the overhead of creating lots of transactions.
Is there a way to do this?