Log actual SQL statement through DataContext

Question

0.00/5 (No votes)

See more:

Hi All

I'm busy working on a relatively big application that is using a DataContext to query data from the database. We currently have central error handling and logging but the problem is that if there is a sql exception, it doesn't log the actual SQL query.

Is there any easy way of implementing this centrally without logging it at each instance we use the DataContext?

We have a class that inherits from DataContext that we use. It would be ideal to catch the SQL statements as they pass through this class to the actual DataContext but it's a bit difficult with Linq as there is no string SQL command.

Any suggestions would be greatly appreciated.

Posted 1-Dec-11 22:12pm

HighOnFireZA

Add a Solution

2 solutions

Solution 2

Hi,

another solution is , if you have installed SQL server then there is SQLProfiler available for checking sql query fired on databases.

SQLProfiler can be helpful to you.

thanks
-amit.

Posted 1-Dec-11 22:41pm

AmitGajjar

Comments

HighOnFireZA 2-Dec-11 5:37am

Thanks for the suggestion but profiler won't be applicable in this scenario.

AmitGajjar 2-Dec-11 22:21pm

Yes my mistake, you need datacontext.log to log all the sql query.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Accepted Answer · 2011-12-01T22:35:00

In your class that inherits from DataContext, during initialisation can you not just set the context Log property to a logging provider of your choice?

http://msdn.microsoft.com/en-us/library/system.data.linq.datacontext.log.aspx[^]

This article shows using with log4Net

Redirect LINQ to SQL DataContext Log Messages To Log4Net[^]

The nice thing about log4Net is that it's easily configurable, you could switch on\off SQL logging with a simple config change & you can redirect the output to numerous destinations (text file, email, SQL database etc)