Execute LINQ Queries at Design-Time and Profile ORM Data Access with 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.

Design-time LINQ Query Execution

How to use LINQ Insight: place cursor on the query and press CTRL+SHIFT+R, specify parameter values, and view the generated SQL and returned data.

LINQ Insight allows you to test 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

Read more about design-time LINQ query execution...

Powerful ORM Profiler

LINQ Profiler screenshot

LINQ Insight offers you LINQ Profiler - a powerful tool that allows you to profile your projects and track all the ORM calls and database queries from the ORM. It enables you to see the performance of the data access code and easily determine performance bottlenecks.

Benefits

  • Get insight into all the interaction with ORM and database
  • Measure performance of your data access code and analyze it easily
  • Start profiling instantly without the need to modify your project

Read more about LINQ Profiler...

Quotes

LINQ Insight gives me incredible insight (no pun intended) into the workings of both EF and LINQ to SQL, allowing me to see directly the impact my queries will have on the performance of the final product. I am also able to see that I am returning the correct information without having to test the app.

Stephen Metcalfe, Senior Developer, Value Logistics

Free Edition Available!

LINQ Insight comes in two editions - free Express edition and Standard edition. Express edition provides viewing of generated SQL and profiling data access events for ORMs. It also contains the 30-day free trial of LINQ Insight Standard edition, which allows you to view data returned by LINQ queries and to profile ORM calls.

Supported LINQ Providers

  • LINQ to Entities (Entity Framework)
  • LINQ to NHibernate
  • LINQ to SQL
  • LinqConnect
  • LINQ to XML
  • LINQ to Objects
  • RavenDB
  • A tool for executing LINQ queries directly from Visual Studio that displays SQL and data
  • ORM Profiler