Outlets, survey, results without outlets?

Question

I am developing a Windows Form application that runs on a SQL cloud service hosted by Microsoft Azure Development Services. Without the ability to physically have a recipient application that would allow me to use sockets, this is a significant mistake, since my application will rely heavily on a dedicated database, so I would prefer to be able to constantly check the database for changes and alert the current user to based on row entries that match the criteria.

I read on several blogs / posts that polling (was a possible solution) is a bad thing to dispose of. So what will be the review approach?

Answer 1

To clarify the problem, you want clients to receive updates when certain data in the database changes.

SQL Server 2005 and 2008 support the concept of client notification when data changes ( MSDN ). However, this SO Question seems to indicate that this feature is currently not available in SQL Clout. This means that you have several options:

• Poll the database itself

  • , , . , , , ( ) . - . , /.

• • , push (, WebSockets). , , , , . , , . ( ).

, . , , , .