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 ?