LINQPad Premium v9.7.13

Download LINQPad Premium v9.7.13

The .NET Programmer’s Playground:

Instantly test any C#/F#/VB snippet or program
Query databases in LINQ (or SQL) — SQL/Azure, Oracle, SQLite, Postgres & MySQL
Enjoy rich output formatting, autocompletion with AI and integrated debugging
Script and automate in your favorite .NET language, with all the benefits of a REPL
Interoperate with BenchmarkDotNet, xUnit, Rx, MSAL, Excel and more
Super lightweight — small and fast, with xcopy option
Standard edition free with no expiry

LINQPad is not just for LINQ queries, but any C#/F#/VB expression, statement block or program. Put an end to those hundreds of Visual Studio Console projects cluttering your source folder and join the revolution of LINQPad scripters and incremental developers.

Reference your own assemblies and NuGet packages. Prototype your ideas in LINQPad and then paste working code into Visual Studio. Or call your scripts directly from the command-line.

Want to test a variation of your script? Clone your query in a single keystroke!

Experience LINQPad’s rich output formatting, optional debugger and autocompletion, and the magic of dynamic development and instant feedback!

With LINQPad, you can interactively query databases directly in LINQ (as well as SQL). The big win with LINQ is having association properties automatically generated for all relationships (inferred from foreign key constraints), so you can access related rows without joining! LINQPad uses a custom high-performance scaffolding engine behind the scenes, and includes drivers for SQL Server, SQL Azure, Oracle, SQLite, PostgreSQL and MySQL.

When dumped, association properties appear as lazy hyperlinks that can be expanded just by clicking on them. You can walk your entire database interactively!

LINQPad’s Dump method is famous for its capacity to eat almost anything!

Tuned with numerous heuristics, it intelligently walks object graphs for the best possible output. It even turns lazy objects into hyperlinks and asynchronous values into placeholders whose content materializes in the future!

Images and bitmaps render as images and bitmaps, and types from Reactive Extensions and Dataflow fully animate.

Dump any WPF or Windows Forms object and it will actually render.

Call the .Chart extension method to output data as a chart, using LINQPad's inbuilt charting engine.

And when you need a traditional data grid or debugger watch window, it’s there, too.

With its support for advanced C# features such as async / await and unsafe, LINQPad is capable of serious rapid coding work.

Such as writing a neural network from scratch!

Import other queries or .cs files with the #load directive.

Reference project assemblies from your Visual Studio solution, and use LINQPad as an interactive test harness. Or use LINQPad to provide instant entry points into any part of your solution.

Use LINQPad for build scripts and to automate cloud management tasks. LINQPad includes an integrated password manager for securely storing API keys, and a MSAL/OAuth frontend for multifactor authentication that preserves tokens across executions.

Step through your code with a lightweight debugger, and move around quickly with symbol navigation, outlining and bookmarking.

LINQPad is also a great way to learn C#: it comes with all 1300 examples from the book, C# 12 in a Nutshell, as well as interactive samples from Jon Skeet's C# in Depth.

A .NET Swiss Army Knife
Ever needed to benchmark your code? Now you can do so with a single keypress! LINQPad uses the industrial-grade BenchmarkDotNet for accurate results, which it presents via a customizable graphic real-time visualizer. No more writing boilerplate setup code, and no more digging through text-based logs!

Need to write a regular expression? Press Ctrl+Shift+F1 and an interactive RegEx Evaluator will appear! This is actually implemented entirely as a LINQPad query that uses LINQPad's HTML controls. You can make changes to this query, or use it as as template for writing your own interactive queries.

Need to generate Excel files? LINQPad includes a custom high-speed Excel export engine that generates native .xlsx files with AutoFilter and Tables — in a single line of code. There are also options for creating multi-sheet workbooks and you can even populate a spreadsheet cell-by-cell:

LINQPad is Easy to Learn
LINQPad comes with an integrated tutorial/reference, comprising interactive sample queries. Browse through the tree or press Ctrl+F1 to search — you'll find a sample that demonstrates just about every feature and application of LINQPad.

9.7

New Features: AI

(Beta) LINQPad can now utilize your GitHub Copilot subscription. This means you no longer need a BYO key or OpenRouter account to use LINQPad's AI features. To enable, go to AI Settings and click Add Provider.
Opus 4.6, Sonnet 4.6 and GPT 5.4 are now fully supported. For OpenRouter users, Sonnet 4.6 is now the default for chat and the coding agent and Gemini Flash-Lite 3.1 is the default for automatic completion.
You can now give the AI coding agent instructions such as this:
```
Write an interactive front-end for this database
```
and it will write code that makes full use of LINQPad's HTML controls. For more general questions such as Explain OKLCH color, it will script an interactive explanation with diagrams and demos. It's also able to wrap any popular jаvascript library. For example, you can ask it to Wrap the vis.js library or Draw a 3D torus or Display my location on a map, and the agent will write a class that imports the appropriate assets and bridges the gap between C# and jаvascript.

New Features: Other

LINQPad's charting API (Util.Chart) is now available on macOS. Charts render inline via the Apache ECharts.js library.
Under Windows, LINQPad will render charts with the same modern back-end if you call .DumpInline() instead of .Dump() on the chart, or if you call .ToEChart().Dump().
LINQPad now includes an EChart class in LINQPad.Controls that wraps the ECharts.js library. This works at a lower level than Util.Chart, allowing a greater range of charts, dynamic updates, interactivity and export to SVG. The easiest way to populate this control directly is to ask LINQPad's AI Agent to write the code for you (Ctrl+I or Command-I) - it knows everything about both the EChart wrapper and the underlying ECharts.js data schema. Alternatively, press Ctrl+F1 and search for EChart to view samples. Here's an example of what it can produce:
LINQPad includes the following new HTML controls:
- FlexBox for easily aligning elements
- TabControl for organizing content
- MarkdownViewer for displaying markdown
- LatexViewer for displaying formulae and technical content (using katex.js)
There's also a Util.Latex method (this is a just shortcut for instantiating a LatexViewer):
```
Util.Latex(@"\int_0^\infty e^{-x^2} dx").Dump();
```
Output:
$\int_{0}^{\infty} e^{- x^{2}} d x = \frac{\sqrt{π}}{2}$ ∫0∞e−x2dx=2π
For a demo, press Ctrl+F1.
LINQPad's HTML controls are now faster, more robust and better documented in the inbuilt samples.
DumpContainer now has a DumpOptions property, allowing you to apply options at any place in the object graph. You can also make a type always dump only 1 level deep by defining a ToDump method inside the type that does this:
```
class Foo
{
    ...
    object ToDump() => new DumpContainer (this, options => options.MaxDepth = 1);
}
```
LINQPad's Dataflow visualizer now works on macOS. Just Dump a DataFlow block to see a live visualization.
You can now right-click on SQL scalar functions in the Schema Explorer for a context menu to call the function or edit its definition.
The namespaces tab of the the Script Properties dialog now includes a Pick from Assemblies button.
You can now customize the light-theme editor background color in Settings.
Markdown files are now supported in the editor with syntax highlighting.
The editor tooltip delay is now configurable in Settings.
The Windows Taskbar icon now indicates when a script is running.