Visual Studio and .NET Framework Home
Can't find Linq to SQL Query Visualizer
Ben Hall _UK_
as By Design
7/30/2007 3:10:01 PM
User(s) can reproduce this bug
I thought the Linq to SQL Query Visualizer had been reintroduced into Beta 2 however I cannot find it. There is no magnifying class when you hover over a query result. Just the sql query as a string.
I have attached a screenshot of what I get.
Visual Studio Code Name "Orcas" (Beta 2)
Operating System Language
Steps to Reproduce
Create a new project
Write a linq to SQL statement:
var query = from o in db.Orders
Set a breakpoint on the query.
Execute query, (Pressing F10) which will generate the action. If you QuickWatch the variable used (query) then you will see the SQL Statement which will be executed.
However there is no way to display the visualiser.
Can only view the query as the SQL Code in the small debugger/quickwatch box.
I expected it to look something like this:
TAP Code (if applicable)
You can indicate your satisfaction with how Microsoft handled this issue by completing this quick
3 question survey
to post a comment.
Please enter a comment.
on 8/2/2007 at 6:19 PM
Thank you for taking the time to try out new LINQ to SQL feature in beta2 and providing feedback. The query visualizer is a sample that is available in source form in a zip file that is installed for all SKUs exception Visual Studio Express. The visualizer project and sources are in Program Files\Microsoft Visual Studio 9.0\Samples\1033\CSharpSamples.zip
After extracting the files, you can use Visual Studio 2008 beta2 to build visualizer DLL and install the DLL in either the machine-wide or user-specific visualizers directory.
Thanks again for trying and giving feedback.
Sr. Program Manager
on 8/2/2007 at 10:28 AM
on 7/30/2007 at 5:33 PM
Thank you for your feedback. We are currently investigating. If this issue is urgent, please call support directly (see http://support.microsoft.com).
Visual Studio Product Team
to post a workaround.
Please enter a workaround.
on 8/1/2007 at 8:03 AM
The SQL Query Visualizer (and Expression Tree Visualizer) CSharpSamples.zip and VBSamples.zip files are in the \Program Files\Microsoft Visual Studio 9.0\Sample Files\1033 folder. You can expand these zip files to any location you want, but be sure the Use Folder Names check box is marked.
Howevever the Readme.htm files have the wrong location for deploying visualizer libraries (which I've reported today as a bug). Scott Guthrie gives the correct location in yesterday's post (http://weblogs.asp.net/scottgu/archive/2007/07/31/linq-to-sql-debug-visualizer.aspx)
Niels Ladegaard Beck
on 7/31/2007 at 11:13 PM
Scott Guthrie explains here how to enable the LINQ to SQL Query Visualizer:
© 2014 Microsoft