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.