I have a EF Core + Blazor client/server application where a table in an sql database may be updated by an external service. The server keeps a copy of that table and should react to changes to the original table (the application needs a copy for reasons). The external service may add, delete or modify records or even write the entire table from scratch, dropping the old table in the process.
Is there a way to have the server be notified whenever that external table is changed, similar to a DB trigger? Or is there a way to have a DB trigger notify the server so that I can process the notification in code in the server?
