MarnickTelenet
Programmer
We have a Windows .NET application that is running on a Citrix-server.
The application uses stored-procedures on a SQL-server.
We want to stop using stored-procedures because we want to centralise all the logic (insert/update/delete) in a business-framework written in .NET.
This means that the logic moves from the SQL-stored-procedures to DLL's (written in VB.NET).
We see one big disadvantage of this step.
Stored-procedures: we can live-update them (= while a lot of users were using the app on Citrix). Because of that, a lot of logic-updates could be done without the users knew it and without stopping the users using the app.
I'm almost sure we will not be able to live-update the DLL's. A "logic-DLL" will only be updateble after the last user has stopped using the app.
That means: if you move logic from stored-procedure to DLL, you get an update-disadvantage. For every update, even the smallest one, it wil be necessary that all users leave the application so that the DLL's become free for replacing them with a never version.
Is there a solution for this problem??? Is there a way to live-update DLL's on a Citrix-server??? (Same question on a standard terminal server)
The application uses stored-procedures on a SQL-server.
We want to stop using stored-procedures because we want to centralise all the logic (insert/update/delete) in a business-framework written in .NET.
This means that the logic moves from the SQL-stored-procedures to DLL's (written in VB.NET).
We see one big disadvantage of this step.
Stored-procedures: we can live-update them (= while a lot of users were using the app on Citrix). Because of that, a lot of logic-updates could be done without the users knew it and without stopping the users using the app.
I'm almost sure we will not be able to live-update the DLL's. A "logic-DLL" will only be updateble after the last user has stopped using the app.
That means: if you move logic from stored-procedure to DLL, you get an update-disadvantage. For every update, even the smallest one, it wil be necessary that all users leave the application so that the DLL's become free for replacing them with a never version.
Is there a solution for this problem??? Is there a way to live-update DLL's on a Citrix-server??? (Same question on a standard terminal server)