Lock Hints?

Posts   
 
    
Ian avatar
Ian
User
Posts: 511
Joined: 01-Apr-2005
# Posted on: 30-Apr-2010 19:57:59   

Hi there,

Are SQL Server lock hints (e.g. WITH (UPDLOCK READPAST) ) still unsupported? Do you recommend a stored procedure instead?

Cheers, Ian.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 01-May-2010 05:04:50   

Are you using Adapter or SelfServicing? Do you need the lock per call, per connection or globally? Why do you need that?

David Elizondo | LLBLGen Support Team
Ian avatar
Ian
User
Posts: 511
Joined: 01-Apr-2005
# Posted on: 02-May-2010 17:13:30   

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.

cerberis
User
Posts: 92
Joined: 20-May-2011
# Posted on: 15-Jun-2011 17:51:22   

So is this feature not yet supported?

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 15-Jun-2011 19:05:16   

You'll need to implement it. Please check this thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=16508