Clever Geek Handbook

Visual Studio 2012 Linq to SQL Renderer

What's the easiest way to see SQL (and ideally data) generated using a Linq query in Visual Studio 2012 ?. I have previously used several debug visualizers that work well in VS2008 / 2010, but I cannot find a working one for 2012.

For example, I have Linq:

var l = ctx.PurchaseOrders.Where(c => c.PurchaseOrderID == searchstring);

How can I see that SQL is a Linq to conversion?

I am using Entity Framework

+3


source to share


3 answers


I used Orm profiler , it is not free, but it saves me a lot of time to look at the SQL view generated by EF and analyze performance issues.



+2


source


You can also try Visual Studio IntelliTrace

.



0


source


If you are working with MS SQL Server, you can use "SQL Server Profiler". Besides the SQL statement, including the parameters, you get statistical information for your query (CPU costs, reads, writes, ...).

0


source






More articles:


All Articles