Linq to Entity query visualizer

Free

View Native SQL (MS SQL, DB2, Oracle, etc) of LInQ to entities ObjectQuery while debugging in Visual Studio 2008/2010/. Also view Lambda expression, edit Query parameters, view DB Connection info, view query results, and export results to MS Excel(No MS Excel required)

RRV
(19) Review
Visual Studio
2012, 2010, 2008
Get now (48,881)
9/30/2013
3.3.0.0
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (19)
Q and A (12)
Sign in to write a review
Sort by:

by MartinN04 | August 13 2014

Tried to install and get it working. I have read all the suggestions. Seems only partial to work. I'm using VS 2013 Premium, which is IMHO same as 2012. I get no magnifying glass, but in the Watch-Window I can see the SQL statements.

by Gondwe | July 18 2014

This is a great tool, but we would appreciate it if you could provide clear steps on how to use the tool in VS.

by jeff.mounce | September 11 2012

Nope, doesn't seem to work for me either.
Tried all the suggestions.

Oh well.

RRV September 30 2013
| Edit |
Delete

Hi,

Please try the VS2012 version (v3.3.0.0). It works for VS2010 also if you have any version (including express) of 2012 installed. Specifically the MTA/STA thread issue in VS2010 version which hangs the IDE is fixed in this version.

Kindly share the steps you followed to get it working along with your environment details to info@rajavenkatesh.com

Thanks
Venkat

by BlueOceanCoder | February 09 2012

I was having allot of problems getting the plugin to work even after following all the instructions.


The trick was to add the following web.config tag under system.web

<trust level="Full" originUrl="" />


Hopefully that helps someone, I just spent 5 hours figuring it out :-)

RRV March 07 2012
| Edit |
Delete

Thanks BlueOceanCoder.

Regards
RRV

by Shimmy Weitzhandler | January 17 2012

by Toddler | January 03 2012

i would rate this higher, but unfortunately, i am having a few issues. unless i am overlooking something obvious, the results are not part of the wpf version 3.2.0.2. after successfully connecting (according to the log) and executing the query (also according to the log), the status still shows executing and no results are ever presented. when closing the visualizer, visual studio crashes.

on the positive side, i like how you grab the parameter info and format the sql. having the connection credentials local is also handy.

i certainly think the tool is in the right direction, but needs a little polish. thanks for your efforts.

RRV January 04 2012
| Edit |
Delete

Please let me know if you found any entry in eventvwr during Visual Studio crash.

by chuck02323 | December 13 2011

Doesn't work. Hover over the query, locks up vs10sp1 win7.

RRV January 03 2012
| Edit |
Delete

Hi, Sorry for the inconvenience caused.
Please use the single thread version 3.2.0.2 available at http://www.rajavenkatesh.com/Projects.aspx
You can find the link under LInQ Visualizer-2010\Description

1. Having EDMX support natively for multiple databases like MS SQL, SQL CE, Oracle(28-Dec-2011), DB2, etc i've tested the tool to generate correct native SQL including parameters during your debug session.
2. Option to test the generated SQL using various providers/namespaces for performance.
3. Option to alter SQL parameters/values.
4. Use native datatypes for SQL parameters.
5. Option to export result of SQL to MS Excel even if you dont have MS Excel installed.

Kindly rate this tool after testing. Please support by clicking sponsors to keep us alive.

Thanks
RRV

by G_21 | November 08 2011

It did not work at all. The magnifying glass did not show up in the debugger.

I have Visual Studio 2010 service pack 1 running on Windows 7 64 bit. The folder paths in the install instructions also do not match perfectly, but I think I found the corresponding folders.

RRV January 03 2012
| Edit |
Delete

Please use 3.2.0.2 version. (location as said above)
1. Compiled against (Any CPU).
2. If you find it difficult to find the magnifying glass, add the query result variable to Watch Window and in watch window right hand corner you'll be able to see the magnifying glass.
3. Magnifying glass will appear only with an Object query result. Not if you had casted the query to a different data type.

Kindly rate this tool after testing.

Thanks
RRV

by Canyon Country | October 29 2011

Sounds like a nice utility if I could get it to work. As others found, version 3.2.0.1 locks up VS 2010 Professional running on Win 7 Ultimate x64. I tried to download the non-WPF version, but that link is broken.

RRV January 03 2012
| Edit |
Delete

Hi,
1. The non WPF version link is corrected.
2. A new link for those who get VS2010 hanging is released(3.2.0.2)

