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

    Forum Stats

  • 3,715,753 Users
  • 2,242,856 Discussions
  • 7,845,557 Comments

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

4221609
4221609 Member 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.

Answers

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,752 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.