PostgreSQL notify

[Maciej]

Hello,

I'm using OpenAccess with postgresql database. In database I've triggers to send notify when data has been changed by my server side application. Please tell me how I can listen to this notification in my windows form application. Npgsql have dedicated event to catch notifies from server, but I don't know, how I can make this with OpenAccess. I need real-time data monitoring.

Regards,
Maciek

[Ralph Waldenmaier]

Hi Maciej,

Thank you for your question but unfortunately Telerik OpenAccess ORM does not support this PostgreSql feature.

Feel free to ask if you have any other question.

Greetings,
Ralph
the Telerik team

[Maciej]

Hi Ralph,

Thank you for the replay.
Maybe can you provide me other solution than postgre trigger to trace data changes in my database in real-time?

Regards,
Maciek

[Thomas]

Hello Maciek,

I guess the best option you have is to open another ADO connection in parallel to the connections OpenAccess uses and add your event notifications there. Because this is a Postgres specific feature we have no built-in support for this yet. This would catch all modifications in the database, including those made by other tools to the same data.
If you just need the modifications made by the local OpenAccess application, you should have a look into the IInstanceCallback interface and the IContextEvents interface.

Regards,
Thomas
the Telerik team