getting the changes alone using MysqlDependency change event handler
getting the changes alone using MysqlDependency change event handler
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
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: getting the changes alone using MysqlDependency change event handler
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
Thanks for the reply, Is there is any other way to get the changed records alone
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: getting the changes alone using MysqlDependency change event handler
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.