LINQPad

 

LINQPad

The .NET Programmer’s Playground

• Instantly test any C#/F#/VB snippet or program
• Query databases in LINQ (or SQL) — SQL/CE/Azure, Oracle, SQLite & MySQL
• Enjoy rich output formatting, optional autocompletion and integrated debugging
• Script and automate in your favorite .NET language
• Super lightweight — single 15MB executable!
• Standard edition free, with no expiry

The Ultimate Scratchpad for C#, F# and VB

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.

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

Tired of Querying in Antiquated SQL?

Well, you don’t have to! With LINQPad, you can interactively query databases in a modern query language: LINQ. LINQPad includes an optimized engine to build typed data contexts on the fly, and includes drivers and formatters for:

• SQL Server, SQL Azure, SQL CE, Oracle, SQLite and MySQL
• Azure Table Storage & Azure Metadata
• OData / WCF Data Services, SharePoint, and Windows DataMarket
• Microsoft’s StreamInsight, ubercool Reactive Extensions and LINQ to Logs & Traces
• Third-party ORMs including Mindscape LightSpeed, DevArt’s LinqConnect, LLBLGen, DevExpress eXpress Persistent Objects and DevForce

LINQPad also supports all the LINQ APIs in the .NET Framework, including LINQ to XML, PLINQ, LINQ to SQL and Entity Framework.

And when you need to, you can still query in good old-fashioned SQL — even if your back-end is SQLite, Oracle or MySQL. Without any heavy installations or oppressive EULAs!

LINQPad is also a great way to learn LINQ: it comes loaded with 500 examples from the book, C# 7.0 in a Nutshell. There’s no better way to experience the coolness of LINQ and functional programming.

Experience the Legendary Dump!

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.

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

	EDITION
	PRO	DEVELOPER	PREMIUM
Run LINQ queries - or any C#/VB/F# expression/program	√	√	√
Results to rich text or data grids	√	√	√
Automatic translation to SQL, fluent-lambda and IL	√	√	√
Reference your own assemblies, plus the entire .NET Framework	√	√	√
Use custom extensions, visualizers and data source providers	√	√	√
Full C#/F#/VB autocompletion and tooltips	√	√	√
Smart tags for importing additional namespaces/references (C#/VB)	√	√	√
Code outlining and auto-formatting (C#/VB)	√	√	√
Rename symbol, go to definition and find references (C#/VB)	√	√	√
Built-in and custom code snippets		√	√
Cross-database querying for SQL Server		√	√
Directly edit SQL data in grids and save changes back to database		√	√
Full NuGet integration		√	√
Integrated debugger, with call stack, threads, local variables/watch windows, breakpoints and single-stepping			√

Unlock the Power of the Programmer’s Playground

LINQPad's autocompletion includes everything that you depend on:

• Member lists & completion, with list filtering and "camel humps"
• Parameter listing
• Quick info
• Code outlining
• Smart tags for importing additional namespaces and references (C#/VB)
• Automatic code formatting (C#/VB)

Autocompletion works not only with LINQ queries, but with the entire C#/F#/VB language.

LINQPad’s unique Power-Tick lets you select multiple properties, when creating anonymous types in C# or VB, without closing the popup. This is a massive time-saver.

When you enter an unresolved type, LINQPad instantly scans the .NET framework and offers a smart tag to add the namespace and assembly reference. And you don’t even have to get the casing correct! So, if you type protecteddata, LINQPad’s smart tag will import the System.Security.Crytopgraphy namespace, add a reference to System.Security.dll, and correct the case.

The Developer and Premium editions also enable your favorite Visual Studio C#/VB code snippets, plus a dozen unique high-productivity LINQ snippets - as well as any custom snippets that you define.

The Developer/Premium editions also unlock NuGet integration, so you can effortlessly reference anything in the entire NuGet library, and the ability to write cross-database queries - just control+drag additional databases from the Schema Explorer onto your query!

And these editions also let you open SQL tables for editing, saving changes back to the database.

And with a premium license, unlock an integrated lightweight debugger. Single-step through your scripts, set breakpoints, and examine local variables! The debugger works with all CLR languages: C#, VB and F#.