Query playground

Overview

This tool enables developers to interactively inspect the SQL queries generated by Entity Framework for LINQ queries against a specified Entity Framework Code-First model. By using this playground, developers can gain insights into how their LINQ queries are translated into SQL, aiding in performance optimization and query understanding.

Before running queries, a context must be defined. Use the Code-First model to query data from.

Using the Interactive Playground will give insight into how different providers map the same model.

Explore SQL statmements

Experiment with different LINQ queries and observe the corresponding SQL statements generated in the Results panel

Identify opportunities for query optimization by understanding how different LINQ constructs impact the generated SQL.

Shortcuts

While editing the query code (any pane with the .csx extension):

• Ctrl + Enter - Run the query

Happy exploring!