Black Friday is here! Get up to 30% off on Devart products!
ends in   {{days}}
Days
{{timeFormat.hours}}
:
{{timeFormat.minutes}}
:
{{timeFormat.seconds}}

Debug LINQ with LINQ Insight - Execute Queries at Design-time!

LINQ Insight allows you to execute your queries at design-time. That means, you don't need to start debugging your application and navigate to the query to test it, just write your queries and execute them right from your code, then view SQL and data without leaving Visual Studio!

LINQ Insight supports both usual LINQ queries and queries through extension methods. It also supports anonymous queries, for example, with immediate ToList calls.

LINQ Insight is fully integrated into Visual Studio - you don't need to run external applications and enter your queries to them. It detects the connection string and the context used automatically.

With LINQ Insight there is no more need in tedious debugging to check LINQ queries.

Data

With LINQ Insight you can preview data, returned for LINQ queries. The returned data is displayed in a grid, where you can sort and group, and filter this data. LINQ Insight even allows you to edit data for LINQ to SQL, LINQ to Entities, and LinqConnect.

ORM events info

SQL

For LINQ to SQL, LINQ to Entities, LINQ to NHibernate, and LinqConnect, LINQ Insight displays the SQL generated for the query. You can also see the parameter values used if the SQL uses parameters.

Queries view

Parameters

With LINQ Insight you don't need to replace variables in the query code with constants. LINQ Insight detects these variables and their types, and replaces them with parameters. You will be asked to enter values for them when you execute this query first time.

ORM events info

Connection String

In most cases LINQ Insight detects the connection string used by a query automatically, however you can always specify it manually in a convenient editor.

Queries view

Grouping Data

To group the data by any column, drag the column header you want the data to be grouped by to the Group By Box panel.

ORM events info

Filtering Data

You can easily filter data by entering the filter string to the Filter box on the LINQ Interactive window toolbar. LINQ Interactive window will display only rows containing the entered string and highlight the occurrences of the string.

Queries view

Viewing Related Data

LINQ Insight also offers you a convenient way to browse the related objects. You may either click the drop-down arrow in the cell with this property, to view its contents in a new grid without hiding the original data, or click the underlined object (or collection) property in the grid, and the grid will be filled with the contents of this property.

ORM events info

Editing Data

LINQ Insight allows you to edit data, returned by LINQ to SQL, LINQ to Entities, and LinqConnect queries. All the data updating operations are performed through the ORM. You can edit several objects and then apply changes or discard them.

Queries view