Hi,
I am trying to create a WPF Application once started will monitor (MsSQL,MySQL,Oracle and DB2) databases for following events. When events are fired I want to show them in the Output log of my WPF application, with detains about which row is added, deleted or updated and same with Tables.
1)Row Added to specific Table
2)Row Deleted to specific Table
3)Row Updated to specific Table
4)Table Added
5)Specific Table Updated
6)Table Deleted
I have looked the API , and looks like for Oracle and MySQL , I would need to use
Devart.Data.MySql.MySqlDependency
Devart.Data.Oracle.OracleDependency
I am not able to locate SqlDependency class for MsSql and for DB2.
Is this the correct way to do it?
Database Monitoring
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Database Monitoring
There are the following classes:
1. Devart.Data.MySql.MySqlDependency
2. Devart.Data.Oracle.OracleDependency
3. Devart.Data.SqlServer.SqlDependency
Devart.Data.SqlServer.SqlDependency class exists but it is not described in our help file, we will add all the necessary information and notify you about the results as soon as possible.
There is a sample Dependency. This sample is located in the folder with dotConnect for SQL Server C:\Program Files (x86)\Devart\dotConnect\SQL Server\Samples or in 'Start Menu->All Programs->Devart dotConnect for SQL Server->Samples'
For more information, please refer to http://www.devart.com/dotconnect/sqlser ... mples.html
MySqlDependency, OracleDependency, SqlDependency classes are available in the corresponding providers. Unfortunately, this functionality is not available in dotConnect Universal.
1. Devart.Data.MySql.MySqlDependency
2. Devart.Data.Oracle.OracleDependency
3. Devart.Data.SqlServer.SqlDependency
Devart.Data.SqlServer.SqlDependency class exists but it is not described in our help file, we will add all the necessary information and notify you about the results as soon as possible.
There is a sample Dependency. This sample is located in the folder with dotConnect for SQL Server C:\Program Files (x86)\Devart\dotConnect\SQL Server\Samples or in 'Start Menu->All Programs->Devart dotConnect for SQL Server->Samples'
For more information, please refer to http://www.devart.com/dotconnect/sqlser ... mples.html
MySqlDependency, OracleDependency, SqlDependency classes are available in the corresponding providers. Unfortunately, this functionality is not available in dotConnect Universal.
-
- Posts: 2
- Joined: Mon 30 Jul 2012 21:58
Re: Database Monitoring
Hi Pinturiccio,
Thanks for your reply.
Thanks for your reply.