Page 1 of 1

getting the changes alone using MysqlDependency change event handler

Posted: Fri 30 Mar 2018 07:22
by siva
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

Re: getting the changes alone using MysqlDependency change event handler

Posted: Mon 02 Apr 2018 12:48
by Pinturiccio
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.

Re: getting the changes alone using MysqlDependency change event handler

Posted: Thu 03 May 2018 05:38
by siva
Thanks for the reply, Is there is any other way to get the changed records alone

Re: getting the changes alone using MysqlDependency change event handler

Posted: Thu 03 May 2018 12:30
by Pinturiccio
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.