Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > LLBLGen Pro Runtime Framework> Lock Hints?
 

Pages: 1
LLBLGen Pro Runtime Framework
Lock Hints?
Page:1/1 

  Print all messages in this thread  
Poster Message
Ian
User



Location:
Hertfordshire, UK
Joined on:
01-Apr-2005 16:37:36
Posted:
511 posts
# 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.
  Top
daelmo
Support Team



Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
8110 posts
# 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'ing (articles and code snippets) | linkedin | twitter
 
Top
Ian
User



Location:
Hertfordshire, UK
Joined on:
01-Apr-2005 16:37:36
Posted:
511 posts
# 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.
  Top
cerberis
User



Location:

Joined on:
20-May-2011 14:23:12
Posted:
89 posts
# Posted on: 15-Jun-2011 17:51:22.  
So is this feature not yet supported?

  Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
14585 posts
# 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
  Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.