My use case / real time scenario : I have WCF Service that provides real time updates to sliverlight clients (Dashboard) who registers for this service. I want to write the WCF service in such away - if there is an insert in the database the WCF Service need to be notified using Notification services (provided by SQLSERVER/ ORACLE 11G) and in return the WCF will update client views (ex- telerik silverlight chart).
At the moment there is a timer running - every 30 seconds to check for an update. we want to automate instead of using timer. we can do this using SQLDEPENDENCY Class provided by System.Data.SqlClient
. But we are using Telerik ORM FOR data plumbing and want to benifit from all the features.