0

I have one windows service application and one ASP.NET web application, both created by C#. Both applications get data from the database(SQL server).

Once I update database from web application, how could I inform service application to reload data from database?

Right now our solution is to use service controller to restart windows service application. Is there any low cost solution, like communication between service application and web application?

By the way, my boss hate polling method...

Thanks a lot!

1

1 Answer 1

2

You could use a table like a queue between the web page and the service.

When the page modify some data will flag new record in the table, the service will review that table each X seconds, if find a new record, will change the state and run any process you want.

Hope this help.

Sign up to request clarification or add additional context in comments.

4 Comments

The right word would be "queue". But the rest of the text here stands.
That's the idea, a queue. Thanks Chris.
Yep. Polling a table queue works real well. Very cheap/easy to implement and very reliable. The only downside is that I really really dislike polling.. :)
Thank you very much, I think it's indeed a good solution. But I'm afraid my boss might be dislike polling...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.