getting the changes alone using MysqlDependency change event handler

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
siva
Posts: 2
Joined: Fri 30 Mar 2018 07:16

getting the changes alone using MysqlDependency change event handler

Post by siva » Fri 30 Mar 2018 07:22

I am using mysqldependency class in C#, where i need to get only the changed rows, Currently i am getting all the row from the table. Is there is a way to get only the changed rows alone

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: getting the changes alone using MysqlDependency change event handler

Post by Pinturiccio » Mon 02 Apr 2018 12:48

MySqlDependency does not get changed records and is not designed for that. MySqlDependency only notifies you if some changes were made in a table, but it does not return changed records.

siva
Posts: 2
Joined: Fri 30 Mar 2018 07:16

Re: getting the changes alone using MysqlDependency change event handler

Post by siva » Thu 03 May 2018 05:38

Thanks for the reply, Is there is any other way to get the changed records alone

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: getting the changes alone using MysqlDependency change event handler

Post by Pinturiccio » Thu 03 May 2018 12:30

dotConnect for MySQL does not have a feature to get changed records. MySqlDependency can show that a table is changed. MySqlDependency can also show which changes are made: insert, update, or delete. But it cannot return changed records, and you have to implement your own logic for this.

Post Reply