Whats the best way to disconect your main application and all users in it from another app.

See more:

C#

ASP.NET

SQL

application

server

Hi,

I have 2 server based applications. One of them (lets call it X) can be accessed from a public network and the second one is for local network use only (this one will be called Y). I am trying to retrieve data in application X from the local application Y.

The problem is that i would like to create a button that will instantly disable the connection string between X and Y app because i have to execute a SQL procedure that will delete everything in my local app Y and that requires all locks to be dropped and all users must be logged off.

Is it better to create a web service to retrieve this data for me and would it be easier to disconnect the app Y that way?

or

Is it ok to simply disable the connection string within the app its self and log off all users?


Any suggestion or comments are welcome. If more information is required please feel free to ask.

Thank you.