Hi, all. How can I use the update lockhint(UPDLOCK) optimization in DLINQ? I knew that the LINQ to SQL is designed primarily for optimistic concurrency( http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1344034&SiteID=1 ), but I want to use the pessimistic concurrency in some scenario. For example, how can I use the UPDLOCK in the below code? Code Snippet using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew)) { PubsDataContext db = new PubsDataContext();
Read More...