DevForce Community Forum : Using TransactionScope for volatile data http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Using TransactionScope for volatile data Wed, 13 May 2026 19:18:05 -700 Fri, 11 Nov 2011 10:02:01 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3088 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Using TransactionScope for volatile data : By default DevForce uses a... http://www.ideablade.com/forum/forum_posts.asp?TID=3088&PID=12036#12036 Author: kimj
Subject: 3088
Posted: 11-Nov-2011 at 10:02am

By default DevForce uses a TransactionScope with an IsolationLevel of ReadCommitted for every query or save.  You can change this default by changing the TransactionSettings.Default or setting the TransactionSettings on the QueryStrategy and/or SaveOptions.   For example to change the default:
 
  TransactionSettings.Default = new TransactionSettings(IsolationLevel.ReadCommitted, TimeSpan.FromSeconds(30), true);
]]> Fri, 11 Nov 2011 10:02:01 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3088&PID=12036#12036 Using TransactionScope for volatile data : We have a Silverlight... http://www.ideablade.com/forum/forum_posts.asp?TID=3088&PID=12028#12028 Author: JohnBloom
Subject: 3088
Posted: 10-Nov-2011 at 10:25am

We have a Silverlight app and have a process on the serverthat grabs a number from the database and increments the number by oneafterwards. We need to make sure that the number is never grabbed at the sametime producing duplicate records. There is also logic that tells which numberfield in the entity to increment, so auto incrementing fields won’t work. Inour previous product we use SQL Transactions and they worked great.

I found an implementation for Transactions in EntityFramework here:

http://geekswithblogs.net/SudheersBlog/archive/2010/04/11/139193.aspx

I there are lots of options transactionscope:

http://enggtech.wordpress.com/2009/10/16/transactionscope-class-system-transactions/

I have tried many combinations of these settings and I alwaysget the same error:

“The transaction specified for TransactionScope has adifferent IsolationLevel than the value requested for the scope.  Parameter name: transactionOptions.IsolationLevel”

Does anybody have an example of doing transactions inDevforce that are outside the CRUD model?

]]> Thu, 10 Nov 2011 10:25:10 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3088&PID=12028#12028