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 query visualizer to visualize Compiled LInQ
query having parameters |
 |
|
LInQ query visualizer to visualize normal LInQ
query having parameters |
 |
|
|
Screen shot of LInQ to Entity Visualizer [WPF
version]
 |
|
|
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. |
