MVC3 - SQL Server Session State

[Scott]

Per the MVC example given for best practices for OpenAccess, we are implementing the ContextModule, and thus upon each request, creating the database context and storing it in the Session State.

Is it possible to store OpenAccess context objects in the SQL Server Session State, and if so, how do we accomplish this?

[Damyan Bogoev]

Hi Scott,

Storing the OpenAccessContext instance in the session state could lead to wrong behavior if there are multiple requests to a page or custom handlers which are using the same session. This could lead to a situation when one request disposes the context before other request are finished doing their work, which will cause an exception. Problems could arise when the application is being used in a web farm.

Better approach is to store the context in the HttpContext.Items collection. You could find the sample application, shipped with the Product SDK, helpful. They demonstrate how to handle the context.

Hope that helps.

Kind regards,
Damyan Bogoev
the Telerik team

[Scott]

Using the HttpContext.Items collection worked much better, thanks!