Logo

dots home contact    

 

How to use LInQ to Entity Debug Visualizer
Download
Install
How to install
Step 1.  By clicking the download link you'll be prompted to save "AnySourceEntityQueryVisualizer.zip".  Download and extract the files to "C:\Program Files\Microsoft Visual Studio 10.0\Common7\Packages\Debugger\Visualizers" in Windows XP or "My Documents\Visual Studio (2008/2010)\Visualizers" in Vista or Windows 7.  Ensure you accept it is safe to use downloaded programs from internet by clicking the file(s) properties.

Step 2.  In VS2010 open devenv.exe.config from "C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\" using notepad or any text editor.  After <runtime> add <loadFromRemoteSources enabled="true"/>.  The file should look like

<?xml version ="1.0"?>
<configuration>
    <configSections>
        <section name="msbuildToolsets" type="Microsoft.Build.BuildEngine.ToolsetConfigurationSection, Microsoft.Build.Engine, Version=4.0.0.0,  Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
    </configSections>
    <startup useLegacyV2RuntimeActivationPolicy="true">
        <supportedRuntime version="v4.0.30319" />
        <requiredRuntime version="v4.0.30319" safemode="true"/>
    </startup>
    <runtime>
        <loadFromRemoteSources enabled="true"/>
        <UseSmallInternalThreadStacks enabled="true" />
        ...

Ensure you download the right visualizer version for right Visual Studio version.

For Visual Studio 2010 the default download is the WPF version.  In case you want the earlier version you can download here.
  How to use LInQ to Entity Visualizer
While you are debugging your LInQ Object query, hover your mouse on the objectquery result variable after execution of LInQ query.  If the Visualizer DLL is placed in the correct folder and is in working condition, you should get a magnifying glass in the intellisense tooltip.  Click the down arrow next to the magnifying glass.  You'll get "RV's LInQ to Entity Visualizer".  Click on this link to open the visualizer.
You have option to
1. View Lambda expression [ReadOnly]
2. View transliterated Native SQL [ReadWrite].  If Native SQL is changed, you can save and execute to view results.  But the Expression does not change.
3. Parameter list [ReadWrite]
4. DB Connection properties [ReadOnly]
5. Execute - To view results of the Native SQL.
6. Post execution, the query execution log.
7. Option to export SQL result to MS Excel.  This option does not require MS Excel in your PC.
LInQ query visualizer in Visual Studio 2010 LInQ Visualizer Image-1
LInQ query visualizer to visualize Compiled LInQ query having parameters Compiled LInQ query
LInQ query visualizer to visualize normal LInQ query having parameters LInQ query Paramters
  Screen shot of LInQ to Entity Visualizer [WPF version]
L2E Visualizer
  Export SQL result to Excel
In the query result windows click * "Export to Excel" option.  This will prompt user to enter a file name.  Once given a new file will load in your browser.  You can save this file as XLSX if you don't have MS Excel installed.  If you already have MS Excel the file automatically loads in MS Excel.
* Does not require MS Excel to be present in your PC.

  P - Supporting the Go Green initiative and fight against global warming.

Home | About | Contact | Projects | Resources

The site can be best viewed in 1024x786 resolution or higher.
© 2010 Raja Venkatesh. All Rights Reserved.

RV_Logo