Thanks
RRV

by HFamilyKid | September 30 2011

Hi again,

I would really appreciate your help to get your supposedly fab tool working - many thanks.

Ive got the file in both:
My Documents\Visual Studio 2010\Visualizers

&

C:\Program Files\Microsoft Visual Studio 10.0\Common7\Packages\Debugger\Visualizers

I'm using AnySourceEntityQueryVisualizerWPF.dll v3.2.0.1 in both the installed paths as mentioned, there are no other files of yours in use. I dont get any 'unblock' right click option (Ive never ever seen or heard of this before?). Which path should this file be installed to - please answer this question first.

I now get the magifying glass icon but system becomes unresponsive when clicked?

I'm running windows XP SP3 and this version of VS2010 as detailed below:

Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.0.30319 SP1Rel

RRV September 30 2011
| Edit |
Delete

Hi, I faced similar problem in WinXP SP3. Later i found in WinXP SP3, a WPF MTA thread does not get started but freezes main thread. Only STA thread works. So i compiled the entire source code in Win7/VS2010-Ultimate. Then it started working without freezing.
I'll have to device a new technique to get it working in WinXP-SP3.
As you mentioned, unblocking... is above WinXP-SP3 (Vista, Win7)
Thanks for your patience. Will let you know once a specific version for WinXP-SP3 is ready.

Raja Venkatesh

by M.Radwan-MVP | July 15 2011

good

by dunagaraj | June 27 2011

It doesn't work for me at all. Whenever i click on magnifier icon, the VS ULTIMATE becomes unresponsive. I am having the very latest machine of i5 processor with 4GB RAM, W7 64-bit.

Any help will be appreciated

RRV September 25 2011
| Edit |
Delete

Current version is compiled using Win7 and unresponsiveness is gone as new MTA thread in WPF works now which did not work when compiled in WinXP.

by DhawalP | May 06 2011

Ok. Unblocking the dll fixed the below issue. But now it shows a popup box saying - 'Specified cast is not valid'.

I'm getting the same error as Shimmy Weitzhandler. I copied the file to the right directory and the file does exist at the path specified in the error message. Any idea how to fix it?

I'm using VS2010 sp1 on Win7 64-bit OS.

Could not load file or assembly 'file:////c:\Users\dpatel\Documents\Visula Studio 2010\Visualizers\AnySourceEntityQueryVisualizerWPF.dll' or one of its dependencies. Operation is not supported. (Exception from HRESULT: 0x80131515).

by hong6 | March 24 2011

nice! very helpful.

by vkrish28 | February 04 2011

by Cheung Tat Ming | January 28 2011

The Addon is great! However, the WPF Grid's color is not very nice....
And it has a bug, On the section of Query(s) & Parameters, the LINQ statement's parameter cannot edit second times.

by Yogendra Khopkar | October 25 2010

by Bryan H Foster | August 16 2010

This tool is awesome. Highly recommended to all. Thanks to RV for creating it and supporting it. One would expect there to be something like this built in to VS, but there is not. This has exactly what I had hoped for and expected and is very useful for debugging and understanding the SQL that will be generated. Make sure to read all of the Q&A and follow suggestions/directions closely.

by Tical | January 13 2010

Very nice indeed. The only thing I would add is the ability for the visualizer to point out what parameters need to be set and a place for you to set them. As it is now, you have to look through the SQL expression and replace the parameter with the value you want to use.

RRV January 03 2012
| Edit |
Delete

Hi,
Hope you are using the parameter editing with native datatypes. Let me know if you face any issues.

Thanks
RRV

