I'm using ASP.NET, with session state stored out of process in SQL Server. When a page request begins, are the entire contents of a user's session retrieved from the DB, deserialized, and sent to the ASP.NET process in one fell swoop, or are individual objects transferred to the ASP.NET process only as needed? Basically, I have a page t...
So I set up SQL Server Session State using SQL Server 2008 and the temp database and today I decided to look into the data in the tables only to find this in the ASPStateTempApplications table: AppId AppName 538231025 /lm/w3svc/1/root 611758131 /lm/w3svc/3/root 802488340 /lm/w3svc/4/root -940085065 /lm/w3svc/4/root/webapp 68...
Isn't SQL Server sessioning for an ASP.NET MVC application fundamentally the same as ASP.NET? If so, do you guys traditionally impersonate your front end user for the sessioning database or setup a static SQL Server user? Just trying to setup our permissions for our MVC app. Thanks! ...
Is it better for a collection of ASP.NET web apps to share the same session database, or should each one have its own? If there is no significant difference, having a single database would be preferable due to easier maintenance. Background My team has an assortment of ASP.NET web apps, all written in either Monorail 1.1 or ASP.NET MV...
I have created new session database using the command (aspnet_regsql.exe -S -E -ssadd -sstype p) and it created DB called ASPState. Then I renamed it to something like E_ASPStateDB. I have configured the correct DB name in the sessionState connection string. But still it throws the exception Invalid object name 'ASPState.dbo.ASPStateTe...
I'm trying to set up an ASP.NET app to use SQL backed sessions. When I run the following code Session["test"] = 1; a row is inserted into the ASPStateTempSessions table in session database, which makes me thing that it is all set up fine. But when a user logs in, no entry is made in that table. It should be, right? If not, where i...