Query Expression No Lock Property

Posted: August 17, 2012 in CRM 2011

Reblogged from Danny Varghese's Blog:

There's a new property called "NoLock" added to the QueryExpression class for Microsoft Dynamics CRM 2011.  I found this researching a locking issue on the database we were having for a client.    According to the Microsoft CRM 2011 SDK:

"The benefit of setting NoLock to true is that it allows you to keep the system from issuing locks against the entities in your queries; this increases concurrency and performance because the database engine does not have to maintain the shared locks involved.

Read more… 143 more words

Comments
  1. Thanks Nishant! And Varun, you are correct, it’s present in the fetch xml as well. Thanks guys!

  2. varun kumar says:

    We have to same property in fetch xml as well

Share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s