Databases
StackOverflow2013
Postsdbo
POHow can I implement a robust session-per-request pattern in my project, while focusing on information hiding?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow can I implement a robust session-per-request pattern in my project, while focusing on information hiding?
    primarykey
    data
    text
    <p>I'm currently building an ASP.NET MVC project, with NHibernate as its persistance layer.</p> <p>For now, some functionality have been implemented, but only use local NHibernate sessions: each method that accessed the database (read or write) needs to instantiate its own NHibernate session, with the "using()" clause.</p> <p>The problem is that I want to leverage NHibernate's lazy-loading capabilities to improve the performance of my project.</p> <p>This implies an open NHibernate session per request until the view is rendered. Furthermore, simultaneous requests must be supported (multiple Sessions at the same time).</p> <p>How can I achieve that as cleanly as possible?</p> <p>I searched the web a little bit and learned about the session-per-request pattern. Most of the implementations I saw used some sort of Http* (HttpContext, etc.) object to store the session. Also, using the Application_BeginRequest/Application_EndRequest functions is complicated, since they get fired for each HTTP request (aspx files, css files, js files, etc.), when I only want to instantiate a session once per request.</p> <p>The concern that I have is that I don't want my views or controllers to have access to NHibernate sessions (or, more generally, NHibernate namespaces and code). That means that I do not want to handle sessions at the controller level nor the view one.</p> <p>I have a few options in mind. Which one seems the best?</p> <ul> <li>Use interceptors (like in GRAILS) that get triggered before and after the controller action. These would open and close sessions/transactions. Is this possible in the ASP.NET MVC world?</li> <li>Use the CurrentSessionContext Singleton provided by NHibernate in a Web context. Using <a href="http://hackingon.net/post/NHibernate-Session-Per-Request-with-ASPNET-MVC.aspx" rel="noreferrer">this page</a> as an example, I think this is quite promising, but that still requires filters at the controller level.</li> <li>Use the HttpContext.Current.Items to store the request session. This, coupled with a few lines of code in Global.asax.cs, can easily provide me with a session on the request level. However, it means that dependencies will be injected between NHibernate and my views (HttpContext).</li> </ul> <p>Thank you very much!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsduplooy
    1. USGuillaume Gervais
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow can I implement a robust session-per-request pattern in my project, while focusing on information hiding?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow can I implement a robust session-per-request pattern in my project, while focusing on information hiding?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow can I implement a robust session-per-request pattern in my project, while focusing on information hiding?
      1. USJoe Phillips
      1. VTFavorite
    1. CO"dependencies will be injected between NHibernate and my views" -> it's not quite clear what you mean with this, can you explain further?
      singulars
      1. POHow can I implement a robust session-per-request pattern in my project, while focusing on information hiding?
      1. USMauricio Scheffer
    2. COIf I use HttpContext to store an NHibernate session, the View aspect of my MVC application will be coupled with the data access aspect (NHibernate session).
      singulars
      1. POHow can I implement a robust session-per-request pattern in my project, while focusing on information hiding?
      1. USGuillaume Gervais
    3. CO@ggervais: that only happens if you use lazy-loading in your views, which you shouldn't.
      singulars
      1. POHow can I implement a robust session-per-request pattern in my project, while focusing on information hiding?
      1. USMauricio Scheffer
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload