I am using a specialized session storage provider in ASP.Net . We have a strict three-layer architecture , so session storage must go through the business layer . Presentation-> Business-> Database. Access to the business layer is through WPF. Database - MSSQL.
What I need (in order of preference):
- A commercial / free / open source product that solves this.
- The source code for the SqlSessionStateStore (custom session store) (and not the ODBC sample on MSDN), which I can change to use a mid-tier.
I tried looking at the .Net source through Reflector, but the code is not used.
Note. I understand how to do this. I am looking for working samples, it is desirable that it has been proven that it works perfectly under heavy load. The MSDN ODBC sample does not use (new?) The stored processes that the assembly uses in SqlSessionStateStore - I would like to use them if possible (reduces traffic).
Edit1: To answer Simons' question about additional information: ASP.Net Session () - the object can be stored in InProc, State State Service or SQL-server. In a secure three-layer model, the presentation layer (web server) does not have direct / physical access to the database layer (SQL server). And even without physical limitations, from an architectural point of view, you cannot want this. InProc and the ASP.Net government service do not support load balancing and do not have fault tolerance. Therefore, the only option is to access SQL through the middle tier of the webservice (business tier).
source
share