LINQ Insight Express is a Visual Studio add-in that offers useful tools for LINQ and ORM development. It provides tools for design-time LINQ query execution and preview of generated SQL and for profiling data access events from such ORMs as Entity Framework, NHibernate, LinqConnect, and LINQ to SQL.
Design-time LINQ Execution
Visual Studio Integration
LINQ Insight is fully integrated into Visual Studio. You don't need to run external applications and enter your queries to them, just open SQL for LINQ queries in code and view it without leaving the IDE.
Convenient Query Analysis
You don't need to perform any specific actions with your context and queries. LINQ Insight detects the used context and connection string automatically. If your query depends on some variables, LINQ Insight detects them and asks for values, so you don't need to replace them with constants.
Unlike different LINQ debug visualizers, LINQ Insight does not require the debug session. It allows you to preview generated SQL at Design-time.
Support for Different Kinds of Queries
LINQ Insight supports both usual LINQ queries and queries through extension methods and can work with anonymous queries, for example, with immediate ToList calls.
Advanced Profiler for Data Access Operations
LINQ Profiler tool displays performance information for transactions, connection opening and closing, SQL execution for all data access events caused by ORM run-time.
Queries View with Summarized Information
Queries view allows you to easily find the situations when a query is used too often and it may be better to cache its results than to use it each time. It allows you to group the executed SQL queries by query text, or the context used and see the total number of queries in each group and total time these queries took to execute.
LINQ Insight allows you to filter information by the context objects with the Object Tree window or by calling method with the Call Tree window. The latter displays the tree, created by merging all call stacks of ORM calls and offers wide capabilities for analysis of calling method data.
No Need to Modify the Project
With LINQ Insight there is no need to modify your project for profiling it. Just start profiler session in the profiler and run your project.
LINQ Insight Standard Features
LINQ Insight Express also includes the trial features of LINQ Insight Standard.
LINQ Insight Express, in addition to FREE SQL Viewing and data access events profiling functionality, offers the 30-day trial of LINQ Insight Standard edition data viewing and ORM events profiling functionality. LINQ Insight Express SQL viewing and data access events profiling functionality remains available after the end of the trial period.
LINQ Execution Features
LINQ Insight Standard allows you to preview data, returned for executed LINQ queries. Data is displayed in a convenient form in a grid with powerful data sorting, grouping, and filtering features. Data for Entity Framework, NHibernate, LinqConnect, and LINQ to SQL is editable. Additionally LINQ Insight Standard can execute LINQ to XML and LINQ to Objects queries. LINQ Insight retrieves data in object form. That means, all properties that are actually references to other objects and object collections contain these related objects, and you can easily browse data of these related objects.
LINQ Profiler Features
Besides data access events profiling, LINQ Insight Standard provides true ORM profiling. With LINQ Insight Standard you can see how much time LINQ statement or SubmitChanges call takes to execute as a whole even if it generated multiple SQL statements. You profile exactly the code you write and study the real performance of your LINQ code.