Best way of creating and reusing datacontext in asp.net mvc application

See more:

LINQ

static

MVC4

ASP.NET4

, +

Hello Guys,

I read below post and confused what is the best way for datacontext creation and consumption ?

http://www.foliotek.com/devblog/avoid-static-variables-in-asp-net/[^]

I always thought that we should use singleton like below(+locking)

private static ModelDataContext dataContext=null;
protected static ModelDataContext DataContext
{
      get
      {
           if(dataContext==null)
               dataContext = new ModelDataContext();
           return dataContext;
       }
 }

However in the article he says shortly ;

LINQ DataContexts cache some of the data and changes you make – you can quickly eat up memory if each instance isn’t disposed fairly quickly. TableAdapters hold open SQLConnections for reuse – so if you use enough classes of TableAdapters, you can have enough different static vars to tie up all of your db connections.

and suggests to use the model below

protected static ModelDataContext DataContext
{
      get
      {
           if(System.Web.HttpContext.Current.Items["ModelDataContext"]==null)
               System.Web.HttpContext.Current.Items["ModelDataContext"] = new ModelDataContext();
           return (ModelDataContext)System.Web.HttpContext.Current.Items["ModelDataContext"];
       }
 }

What are your thoughts ?

Thanks