protected override void OnApplicationStarted()
        {
            var connectionString = ConfigurationManager.ConnectionStrings ["AspSQLProvider"];

            MvcStoreApplication.InitDb(connectionString.ConnectionString);

            AreaRegistration.RegisterAllAreas();
            RegisterRoutes(RouteTable.Routes);
        }
 protected void Application_EndRequest(object sender, EventArgs e)
 {
     MvcStoreApplication.CloseSession(HttpContext.Current);
 }
 protected void Application_BeginRequest(object sender, EventArgs e)
 {
     MvcStoreApplication.OpenSession(HttpContext.Current);
 }