My base controller class, BaseController
, is inherited by public-facing controllers to access a shared data context between requests with LINQ-to-SQL.
HttpContext.Current.Items
for each HTTP request?DataContextHelper
classinternal static class DataContextHelper
{
public static MyDataContext CurrentContext
{
get
{
if (HttpContext.Current.Items["MyDataContext"] == null)
{
MyDataContext context = new MyDataContext();
HttpContext.Current.Items["MyDataContext"] = context;
}
return (MyDataContext)HttpContext.Current.Items["MyDataContext"];
}
}
}
BaseController
class:public class BaseController : Controller
{
protected MyDataContext db
{
get {
return DataContextHelper.CurrentContext;
}
}
}
HomeController
class:[HandleError]
public class HomeController : BaseController // inherits db member
{
public ActionResult SomeAction(string id)
{
User user = db.Users.First(u => u.UserId == id);
// ... do stuff
db.SubmitChanges();
}
}
Yes, this is a common pattern with all the major ORMs with both WebForms and MVC.
The only thing I would add a explicit dispose after each controller action is executed. just to make sure everything is disposed of correctly.
In BaseController.cs:
protected override void OnActionExecuted(ActionExecutedContext filterContext)
{
if (HttpContext.Current.Items["MyDataContext"] == null)
return;
var context = (MyDataContext)HttpContext.Current.Items["MyDataContext"];
context.Dispose();
}
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With