Linq to SQL isolation level with multiple datacontext

Question

Hi!

 

I'm developping an aplication using ASP.NET MVC and i'm using Linq to SQL in my data access layer. I have a "factory" that gives me a new DataContext for each HttpContext:

public class DataContextFactory
    {

        public static DataContext GetWebRequestDataContext()
        {
            DataContext context = (DataContext)HttpContext.Current.Items["DataContext"];
            if (context == null)
            {
                context =
                    new DataContext(
                        ConfigurationManager.ConnectionStrings["REPOSITORY_LINQ_CS"].ConnectionString);
                HttpContext.Current.Items["DataContext"] = context;
            }
            return context;
        }
    }

 

Now i am trying to garantee isolation levels in my application and a have a question... If i use the DataContext.Transaction property do i garantee isolation between different requests?because each request will have his own DataContext..

 

what about if i use:

 using 
(TransactionScope 
trans = new 
TransactionScope
())


  { /*my code*/}

do i garantee the isolation between different requests?

 

Thank you,

 

Tiago Lopes

 

Answer 1

I'm not sure you are clear of what isolation is.

Read this

http://msdn.microsoft.com/en-us/library/eh5d60e1(VS.80).aspx

Regards

Answer 2

Hi, Were u able to get solution. I'm facing same sort of problem. thanks

Answer 3

Take a look at this post.

http://stackoverflow.com/a/12559851/350977

---

Please Mark as Reply and Vote as Helpful if I helped.

Also please visit my blog http://msguy.net/