DevForce Community Forum : isolation level http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : isolation level Sun, 12 Apr 2026 00:24:09 -700 Wed, 16 Feb 2011 15:47:21 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2512 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ isolation level : Hi BillG;Here's an example.... http://www.ideablade.com/forum/forum_posts.asp?TID=2512&PID=9973#9973 Author: DenisK
Subject: 2512
Posted: 16-Feb-2011 at 3:47pm

Hi BillG;

Here's an example. 1 for saving, 1 for querying.

TransactionSettings settings = new TransactionSettings(System.Transactions.IsolationLevel.ReadCommitted, 
                                                                                         new TimeSpan(0, 1, 0));

mgr.DefaultSaveOptions.TransactionSettings = settings;

TransactionSettings settings2 = new TransactionSettings(System.Transactions.IsolationLevel.Serializable, 
                                                                                         new TimeSpan(0, 1, 0));

QueryStrategy qs = new QueryStrategy(QueryStrategy.Normal, settings2);
mgr.DefaultQueryStrategy = qs;

And the link to our DRC that briefly talks about this. 

http://drc.ideablade.com/xwiki/bin/view/Documentation/Transactional-Queries

Hope this helps.


Edited by DenisK - 16-Feb-2011 at 3:47pm]]> Wed, 16 Feb 2011 15:47:21 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2512&PID=9973#9973 isolation level : Can you provide an example of... http://www.ideablade.com/forum/forum_posts.asp?TID=2512&PID=9970#9970 Author: BillG
Subject: 2512
Posted: 16-Feb-2011 at 12:08pm

Can you provide an example of setting the isolation level?
 
Bascially what I need is I have a method that grabs the next invoice # from a table, increments it and saves it back to the table. I want the above to be part of the same transaction and I want to block other users from grabbing a number until another user has written back the next number.
 
Bill
 
]]> Wed, 16 Feb 2011 12:08:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2512&PID=9970#9970