Click here to Skip to main content
15,867,453 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hello,

I have developed on web application in ASP.NET C#, SQL Server 2008 R2. In which for better performance i have used AppState for storing Admin Look Up Data. It works fine in Non Replicated.
Here i use

HttpContext.Current.Application["Table1"] to store data App Level.
And when any occur in Admin Look Up i re fill data in this Application State.

It works.

Now i want to use my application with Data Replication.
To accomplish i have same separate database on different SQL Server.

And same application on different Port/App Server.

First application is User First Database from First SQL Server
Second application is User Second Database from Second SQL Server


Now when i change admin data from first Application URL. i got latest data in application state in first Application.

But My question is how can i get same data in Second Application.

My Database replication is works fine.

How can i update application state of second application.

Please advice me. Just advice which technique i can use to accomplish.

Thanks
Posted

1 solution

I will recommend you to use an SQL based session state handling and then store it there, It works straight off the bat and you can store any serializable object that way which should facilitate your use scenario.
Other solutions are very likely to cost you more work would be my immediate guess.
http://support.microsoft.com/kb/317604[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900