LightSpeed includes a Visual Studio debugger visualizer which you can use to view the SQL statements generated by a LightSpeed Query object.
To install the visualizer for Visual Studio 2005:
- Copy Mindscape.LightSpeed.DebuggerVisualizer.dll to My Documents\Visual Studio 2005\Visualizers or (Program Files)\Microsoft Visual Studio 8\Common7\Packages\Debugger\Visualizers.
To install the visualizer for Visual Studio 2008:
- Copy Mindscape.LightSpeed.DebuggerVisualizer.dll to My Documents\Visual Studio 2008\Visualizers or (Program Files)\Microsoft Visual Studio 9.0\Common7\Packages\Debugger\Visualizers.
To use the visualizer:
- Start a debug session.
- Examine a LightSpeed Query object in a DataTip, a debugger variables window or the QuickWatch dialog. You will see a magnifying glass icon next to the text.
- Click on the magnifying glass icon to display the query SQL.