Sign in to start a discussion


  • VS2010 version issues
    8 Posts | Last post September 30, 2013
    • RRV
      Hi, Couple of Sev-1 errors faced in VS2010 version is resolved.
      
      * "Specified Cast is Not Valid" while using Oracle Entity Framework solved.
      * Few users getting Visual Studio unresponsive is addressed by pushing the visualizer into a new WPF UI thread.
      * Possibility of having multiple working DB providers via dropdown box seletion.  Can compare performance of same SQL against different providers.
      * Sub screen showing results of executed query has "Export to Excel". This export feature working too slowly with large data is addressed and can work quite fast without having Excel installed in user's PC.
      * Visualizer Log box updates itself with seperate UI thread showing real time log.
      
      Recommendation: Users having difficulty to find magnifying glass can use "Add Watch" window.
    • RRV
      Hi, If you continue to face Visual Studio unresponsive issue please ensure you use version 3.2.0.1.
      
      Thanks for your patience.  Happy debugging.
    • hi RRV,I have install version 3.2.0.1, but the visual studio still unresponsive.why?
    • RRV
      Hi RMickael,
      Please find the version 3.2.0.2 available in the same download link under Description. I managed to simulate the hanging issue and corrected the same.
      
      Thanks
      RRV
    • If your Visual Studio 2010 hangs, use this single thread version (3.2.0.2). When i downloaded it still gave me the version 3.1.0.1 and visual studio still unresponsive. Can you please help ASAP.
      
      Thanks,
      Akirah
    • RRV
      Hi Akirah,
      Have you tried <trust level="Full" originUrl="" /> in your web.config as described in Reviews section?
      
      Let me know if you use Windows XP/7 64 bit.
    • Hi,
      The link for v3.2.0.2 (VS2010 description) contains v3.1.0.1. Could you please update the reference?
      Many thanks for this great tool.
      (5. If your Visual Studio 2010 hangs, use this single thread version (3.2.0.2).)
    • RRV
      The Visual Studio unresponsive issue due to switch in MTA/STA thread is fixed in version 3.3.0.0.  This works for VS2010 also.  Hope this helps many of you.
      
      Thanks
  • Which version?
    3 Posts | Last post January 03, 2012
    • In the previous post RRV says to use version 3.2.0.1.  However, when I download the dlls for VS 2010, the version of the dll is 3.1.0.1.  Where can I find the 3.2.0.1?
    • facing the same issue and cannot find the 3.2.0.1 version of the visualizer. anyone could help?
    • RRV
      Hi RMickael,
      Please find the version 3.2.0.2 available in the same download link under Description. I managed to simulate the hanging issue and corrected the same.
      
      Thanks
      RRV
  • LInQ Visualizer in VisualStudioMagazine
    1 Posts | Last post June 11, 2011
    • RRV
      Hi friends, Happy to bring to your notice that LInQ Visualizer has been selected one among best free Visual Studio and .NET tools and add-ins by VisualStudioMagazine.  The article is available at http://visualstudiomagazine.com/articles/2011/06/01/pfint_free-tools.aspx 
  • Unable to use the visualizer
    3 Posts | Last post June 11, 2011
    • RRV
      Of late i received few emails stating that everything looks fine but the visualizer intellisense does not popup.  Finally we found they were waiting on a linq query which is converted to list. Ex
      
      Dim OutQry = (From iQr in NWndEnt.Customers
                   Select iQr).ToList
      
      Hovering mouse over OutQry will not help.  This visualizer works on ObjectQuery, not List.
      
      Thanks
      Venkat
    • Hi, 
      
      I have Windows XP SP3, VisualStudio 2008 and Devart installed to connect to Oracle, 
      
      I follow all the steps to activate the visualizer (DLL, <loadFromRemoteSources enabled="true"/>, code...  but it doesnt work
      
      Is there an update for your query visualizer?
      
      Thanks and greetings from Mexico.
      
    • RRV
      Hi arzamm,  Can you mail me [info@rajavenkatesh.com] more details on steps you followed to get it working.  I shall get back to you on method to get it working.  Thanks for your patience.
  • System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file...
    3 Posts | Last post May 03, 2011
    • When I found out about this tool, I thought it'd be very useful because I could view the resulting query in debug mode, but mostly because I could execute it and see the results. But, so far, it's been nothing but a waste of my time.
      
      I am using VS2008 Pro, SQLExpress 2008, and C#. I have a Web Site opened in VS, and I have a MS-SQL database in the App_Data folder. I have a Linq query against that database. I have a breakpoint just after the Linq statement. When I debug the application, it stops at the breakpoint. I then use the Visualizer to view the query, but when I click on Execute, I get the subject error. The last part of the error message says: "A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." (my DB is not on UNC share).
      
      I have spent a considerable amount of searching on this error, as it relates to this tool, but found no solution. There is a mention of that error in this Q and A, but the answer is less than helpful.
      
      My Web site works fine otherwise. I don't believe I am doing anything out of the ordinary, and my setup is a pretty standard one. I would expect many others to experience the same, but I am baffled by the lack of hits on my searches.
      
      What gives? 
      
      
    • RRV
      Hi meamdarealman,
      We have faced this error while working with file based database (MDF) in SQL.
      At first time of use, you could have opened this DB file connection in SQL Management studio.  Remove this DB file from SQL management studio.  Once you are not seeing the database in SQL MStudio, a db connection to the database file could be established.
      If this solves, good luck to you.  Otherwise please email to me at info@rajavenkatesh.com and i shall get back to you with more details to solve it.
      Thanks for your patience.
      Please support my sponsors @ http://www.rajavenkatesh.com.
      
      Venkat
    • RRV
      Hi meamdarealman,
      Executing below code via a Detach.cmd file could help.  Modify as required.
      *******************************
      set DATABASE_NAME=NorthwindEF
      set SERVER_INSTANCE=%1
      if (%1)==() set SERVER_INSTANCE=.\sqlexpress
      
      osql -S %SERVER_INSTANCE% -E -Q "exec sp_detach_db '%DATABASE_NAME%'"
      *******************************
  • "Get Now" not working
    3 Posts | Last post April 02, 2011
    • The url is bad, or the serveris down. I can't get the tool.
    • RRV
      Hi, Today the hosting of website was changed.  Please expect a day or two delay as the internet servers have to update the new links.
      
      Thanks for your patience.
      Venkat
    • RRV
      Sorry for the inconvenience caused for bad url stuff.  The download site is up now.
      Thanks for your patience.
      Venkat
  • Can you please provide any screenshots of the tool?
    2 Posts | Last post March 22, 2011
    • _
    • RRV
      Please see version 3 screen shot at http://www.rajavenkatesh.com/Howto_LInQVisualizer.aspx.
  • If LInQ to Entity Debug Visualizer is not working...
    7 Posts | Last post October 06, 2010
    • RRV
      Just in case if anyone of you don't get the visualizer working.  Kindly check the below steps.
      
      1.  Are you trying to connect using ADO.NET entity data model? This tool is designed to connect to any datastore (MSSQL, MySQL, DB2, Oracle, ...even new future datastores) if you use "*.edmx" only.
      
      2.  Is <loadFromRemoteSources enabled="true"/> added to devenv.exe.config under "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe.config" ?  You may have to find equivalent path in your PC where Visual Studio is installed.
      
      3.  Have you placed AnySourceEntityQueryVisualizer.dll in "My Documents\Visual Studio 2010\Visualizers" folder?  If placed and your OS is Windows Vista or Windows 7, have you unblocked this downloaded dll in that folder for other applications to use?
      
      4.  Are you able to see any new entry in eventvwr?
       
      5. If you still get the "System.NotSupp ortedException" problem on Vista/Windows 7,
      
      After copying the dll to your "Documents\Visual Studio 2010\Visualizers" folder, right click on the file and select unblock - windows doesn't trust the dll by default.
       
      After this you might notice that Visual Studio 2010 does not load visualizer dll's automatically like Visual Studio 2008.  To enable Visual Studio 2010 to load visualizer dll you have to edit "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe.config" file using notepad.  Then under the runtime element add as below
      <runtime>
              <loadFromRemote Sources enabled="true"/ >
      ...
      
      Hope these two ideas will get the visualizer working for you.  If not kindly let me know.
      
      If all of above did not solve check if you are using right visualizer version in right Visual Studio version.  I've placed two different dll's for VS2008 and VS2010 in the download site.  Kindly use the right one.
       
      If still could not get it working, kindly let me know at rrvenki@yahoo.com
      
      Thanks
      Venkat
    • RRV
      Sorry.  That was few ideas not just two.
      I found some people telling they get red X mark in a datetime column in the result window.  The reason is the data format error is not handled in the datagridview of the result window when independent thread fills the data to the datagridview. In case of such wierd errors, Kindly send me the "Execution Log" content in email to me.
      
      Please bear with me until i upload the WPF version in which i've addressed this issue.  It is taking little more time than anticipated as i'm building the parameter editing feature also to it.
      
      Thanks
      Venkat
    • I was trying to get the Linq to entity visualizer you have created. I have added an entry like -
      <loadFromRemoteSources enabled="true"/> 
      added to devenv.exe.config under 
      "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe.config
      and also copied the dll here C:\Program Files\Microsoft Visual Studio 9.0\Common7\Packages\Debugger\Visualizers
      
      But so far nothing happen when I am trying to debug the queries and I dont get any exceptions or errors. I opened up eventvwr but I dont know where I should be looking in it to check. I am using Windows Vista Basic. Please guide me in right direction.
    • I was trying to get the Linq to entity visualizer you have created. I have added an entry like -
      <loadFromRemoteSources enabled="true"/> 
      added to devenv.exe.config under 
      "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe.config
      and also copied the dll here C:\Program Files\Microsoft Visual Studio 9.0\Common7\Packages\Debugger\Visualizers
      
      But so far nothing happen when I am trying to debug the queries and I dont get any exceptions or errors. I opened up eventvwr but I dont know where I should be looking in it to check. I am using Windows Vista Basic. Please guide me in right direction.
    • Hi Venkat. Do you happen to know if the debugger is capable of supporting VB projects at this time. I have run through the gammut of attempting to get this to work for my VB web apps/projects and had no luck. I cannot get it to return anything other than resultsets. 
      cheers.
      mac 
    • RRV
      Hi macaroo,
      The debugger definitely supports VB.NET projects [for that matter any CLR2/CLR4 targetting .NET languages(25 )] but is Visual Studio version dependent.  You may have to download the appropriate version from download site.  Indeed the visualizer is completely developed using VB.NET and tested in VB.NET projects.
      If you have followed up all above steps and still could not get it working kindly let me know your specific problem or give a brief description how you tried to install and use the visualizer.  Send me a direct mail (mail id in contact page of download site).
      Thanks
      Venkat
    • RRV
      Hi Friends,
      It was some time after i worked on this tool (Visualizer).  It is time now to release an update i thought.  It was a requirement which i encountered though.
      In a scenario i had more than one connectable provider installed in my PC. Example: I had ODP.NET and Devart to connect to Oracle.  I had no choice to select provider in this visualizer.  Neither in Datatool.  I've added an update which provides you an option to select a connectable provider to use.  In case there is only one connectable provider - alas no option then.  Once testing is completed i shall release both datatool and visualizer.  And this time i thought a DBConnection object too should have a visualizer than just a "Text Visualizer".
      Kindly let me know if it would be wise to create a click once program like datatool [www.rajavenkatesh.com] for Visualizer so that it takes care of installation part automatically and also manages updates automatically.
      Thanks
      Venkat
  • Access is denied.
    1 Posts | Last post August 11, 2010
    • I am very excited to use this tool. I have installed version 2.1.5 in the correct directory and see the magnifying glass to start visualizer, but getting message:
      Unhandled exception has occurred in a component in your application.  If you click Continue, the application will ignore this error and attempt to continue.  
      
      Could not load file or assembly '....\My Documents\Visual Studio 2010\Visualizers\AnySourceEntityQueryVisualizer.dll'  or one of its dependencies.  Access is denied
      
      I noticed on the properties dialog of the file:
      'Security:This file came from another computer and might be blocked to help protect this computer'
      and unblocked it, but is there a specific account that needs access to this file to allow it to work?
      
      Thanks in advance,
      
      Bryan
      
  • Using attached SQLExpress DB
    2 Posts | Last post July 29, 2010
    • Hi,  
      
      I'm using the out-of-the-box VS2010 MVC2 template with a SQL Express .MDF in App_Data and attached using a connection string like:
      
      add name="Content" connectionString="metadata=res://*/Models.EntityDataModel.csdl|res://*/Models.EntityDataModel.ssdl|res://*/Models.EntityDataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Content.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" 
      
      
      The visualizer displays the generated query perfectly, but on execute it displays an error messsage (behind the visualiser window..) that states:
      
      
      An attempt to attach an auto-named database for ... failed.  A database with the same name exists, or ...(other not relevant reasons)
      
      Obviously because VS has already attached the MDF.
      
      While I'm not too bothered as it's the Native SQL I was after (at this time), I thought I'd let you know about the attached SQLExpress DB issue incase you can get it to work with an existing connection
      
      Version 2.1.5
      
      Marc
      
      PS. Any chance you could remove the gaudy colours?  :)
      
      
    • RRV
      Hi MarcF,
      1. Your SQL server already has a database registered called "Content".  You may have to take backup of it and remove in order to get your db queries work.  Or you could possibly change your "Content.mdf" to another name.  You should be able to view results.  If not kindly send me the Log information displayed below Native SQL in the screen.
      2. Well about colors... I believe developers cannot be good designers and vice versa.  But this time in next version i will try my best to select a better color.
      
      Kindly rate the tool.
      
      I'm expecting somebody to use a database other than MS SQL and let know if they are able to view native SQL.  However i've tested against DB2 for LUW, Oracle, MySQL, etc. Native sql generation for all scenarios should be good.
      
      Regards
      Venkat
1 - 10 of 12 Items