Guys,

I have a web application where the user is going to save a query template. Then I need to take this query template and run a SQL query in the backend which can some times take may be 1 hour or so.

The way I think is there will be a windows service which will take this query template and run the query in backend and then write a Excel output file in a folder.

So when the user submits a query request I need to start this windows service.

Can this be done using .NET Remoting or I need to do this in a different way ?

Any ideas are welcome here ?

Thanks

Pr.

If you already have a Windows service that is ready to deal with this, you certainly could connect to it with remoting.

You could solve this problem by simply spinning up another thread from the web page. The processing can be done within the web application (i.e. the asp.net worker process "aspnet_wp.exe"). Just prepare and start a new thread to handle the process and let your page return to the user with the appropriate notification that the request started. This eliminates the need to create a service app and communicate with remoting, etc.

-Peter
compiledthoughts.com

The windows service is not there yet. If I implement a new thread what happens if the user closes the page ? will it still run in the background ?
The reason for the windows service is the query which it runs is going to take a long time to run in some cases may be an hour. Once I get the results, I need to write to an excel file and send an email back to the user that the output is ready.

Can all this be done using your method or Windows service is the right way to go about doing this ?

Also is there any way you can give me any examples. That will me a lot.

Thanks

Pr

The thread that processes your page request lives inside the asp.net worker process, so would the thread that you spawn off to run this background process. The user could close the page, their browser and turn off their computer and the thread you spawn off will still be running.

Look for some examples involving the Thread and ThreadStart class and you should find what you need. There are lots of examples online about launching threads.

-Peter
compiledthoughts.com