Devart.Data.Linq.Monitoring - Logging the SQL Parameters

Devart.Data.Linq.Monitoring - Logging the SQL Parameters

Postby kboeckm » Tue 18 Oct 2011 15:01

I've set up an event handler in the OnCreated event of my datacontext. The event handler looks like this:

Code: Select all
        static void OnEvent(object sender, MonitorEventArgs e)
            if (e.TracePoint == MonitorTracePoint.BeforeEvent && (e.EventType == MonitorEventType.Execute || e.EventType == MonitorEventType.Error))
                Common.Log.Verbose(string.Format("Description: " + e.Description));
                Common.Log.Verbose(string.Format("Extra info: " + e.ExtraInfo));

That works fine to log the sql statement. However, I can't figure out how to log the input/output parameters. The dbMonitor tool is able to log the parameters so I'm guessing there is a way to do it. Has anybody figure out how to do this?
Posts: 10
Joined: Tue 14 Jun 2011 20:47

Postby StanislavK » Wed 19 Oct 2011 11:40

At the moment, the MonitorEventArgs class stores no information about the parameters passed to the SQL command being executed.

However, we plan to support tracking SQL parameters via the DbMonitor component events. We will post here when this support is implemented.
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Re: Devart.Data.Linq.Monitoring - Logging the SQL Parameters

Postby Goransi » Thu 23 Jan 2014 22:50

Any progress on this issue? I would require this functionality for our application.
Posts: 10
Joined: Thu 23 Jan 2014 22:48

Re: Devart.Data.Linq.Monitoring - Logging the SQL Parameters

Postby MariiaI » Fri 24 Jan 2014 14:04

This functionality has not been implemented yet and we can't tell any timeframe at the moment. We will inform you about the results as soon as any are available.
Please post your suggestion at our UserVoice so that other users can vote for it.

JIC: you could check the generated SQL scripts with the parameters via DbMonitor:
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Return to LinqConnect (LINQ to SQL support)