Trace Oracle commands

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Dominik
Posts: 29
Joined: Wed 19 May 2010 07:26

Trace Oracle commands

Post by Dominik » Thu 08 Jul 2010 07:47

Hi,

Is there a trace provider for Oracle like EFTracingProvider (http://code.msdn.microsoft.com/EFProviderWrappers) is for SQL commands?

Does OracleTrace class perform something like this?

If it is, where can I find some information about how to use it?

Thanks in advance,

Dominik.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 09 Jul 2010 13:13

No, OracleTrace is not intended for Entity Framework SQL monitoring.
We have a special component for tracing - Devart DbMonitor.
You can download this component here
Description of the DbMonitor usage is available here.

Dominik
Posts: 29
Joined: Wed 19 May 2010 07:26

Post by Dominik » Fri 09 Jul 2010 13:28

Ok,

But I would like to perform tracing of SQL commands generated by devart Oracle provider from my application for deployment purposes.

May I assume then, that it cannot be possible?

Thanks,

Dominik.

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 09 Jul 2010 14:11

Here is a simple code sample:

Code: Select all

...
OracleMonitor mon = new OracleMonitor;
mon.IsActive = true;
mon.TraceEvent += Devart.Common.MonitorEventHandler(mon_TraceEvent);
...
void mon_TraceEvent (object sender, Devart.Common.MonitorEventArgs e) {
      if (e.EventType == Devart.Common.MonitorEventType.Execute) {
        //add here your tracing code
      }
    }
In this case you don't need to use an external appilcation.

Post Reply