Database Monitoring

Database Monitoring

Postby ronak.patel » Mon 30 Jul 2012 22:10

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?
ronak.patel
 
Posts: 2
Joined: Mon 30 Jul 2012 21:58

Re: Database Monitoring

Postby Pinturiccio » Wed 01 Aug 2012 13:10

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/sqlserver/docs/?Samples.html

MySqlDependency, OracleDependency, SqlDependency classes are available in the corresponding providers. Unfortunately, this functionality is not available in dotConnect Universal.
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44

Re: Database Monitoring

Postby ronak.patel » Wed 01 Aug 2012 14:51

Hi Pinturiccio,

Thanks for your reply.
ronak.patel
 
Posts: 2
Joined: Mon 30 Jul 2012 21:58


Return to dotConnect Universal