This is a migrated thread and some comments may be shown as answers.

SQLNOTIFICATIONS SQLDEPENDENCY SUPPORT

8 Answers 57 Views
Feature Requests
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Murali Karlapudi
Top achievements
Rank 2
Murali Karlapudi asked on 17 Mar 2011, 11:58 AM
Hello Telerik,

         Is there any support for SQLDEPENDANCY IN TELERIK OPEN ACCESS ORM

8 Answers, 1 is accepted

Sort by
0
Thomas
Telerik team
answered on 18 Mar 2011, 09:38 AM
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
0
Murali Karlapudi
Top achievements
Rank 2
answered on 21 Mar 2011, 02:52 PM
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

 
0
Thomas
Telerik team
answered on 23 Mar 2011, 08:56 PM
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
0
Patrice Boissonneault
Top achievements
Rank 2
answered on 31 Mar 2011, 05:57 PM
I have the exact same need.

+1 vote for SqlDependency support.
0
Nathan
Top achievements
Rank 1
answered on 24 Sep 2015, 08:29 PM
been a while...any movement on this?
0
Thomas
Telerik team
answered on 25 Sep 2015, 09:40 AM
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
 
Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
0
MDS
Top achievements
Rank 1
answered on 15 Jan 2016, 03:28 PM

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 

0
Viktor Zhivkov
Telerik team
answered on 21 Jan 2016, 03:37 PM
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
 
Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
Tags
Feature Requests
Asked by
Murali Karlapudi
Top achievements
Rank 2
Answers by
Thomas
Telerik team
Murali Karlapudi
Top achievements
Rank 2
Patrice Boissonneault
Top achievements
Rank 2
Nathan
Top achievements
Rank 1
MDS
Top achievements
Rank 1
Viktor Zhivkov
Telerik team
Share this question
or