Lazy loading of session variables in SQL Server SQL Server mode

Question

I would like to know if the ASP.NET session provider in SQL mode will optimally receive the entire session state object (i.e. all keys and their values ​​when we request it) or get them in a lazy way (i.e. databases and fetching only the requested key and the corresponding value)?

Answer 1

I set the SQL SQL state for SQL as follows:

aspnet_regsql.exe -sstype c -ssadd -d mydatabase -U MyUserName -P MyPassword -S xx.xx.xx.xxx

The following is one of the “selected” stored procedures that are installed. I tried to figure it out.

, . , .

, , , ASP.net- (, Session() ).

, , :