Is it possible to implement SQL Session State with ASP.NET MVC without the addition of code to our webapp? We need this to be a transparent switch from In-proc to SQLServer.
+1
A:
No code is required in your application to switch from in process to SQL session state. This is controlled from with your applications web.config file. The one thing you will have to do is run the necessary scripts to create the ASP.NET Session database and tables. See this Microsoft support article for more details. This is the same for web forms as well as MVC.
Andy Rose
2010-10-05 15:52:07
I ran the scripts in SQL Management Studio but I don't have the Query Analyzer. After I ran InstallPersistSqlState.SQL I configured IIS and was unable to get any sessions in the temp table unless I programmatically assigned a value to some session variable.
alan
2010-10-05 16:09:11