LINQPad.QueryPlanVisualizer alternatives and similar packages
Based on the "Misc" category.
Alternatively, view LINQPad.QueryPlanVisualizer alternatives based on common mentions on social networks and blogs.
-
Polly
Polly is a .NET resilience and transient-fault-handling library that allows developers to express policies such as Retry, Circuit Breaker, Timeout, Bulkhead Isolation, and Fallback in a fluent and thread-safe manner. From version 6.0.1, Polly targets .NET Standard 1.1 and 2.0+. -
-
Humanizer
Humanizer meets all your .NET needs for manipulating and displaying strings, enums, dates, times, timespans, numbers and quantities -
-
Coravel
Near-zero config .NET library that makes advanced application features like Task Scheduling, Caching, Queuing, Event Broadcasting, and more a breeze! -
Hashids.net
A small .NET package to generate YouTube-like hashes from one or many numbers. Use hashids when you do not want to expose your database ids to the user. -
-
Scientist.NET
A .NET library for carefully refactoring critical paths. It's a port of GitHub's Ruby Scientist library -
WorkflowEngine
WorkflowEngine.NET - component that adds workflow in your application. It can be fully integrated into your application, or be in the form of a specific service (such as a web service). -
HidLibrary
This library enables you to enumerate and communicate with Hid compatible USB devices in .NET. -
-
DeviceId
A simple library providing functionality to generate a 'device ID' that can be used to uniquely identify a computer. -
Warden
Define "health checks" for your applications, resources and infrastructure. Keep your Warden on the watch. -
Aeron.NET
Efficient reliable UDP unicast, UDP multicast, and IPC message transport - .NET port of Aeron -
ByteSize
ByteSize is a utility class that makes byte size representation in code easier by removing ambiguity of the value being represented. ByteSize is to bytes what System.TimeSpan is to time. -
-
-
Mediator.Net
A simple mediator for .Net for sending command, publishing event and request response with pipelines supported -
DeviceDetector.NET
The Universal Device Detection library will parse any User Agent and detect the browser, operating system, device used (desktop, tablet, mobile, tv, cars, console, etc.), brand and model. -
FormHelper
ASP.NET Core - Transform server-side validations to client-side without writing any javascript code. (Compatible with Fluent Validation) -
Valit
Valit is dead simple validation for .NET Core. No more if-statements all around your code. Write nice and clean fluent validators instead! -
https://github.com/minhhungit/ConsoleTableExt
A fluent library to print out a nicely formatted table in a console application C# -
SolidSoils4Arduino
C# .NET - Arduino library supporting simultaneous serial ASCII, Firmata and I2C communication -
Validot
Validot is a performance-first, compact library for advanced model validation. Using a simple declarative fluent interface, it efficiently handles classes, structs, nested members, collections, nullables, plus any relation or combination of them. It also supports translations, custom logic extensions with tests, and DI containers. -
Outcome.NET
Never write a result wrapper again! Outcome.NET is a simple, powerful helper for methods that return a value, but sometimes also need to return validation messages, warnings, or a success bit. -
NaturalSort.Extension
🔀 Extension method for StringComparison that adds support for natural sorting (e.g. "abc1", "abc2", "abc10" instead of "abc1", "abc10", "abc2"). -
SystemTextJson.JsonDiffPatch
High-performance, low-allocating JSON object diff and patch extension for System.Text.Json. Support generating patch document in RFC 6902 JSON Patch format. -
trybot
A transient fault handling framework including such resiliency solutions as Retry, Timeout, Fallback, Rate Limit and Circuit Breaker.
WorkOS - The modern identity platform for B2B SaaS
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.
Do you think we are missing an alternative of LINQPad.QueryPlanVisualizer or a related project?
README
LINQPad.QueryPlanVisualizer
[
](License.md)
SQL Server and PostgreSQL query execution plan visualizer for LINQPad
Features
- View query execution plan inside LINQPad
- View missing indexes for query
- Share plan to https://www.brentozar.com/pastetheplan/ or https://explain.dalibo.com/
- Create missing indexes directly from LINQPad
- Open plan in SQL Server Management Studio or another default app
- Save plan to disk
Supported databases: Sql Server and PostgreSQL.
Supported ORMs: Entity Framework Core 5 and LINQ to SQL
Getting Started
If you use LINQPad 6, you must use version 2.X of this library. For LINQPad 5, you must use version 1.X
Version 2.1 and newer uses Microsoft Edge WebView2 to display the query plan. This requires either WebView2 Runtime to be installed or a recent version of Edge Canary. To download WebView2 Runtime visit Microsoft Edge WebView2 Download Page.
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 for Sql Server:
[Sql Server query plan](screenshots/Query%20Plan.PNG "Query execution plan inside LINQPad")
Query execution plan for PostgreSQL:
[PostgreSQL query plan](screenshots/Postgres%20Query%20Plan.PNG "Query execution plan inside LINQPad")
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 visualizer will show a second tab with the missing index details and a button to create the index.
Missing index:
[missing indexes](screenshots/Missing%20Index.PNG "Missing index")
*Note that all licence references and agreements mentioned in the LINQPad.QueryPlanVisualizer README section above
are relevant to that project's source code only.