Search code examples
c#oracle-databasenotificationsdata-access-layerchange-notification

How to send data when using Oracle Change notification from Data Access layer to Application layer


Hi I am planning to use oracle change notification feature in C# using OracleDependency class. Whenever there is change in the data, we get the notifications from database that there is a change in the data access layer. So we can connect to DB and get the new data, but how can we send this new data back to the application(console app)?


Solution

  • I am passing a delegate function as a parameter to data access and whenver database sends notification, the event is passed to the delegate function.