Hi,
I'm currently working on a project with OraDirect.NET and Entity Framework.
The problem that I have is that I can't see how exactly looks PL-SQL code that goes to the DB. It's very painful, especially when there is some exception during execution of this SQL on DB.
My question is:
Is there a way in OraDirect.NET to log queries that go to the DB, so that they can be viewed later?
Query logging?
Recently I was wondering the same question and it took me a while to figure it out. Man, we need better document Here is one way to do it:
1) refer to the following 2 assembly:
CoreLab.Data
CoreLab.Oracle
(which can be found at C:\Program Files\Devart\OraDirect.NET2\ if you installed the drivers in the default location).
2) create a monitoring objecct before you create the object context object:
CoreLab.Oracle.OracleMonitor oracleMonitor1 = new CoreLab.Oracle.OracleMonitor();
oracleMonitor1.IsActive = true;
3) Run the DBMonitor before you run your program.
That's it. You will catch all sql texts sent to the Oracle database.
1) refer to the following 2 assembly:
CoreLab.Data
CoreLab.Oracle
(which can be found at C:\Program Files\Devart\OraDirect.NET2\ if you installed the drivers in the default location).
2) create a monitoring objecct before you create the object context object:
CoreLab.Oracle.OracleMonitor oracleMonitor1 = new CoreLab.Oracle.OracleMonitor();
oracleMonitor1.IsActive = true;
3) Run the DBMonitor before you run your program.
That's it. You will catch all sql texts sent to the Oracle database.