Is there any way to in .NET to see what LINQ query against database we are firing? For eg. I am wring a query in LINQ and I want to see that what SQL query is firing to communicate with database.
Is there any Visual Studio window or any other way?
-
Which RDBMS do you use?Giorgi Nakeuri– Giorgi Nakeuri2015-03-30 11:32:29 +00:00Commented Mar 30, 2015 at 11:32
-
1SQL Profiler, if you are using MSSQL. youtube.com/watch?v=mJ8Dyv4Uk6ENick– Nick2015-03-30 11:33:05 +00:00Commented Mar 30, 2015 at 11:33
-
I am using SQL RDBMSParveen– Parveen2015-03-30 11:33:08 +00:00Commented Mar 30, 2015 at 11:33
-
SQL RDBMS? Is this Microsoft, Oracle, MySQL, Postgre or...?Giorgi Nakeuri– Giorgi Nakeuri2015-03-30 11:34:04 +00:00Commented Mar 30, 2015 at 11:34
-
MSSQL, this is MicrosoftParveen– Parveen2015-03-30 11:38:29 +00:00Commented Mar 30, 2015 at 11:38
|
Show 5 more comments
5 Answers
Are you looking for something like this
var context = new MyContext();
context.Database.Log = s => Debug.WriteLine(s);
Then whenever a query is executed, you'll see an output like :
var customers = context.Customers.ToList();
Opened connection at 30-3-2015 13:48:03 +02:00
SELECT [Extent1].[Guid] AS [Guid],
[Extent1].[FirstName] AS [FirstName],
[Extent1].[LastName] AS [LastName],
[Extent1].[Email] AS [Email],
[Extent1].[Created] AS [Created]
FROM [dbo].[Customer] AS [Extent1]-- Executing at 30-3-2015 13:48:03 +02:00
-- Completed in 0 ms with result: SqlDataReader
Closed connection at 30-3-2015 13:48:03 +02:00
5 Comments
Maarten
And this works regardless what type of database is used.
Parveen
Where I have to write this line, in particular class or in every class where want to check?
Peter Szekeli
@Parveen You'll need to attach it to every context you instantiate. All the queries executed by that context will be logged. I added the context declaration line to the answer. Hope this helps
Parveen
and where need to check the output in Console or Output Window?
Peter Szekeli
@Parveen yes, the result is written into the Output window, from the "Show output from" list, select Debug.
If you have a DbContext on which you firing your LINQ queries you can simply set the DbContext.Database.Log property to something like this:
yourContext.Database.Log = (msg => System.Diagnostics.Debug.Write(msg, "SQL"));
After this, every SQL query shows up in the Debug console from your Visual Studio with the category SQL.
1 Comment
Maarten
And this works regardless what type of database is used.
You can use SQL Profiler to see how the LINQ expression is translated into SQL statement.
Comments
You can use the Log property of DataContext object. Also, it depends on the type of application you are using.
For Web Application:-
db.Log = Response.Output;
For Console Application:-
db.Log = Console.Out;
Apart from this you can also use the GetCommand method of DataContext class. Sql Server Profiler is again an obvious option.
Comments
You can also use SQL Server Profiler, Trace or Extended Events. First two are deprecated.
https://technet.microsoft.com/en-us/library/bb630354(v=sql.105).aspx
https://msdn.microsoft.com/en-us/library/ms181091.aspx
https://technet.microsoft.com/en-us/library/ms191006(v=sql.105).aspx
1 Comment
Giorgi Nakeuri
The question was
or any other way. So this answer is quite legitimate. Hello downvoter...