SQLNOTIFICATIONS SQLDEPENDENCY SUPPORT

[Murali Karlapudi]

Hello Telerik,

         Is there any support for SQLDEPENDANCY IN TELERIK OPEN ACCESS ORM

[Thomas]

Hello Murali,

no, at the moment there is no support for SqlNotifications and SqlDependency. What is you use case, can it be solved differently?

Best wishes,
Thomas
the Telerik team

[Murali Karlapudi]

Hi,

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.

Thanks
Murali

 

[Thomas]

Hello Murali,

hmm, I guess the problem is that the setting of the respective SqlCommand with the dependency would be needed on all tables that should be monitored. You can iterate over all the tables most easily with an enumerator on the MetadataContainer. You can then issue a command on the table that does not much but registers a dependency so that notifications happen every time the content is changed. For that to work you will need another connection, which you currently cannot obtain from OpenAccess; so this must be done from the outside.

We will think a bit more on that to find a better answer for this in one of our next versions.

Regards,
Thomas
the Telerik team

[Patrice Boissonneault]

I have the exact same need.

+1 vote for SqlDependency support.

[Nathan]

been a while...any movement on this?

[Thomas]

No changes in this direction up to now. It requires a new API and demand for such a feature was just not big enough. It would also work only with MSSQL.

Regards,
Thomas
Telerik

 

[MDS]

Dears, 

 If there are some changes for supporting of SQLDependency ? 

I want to get it works with the sample of SignalR at following link : 

http://www.telerik.com/support/code-library/binding-to-signalr

 Best regards,

Dmitriy 

[Viktor Zhivkov]

Hi Dmitriy,

We have not planned or executed any development to introduce support for this Microsoft SQL Server feature in Telerik Data Access. I am afraid that in near future we will not have capacity to include it in our pipeline.
If this feature is important for your project, please consider different ORM that has the required capability.

Regards,
Viktor Zhivkov
Telerik