ASP.Net Session Storage provider in 3-layer architecture

3
votes

I'm implementing a custom session storage provider in ASP.Net. We have a strict 3-layer architecture and therefore the session storage needs to go through the business layer. Presentation->Business->Database. The business layer is accessed through WPF. The database is MSSQL.

What I need is (in order of preference):

  1. A commercial/free/open source product that solves this.
  2. The source code of a SqlSessionStateStore (custom session store) (not the ODBC-sample on MSDN) that I can modify to use a middle layer.

I've tried looking at .Net source through Reflector, but the code is not usable.

Note: I understand how to do this. I am looking for working samples, preferably that has been proven to work fine under heavy load. The ODBC sample on MSDN doesn't use the (new?) stored procs that the build in SqlSessionStateStore uses - I'd like to use these if possible (decreases traffic).

Edit1: To answer Simons question on more info: ASP.Net Session()-object can be stored in either InProc, ASP.Net State Service or SQL-server. In a secure 3-layer model the presentation layer (web server) does not have direct/physical access to the database layer (SQL-server). And even without the physical limitations, from an architectural standpoint you may not want this. InProc and ASP.Net State Service does not support load balancing and doesn't have fault tolerance. Therefore the only option is to access SQL through webservice middle layer (business layer).

1
asp.netsqlsession
Can you explain a bit more why the ASP.NET standard does not fit your need so we can answer? What's the relation between the Presentation layer and the ASP.NET session storage, for example? – Simon Mourier

1 Answers

2
votes

Since no good answer has been provided...

One solution is to not use SQL as storage, but instead use AppFabric.

http://msdn.microsoft.com/en-us/library/ee790859.aspx

Ref. Distributed ASP.Net State Service