LINQ Insight Express is a Visual Studio add-in that allows you to analyze your LINQ queries at design-time and simplifies writing and debugging LINQ queries.
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.