EF Core, SignalR and Database Change Notifications — oracle-tech

    Forum Stats

  • 3,708,688 Users
  • 2,241,109 Discussions


Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

EF Core, SignalR and Database Change Notifications

42216094221609 Posts: 1
edited July 2020 in ODP.NET

Is this possible?  I haven't been able to find documentation on how to get this to work.  We're wanting to use SignalR within our application.


  • Alex Keh-OracleAlex Keh-Oracle Posts: 2,720 Employee
    edited July 2020

    I can't think of a way to use EF Core and DB Change Notification directly together easily. EF Core uses generic ADO.NET APIs. It can't access ODP.NET-specific APIs. DB Change Notification is specific to ODP.NET.

    You could execute a query with EF Core. Then, capture the SQL executed and re-execute it with ODP.NET so that it can be registered with DB Change Notification. You don't need to actually retrieve the results in the re-execution. When a change occurs, the event handler will have EF Core query again to retrieve the new data..

Sign In or Register to comment.