Session State

Storing Session State for an ASP.NET Site in a SQL Server Database

by
ASP.NET and related technologies

When using session state in an ASP.NET Web application, you have several options. If you want to store it in your application database, as opposed to the ASPstate database (created at the command line with “aspnet_regsql -S [server] -E -ssadd -sstype c -d ASPstate”), I have scripted the database objects and stored them in GitHub … Read more

Dynamically Setting the Connection String for Session State on SQL Server

by
SQL Server logo

In ASP.NET, there are four ways to store Session State.  The way I prefer to store it is using SQL Server.  However, instead of storing it in the ASPstate database, which is the default way to store it on SQL Server, I choose to store it in the application database, which is a “custom SQL … Read more