LINQ Insight

LINQ Insight is a Visual Studio add-in that provides a complete set of tools that make LINQ/ORM development faster and easier, and helps you to produce more efficient data access code. It allows executing LINQ queries at design-time directly from Visual Studio without starting a debug session, allowing you to test queries instantly after you write them. LINQ Insight also provides a powerful ORM profiler tool for profiling the data access layer of your projects and tracking all the ORM calls and database queries from the ORM.

LINQ Insight seamlessly integrates into Visual Studio.

View the generated SQL with the parameter values used.

Executing LINQ Query

Edit Parameters Window

Filtering Data in LINQ InsightTo filter data, enter the filter string to the Filter box on the LINQ Interactive window toolbar.

Grouping Data in LINQ InsightTo group the data by any column, drag the column header you want the data to be grouped by to the Group By Box panel.

Viewing Related Data in a Pop-up WindowYou may browse related objects in two ways. First, you may click the drop-down arrow in the cell with this property, and its contents will be presented in a new grid without hiding the original data. Another way is to click the underlined object (or collection) property in the grid, and the grid will be filled with the contents of this property.

View Related Data in the Same WindowYou can switch between opened data views with tabs at the bottom of the window.

Running an Anonymous Query with ToList Call

Running a LINQ to XML Query

Click for more

Image 1 / 11

LINQ Insight Features

Design-time LINQ Query Execution - LINQ queries at design-time. Unlike different LINQ debug visualizers, LINQ Insight does not require you to start debugging and step to the LINQ query execution for viewing returned data and generated SQL. Benefits:
- Test your LINQ queries instantly after you write them
- Estimate the query complexity analyzing the generated SQL
- Check if the query returns correct data
Powerful ORM Profiler - LINQ Insight offers you LINQ Profiler - a powerful...

Learn more about LINQ Insight