LINQPad

LINQPad

Scratchpad for .NET and databases

Description

To try a snippet of C# you open Visual Studio and create a console project; to check a table you switch to SSMS and write SQL. Two small tasks, two heavyweight tools.

LINQPad is a .NET scratchpad: connect a database on the left, write the query in C# LINQ on the right, press F5, and related objects in the result grid expand with a click. Any query translates to SQL or method syntax on demand so you can see how it really runs. Without a database it is an instant C#/F#/VB runner — write, run, and Dump() visualises any object.

It supports SQL Server, Azure, Oracle, SQLite, PostgreSQL and MySQL, and references NuGet packages directly. The free edition is enough for daily work; paid editions add autocompletion and more. Recent versions include an AI assistant that edits code from instructions.

Features



Query databases with LINQ: C# expressions or statements against the database, results in an expandable grid.

SQL and method-syntax translation: one click shows the generated SQL or rewrites the query as a method chain.

Instant C#/F#/VB: run code fragments without a project; Dump() visualises anything.

Many databases: SQL Server, Azure SQL, Oracle, SQLite, Postgres, MySQL.

NuGet and scripts: reference NuGet packages directly, save scripts for reuse, run them from the command line.

Export: results to Excel, Word or HTML.