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

    Forum Stats

  • 3,708,688 Users
  • 2,241,109 Discussions
  • 7,840,539 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

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.

Answers

  • 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.