<< New Ternary code snippet for those learning C# | Custom Settings Providers and Portable applications/U3 Drives >>

SQL Command Visualizer for Visual Studio 2005

by Andrew Jackson 5. October 2007 21:11

I've finally got round to writing a visualizer I've been wanting for years, one that will give a decent representation of a SQL Command object, allowing you to view both the connection details and the list of parameters, their properties and values.

Below is a screenshot of what the visualizer looks like when you press the little magnifier when hovering over a Command object instance.

Available free from my Visual Studio 2005 Tools area as a VSI which will automatically install it.

Update:
If your having trouble with the vsi try renaming it to a .zip file, opening the file then copying the SQLVisualizer.dll to your My Documents\Visual Studio 2005\Visualizers folder.

I will research why the vsi's are occasionally giving this error.

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags:

Development

New Download - GUID Visualizer for Visual Studio 2005I'm trying to go through all my bits and pieces and either file, delete or publish them. Here's a l...New Download - Settings Snippets for Visual Studio 2005 Another VSI package for you, this time handling common win forms settings. It provides auto upgrade...New Download - WaitCursor Snippets for Visual Studio 2005Continuing my sifting through the bits and pieces I've accumulated I present two visual basic code s...

Comments

10/6/2007 6:52:23 AM #

When I try to open the VSI I get

"One or more content items contained within the .vscontent file cannot be installed because the correct version of the content installer component cannot be found.

Contact the author of the content file for information about which installers and versions are required."

Do you have a non-vsi version?

arakiel

10/9/2007 12:59:00 AM #

I got the installation problem trying to instal both on XP, SP2 and Vista as non-admin.

I installed the old fashioned way. It looked really promising, but when I visualized a call to a stored procedure, the parameters were duplicated - in other words in the list pane, the parameters appeared, then the parameters appeared again in totality.

Jeffrey Odell

10/9/2007 2:46:16 AM #

Update: I have fixed the issue with the doubling of parameters. A stupid thing introduced when the final version was being produced.

Andrew has writen 5 comments on this blog

Andrew Jackson

10/11/2007 5:33:45 PM #

I installed the visualizer the the old fashioned way. Unfortunately when debugging i get an Exception when trying to open the visualizer... The assembly load failed (due to security settings??)
A quick google revealed that HRESULT 0x80070005 means access denied. So i added read rights for every possible user to the dll, but I still get the same error. Probably COM components that get accessed by the VS plugin system.

The project i'm debugging is a Web Application project, maybe that's got something to do with it... Anyway here's the exception and stacktrace...

==========================================
OG: This bind starts in LoadFrom load context.
WRN: Native image will not be probed in LoadFrom context. Native image will only be probed in default load context, like with Assembly.Load().
LOG: Using application configuration file: C:\Projects\Fortis\FES\Fortis.FES.Website\web.config
LOG: Using host configuration file: c:\windows\microsoft.net\framework\v2.0.50727\aspnet.config
LOG: Using machine configuration file from C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Attempting download of new URL file:///C:/Documents and Settings/cva/My Documents/Visual Studio 2005/Visualizers/SQLVisualizer.dll.
ERR: A fatal error occurred when retrieving next codebase for download (hr = 0x80070005).

--- End of inner exception stack trace ---
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoadFrom(String assemblyFile, Evidence securityEvidence, Byte[] hashValue, AssemblyHashAlgorithm hashAlgorithm, Boolean forIntrospection, StackCrawlMark& stackMark)
at System.Reflection.Assembly.LoadFrom(String assemblyFile, Evidence securityEvidence)
at Microsoft.VisualStudio.DebuggerVisualizers.DebugViewerShim.ClassAndAssemblySpec.CreateAssembly(Dictionary`2 dictionary, AbstractAssemblyResolver resolver)
at Microsoft.VisualStudio.DebuggerVisualizers.DebugViewerShim.ClassAndAssemblySpec.CreateInstanceOrType(Dictionary`2 dictionary, AbstractAssemblyResolver resolver, InstanceOrType instOrType)
at Microsoft.VisualStudio.DebuggerVisualizers.DebugViewerShim.ClassAndAssemblySpec.CreateInstance(Dictionary`2 dictionary, AbstractAssemblyResolver resolver)
at Microsoft.VisualStudio.DebuggerVisualizers.DebugViewerShim.DebugeeHost.CreateSourceInternal(String assemblyNameOrLoc, Byte[] assemblyBytes, String className, Boolean isLoc)
at Microsoft.VisualStudio.DebuggerVisualizers.DebugViewerShim.PrivateCallback.MaybeDeserializeAndThrowException(Byte[] data)
at Microsoft.VisualStudio.DebuggerVisualizers.DebugViewerShim.ManagedShim.DelegatedHost.CreateViewer(IntPtr hwnd, HostServicesHelper hsh, SafeProxyWrapper proxy)

Chris

10/19/2007 5:40:24 AM #

I believe I fixed this by giving more than just read permissions. I was getting that error, but then played with permissions on the file, and it is now working. I just forget what permissions change worked. but then once it started working i had the duplicate parameters error, which I see is fixed. off to download new version.

Mike

7/12/2009 5:33:56 PM #