Way to view SQL executed by LINQ in Visual Studio?

Question

This question already has an answer here:
view sql that linq-to-sql produces 3 Answers

I'm wondering if there is a way to see the T-SQL that was executed against the database in Visual Studio 2010 Ultimate when a LINQ to SQL query runs.

Run SQL Sever profiler against that database and you can see what query is being executed. — Shyju, Jun 12 '12 at 18:27

score 24 · Accepted Answer · answered Jun 12 '12 at 18:28

24

If you have Visual Studio Ultimate, you can see every SQL query your application runs in the IntelliTrace window while debugging.

answered Jun 12 '12 at 18:28

SLaks

868,454
176
1,908
1,964

1

Keep in mind that IntelliTrace is very resource-consuming. I usually have it disabled. – Mr. TA Jun 12 '12 at 18:32
@Mr.TA: Isn't that only Calls View? – SLaks Jun 12 '12 at 18:34
Maybe - I just disable the whole thing, makes me feel better. :) – Mr. TA Jun 12 '12 at 18:35
Thanks! I needed a quick easy way to view the SQL and this worked. – l15a Jun 12 '12 at 19:34
2

I do see queries in that window, but when I click to get more information I get a window that says `--The data may be truncated and may not represent the query that was run on the server`. The warning is correct, since the query in that window only has the name of the stored procedure and none of the information that I would find useful for debugging. – Isaac Lyman Oct 11 '16 at 16:55
Its not available for Microsoft VS Professional 2015 – Sandeep May 26 '17 at 18:11

Mr. TA · Answer 2 · 2012-06-12T18:36:17.517

11

You can use SQL Server Profiler to do that.

edited Jun 12 '12 at 18:36

answered Jun 12 '12 at 18:26

Mr. TA

5,230
1
28
35

That's one method, but not the only. – jrummell Jun 12 '12 at 18:29
6

True, but then I doubt there is a single IT problem which has only one solution to it. – Mr. TA Jun 12 '12 at 18:32
Then categorically stating that you `have` to do one particular thing is probably a bit off the mark ;) – MatBailie Jun 12 '12 at 18:35
1

@Dems changed "have to" to "can" - no arm twisting here :) – Mr. TA Jun 12 '12 at 18:36

score 6 · Answer 3 · answered Jun 12 '12 at 18:29

6

You have basically two options:

1.) use a profiler, there's one free made by AnjLab http://anjlab.com/en/projects/opensource/sqlprofiler

2.) use LinqPad (again a free solution) http://www.linqpad.net/

You really don't need Ultimate VS or anything paid like some people already suggested...

answered Jun 12 '12 at 18:29

walther

13,466
5
41
67

1

AnjLab SQL profiler was bought out and is no longer free. – Talon May 25 '16 at 06:15

score 5 · Answer 4 · answered Jun 12 '12 at 18:29

5

You could use the Log property of the DataContext.

db.Log = Console.Out;
var custQuery =
    from cust in db.Customers
    where cust.City == "London"
    select cust;

foreach(Customer custObj in custQuery)
    Console.WriteLine(custObj.CustomerID);

answered Jun 12 '12 at 18:29

Andomar

232,371
49
380
404

1

Assuming the OP is using LINQ to SQL... – jrummell Jun 12 '12 at 18:30
@jrummell: Quoting the OP, "when a LINQ query runs" – Andomar Jun 12 '12 at 18:35
2

"LINQ query" is ambiguous. He could be using an NHibernate IQueryable adapter, but more likey LINQ to SQL or Entity Framework. Hopefully, the OP will clarify and we'll know for sure :) – jrummell Jun 12 '12 at 18:47

Way to view SQL executed by LINQ in Visual Studio?

4 Answers4

Linked