GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → Giorgi → Linqpad.queryplanvisualizer

Giorgi / Linqpad.queryplanvisualizer

Licence: other
SQL Server and PostgreSQL query execution plan visualizer for LINQPad

Labels

postgresqlnugetsql-server

Projects that are alternatives of or similar to Linqpad.queryplanvisualizer

Sqlprovider
A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
Stars: ✭ 423 (+102.39%)
Mutual labels:  postgresql, sql-server
Aceql Http
AceQL HTTP is a framework of REST like http APIs that allow to access to remote SQL databases over http from any device that supports http.
Stars: ✭ 68 (-67.46%)
Mutual labels:  postgresql, sql-server
Beekeeper Studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Stars: ✭ 8,053 (+3753.11%)
Mutual labels:  postgresql, sql-server
Sql exporter
Database agnostic SQL exporter for Prometheus
Stars: ✭ 301 (+44.02%)
Mutual labels:  postgresql, sql-server
Msbuild.sdk.sqlproj
An MSBuild SDK that provides similar functionality to SQL Server Data Tools (.sqlproj) projects
Stars: ✭ 142 (-32.06%)
Mutual labels:  sql-server, nuget
Sqlstreamstore
Stream Store library targeting RDBMS based implementations for .NET
Stars: ✭ 374 (+78.95%)
Mutual labels:  postgresql, sql-server
Aspnetcorenlog
ASP.NET Core NLog MS SQL Server PostgreSQL MySQL Elasticsearch
Stars: ✭ 54 (-74.16%)
Mutual labels:  postgresql, sql-server
Azuredatastudio
Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
Stars: ✭ 6,605 (+3060.29%)
Mutual labels:  postgresql, sql-server
Transformalize
Configurable Extract, Transform, and Load
Stars: ✭ 125 (-40.19%)
Mutual labels:  postgresql, sql-server
Xgenecloud
XgeneCloud is now https://github.com/nocodb/nocodb
Stars: ✭ 1,629 (+679.43%)
Mutual labels:  postgresql, sql-server
Entityframework.exceptions
Handle database errors easily when working with Entity Framework Core. Supports SQLServer, PostgreSQL, SQLite, Oracle and MySql
Stars: ✭ 266 (+27.27%)
Mutual labels:  postgresql, sql-server
Nut
Advanced, Powerful and easy to use ORM for Qt
Stars: ✭ 181 (-13.4%)
Mutual labels:  postgresql, sql-server
Sqlfiddle3
New version based on vert.x and docker
Stars: ✭ 242 (+15.79%)
Mutual labels:  postgresql, sql-server
Dotmim.sync
A brand new database synchronization framework, multi platform, multi databases, developed on top of .Net Standard 2.0. https://dotmimsync.readthedocs.io/
Stars: ✭ 406 (+94.26%)
Mutual labels:  sql-server, nuget
Tds fdw
A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Stars: ✭ 238 (+13.88%)
Mutual labels:  postgresql, sql-server
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)
Stars: ✭ 18,168 (+8592.82%)
Mutual labels:  postgresql, sql-server
Querybuilder
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
Stars: ✭ 2,111 (+910.05%)
Mutual labels:  postgresql, sql-server
Obevo
Obevo is a database deployment tool that handles enterprise scale schemas and complexity
Stars: ✭ 192 (-8.13%)
Mutual labels:  postgresql, sql-server
Pgsync
Postgres to elasticsearch sync
Stars: ✭ 205 (-1.91%)
Mutual labels:  postgresql
Tsql Parser
Library Written in C# For Parsing SQL Server T-SQL Scripts in .Net
Stars: ✭ 203 (-2.87%)
Mutual labels:  sql-server
View All Similar Projects ➔

LINQPad.QueryPlanVisualizer

NuGet Package Apache License Ko-Fi

SQL Server and PostgreSQL query execution plan visualizer for LINQPad

Features

Getting Started

If you use LINQPad 6, you must use version 2.0 of this library. For LINQPad 5, you must use version 1.0

The library can show query plans for LINQ to SQL driver and Entity Framework Core 5.

Install from NuGet

If you have a Developer or higher edition of LINQPad, you can use the LINQPadQueryPlanVisualizer package from NuGet to add the visualizer to your queries.

Install as plugin

To install the visualizer as a LINQPad plugin, download the latest release and drop the visualizer dll directly inside LINQPad's plugins folder (by default found at My Documents\LINQPad Plugins\NetCore3 for LINQPad 6 and My Documents\LINQPad Plugins\Framework 4.6 for LINQPad 5). The plugin will be automatically available in all your queries.

Viewing query plan

To view query plan or missing indexes, call static QueryPlanVisualizer.DumpPlan(query) method or call DumpPlan extension method on an IQueryable instance. You will also need to add ExecutionPlanVisualizer to the namespaces list (click F4 to open the dialog). If you want to dump query result as well, pass true as a second parameter.

Query execution plan: Sql Server query plan

PostgreSQL query plan

Viewing missing indexes

For SQL Server, the query plan can also return information about missing indexes in QueryPlan/MissingIndexes/MissingIndexGroup element. If missing indexes are present in the plan the visualizaer will show a second tab with the missing index details and a button to create the index.

Missing index: missing indexes

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].