This question is locked. New answers and comments are not allowed.
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
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
3 Answers, 1 is accepted
0
Hi Maciej,
Ralph
the Telerik team
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.
Ralph
the Telerik team
OpenAccess ORM Q2'12 Now Available! Get your hands on all the new stuff.
0
Maciej
Top achievements
Rank 1
Rank 1
answered on 11 Aug 2012, 10:50 PM
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
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
0
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
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
Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!