SQLNOTIFICATIONS SQLDEPENDENCY SUPPORT

9 posts, 0 answers
  1. Murali Karlapudi
    Murali Karlapudi avatar
    7 posts
    Member since:
    Jun 2009

    Posted 17 Mar 2011 Link to this post

    Hello Telerik,

             Is there any support for SQLDEPENDANCY IN TELERIK OPEN ACCESS ORM
  2. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 18 Mar 2011 Link to this post

    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
  3. DevCraft banner
  4. Murali Karlapudi
    Murali Karlapudi avatar
    7 posts
    Member since:
    Jun 2009

    Posted 21 Mar 2011 Link to this post

    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

     
  5. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 23 Mar 2011 Link to this post

    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
  6. Patrice Boissonneault
    Patrice Boissonneault avatar
    18 posts
    Member since:
    Mar 2010

    Posted 31 Mar 2011 Link to this post

    I have the exact same need.

    +1 vote for SqlDependency support.
  7. Nathan
    Nathan avatar
    7 posts
    Member since:
    Jan 2015

    Posted 24 Sep 2015 Link to this post

    been a while...any movement on this?
  8. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 25 Sep 2015 Link to this post

    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.
  9. MDS
    MDS avatar
    5 posts
    Member since:
    Jan 2014

    Posted 15 Jan Link to this post

    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 

  10. Viktor Zhivkov
    Admin
    Viktor Zhivkov avatar
    291 posts

    Posted 21 Jan Link to this post

    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.
Back to Top
DevCraft banner