I have a requirement for a software project where I need to read ASP.net session information from one SQL Server instance and I need to write it to another SQL Server instance during one full page process. I need to dynamically reroute a user to a different
data store. I am using a partition resolver to determine where to read the session from, I do not know how to get ASP.net to write it to a different connection. Any help is greatly appreciated.
As far my knowledge, there i no builtin ASP.NET function/feature to achieve it!
You need to develop a custom logic to do that! What you can do is, have two connection string pointing to two different SQL Server instances and then read the session information from one session to the other!
peters71
0 Points
1 Post
Move Session information
May 08, 2012 04:27 PM|LINK
I have a requirement for a software project where I need to read ASP.net session information from one SQL Server instance and I need to write it to another SQL Server instance during one full page process. I need to dynamically reroute a user to a different data store. I am using a partition resolver to determine where to read the session from, I do not know how to get ASP.net to write it to a different connection. Any help is greatly appreciated.
Thanks in advance.
roopeshreddy
All-Star
20155 Points
3328 Posts
Re: Move Session information
May 09, 2012 07:47 AM|LINK
Hi,
As far my knowledge, there i no builtin ASP.NET function/feature to achieve it!
You need to develop a custom logic to do that! What you can do is, have two connection string pointing to two different SQL Server instances and then read the session information from one session to the other!
Hope it helps u...
Roopesh Reddy C
Roopesh's Space