Questions tagged [linqpad]

A lightweight code scratchpad for C#/F#/VB and database querying tool that supports both SQL and LINQ. Written by Joe Albahari.

LINQPad can be downloaded free from http://www.linqpad.net. Its main features are:

  • Runs code snippets in C#, VB.NET and F#, for .NET 3.5, 4.0, 4.5 and 4.6.
  • Executes queries on databases and other sources directly in LINQ (or SQL).
  • Explicit support for popular APIs such as LINQ-to-SQL, Entity Framework and OData, and databases such as SQL/Azure, SQLite, MySQL, Oracle and PostgreSQL.
  • Allows referencing custom assemblies and NuGet packages.
  • Built-in "object dumper" to facilitate easy experimentation. Recognizes and specially formats output from popular APIs such as Reactive Extensions.
  • Command-line support for automating scripts.
  • Built-in autocompletion and debugging (license purchase required).

LINQPad is popular for testing C# snippets. It also has built-in samples to help with learning LINQ.

Another program similiar to linqpad is You even can query stackoverflow using linqpad

1017 questions
11
votes
1 answer

Why does Reactive Extensions send a HTTP GET to microsoft ON COMPILATION?

I downloaded the Stable release of Reactive Extensions v1.0 SP1 from this site http://msdn.microsoft.com/en-us/data/gg577610, and I am using it in a .Net Framework 3.5 environment (Visual Studio 2008) I tried using Reactive Extensions in a project,…
Matt G
  • 437
  • 3
  • 9
10
votes
1 answer

Using C# 5 async feature in Linqpad

Is it possible to use C# 5 async features in Linqpad snippets? Does anyone know of any hack/beta which allows you to do it?
user198552
  • 431
  • 4
  • 15
10
votes
1 answer

Can LinqPad connect to an mdf file?

Can LinqPad query from a loose mdf file? How would it happen? (Joe Albahari, are you out there?)
Rap
  • 6,851
  • 3
  • 50
  • 88
10
votes
1 answer

Linqpad running custom code before each query

I almost ran a query i did not want to against a production db today. As such i would like to check before all my queries that this.Connection.DataSource is not my production database... and if it is then show a messagebox warning me. Is this…
4imble
  • 13,979
  • 15
  • 70
  • 125
10
votes
2 answers

How to delete a db row in LINQPAD

Total NOOB question. I have been using the new linqpad for about 20 minutes now. Great! But now i want to delete a row in the db. I am using a EF5.0 connection. I cant seem to find anything in the help files or on the net. The only thing I can find…
Greg
  • 2,654
  • 3
  • 36
  • 59
10
votes
1 answer

How does Visual Studio's debugger/interactive window dump the properties of COM Objects in .NET?

In this related question, I noted that Visual Studio's debugger is able to enumerate the properties of System.__ComObject references, which is "a hidden type used when the wrapper type is ambiguous" -- e.g., the type of object you get when you…
blah238
  • 1,796
  • 2
  • 18
  • 51
10
votes
1 answer

Rollback Inserts/Updates/Deletes in linq pad?

I found this article about how to insert, update and delete using linq pad but it mentions nothing about rolling back anything. Is it possible to rollback in linqpad?
chobo2
  • 83,322
  • 195
  • 530
  • 832
9
votes
1 answer

Is there an existing SqlConnection that I can use in LinqPad?

I am trying to test out some Dapper stuff using LinqPad. Dapper needs a SqlConnection (IDbConnection really) to work. I could construct my own in the code window, but I thought if LinqPad already had made one, I would just use that. Does LinqPad…
Vaccano
  • 78,325
  • 149
  • 468
  • 850
9
votes
2 answers

LinqPad adds an S to the end of every table

I have just downloaded LinqPad to explore the benefits of using Linq queries in an application I am working on, however when I look at my database tables in the column on the left LinqPad displays all my tables with an 's' on the end, for instance…
Purplegoldfish
  • 5,268
  • 9
  • 39
  • 59
9
votes
3 answers

LINQPad - can you run a linqpad script from the command-line?

Is there a way to run a LINQPad script from the command-prompt (no gui)? If so, LINQPad would be handy for scripting C# and calling it from an automated build.
Greg
  • 211
  • 3
  • 6
9
votes
1 answer

Is it possible to use LinqPad with a code-first model

In the past It's been easy to set a connection in LinqPad to a custom assembly that had EF model. Linqpad looks for a that is based on System.Data.Objects.ObjectContext which doesn't exist How (if at all) does one make their model assembly…
Ralph Shillington
  • 20,718
  • 23
  • 91
  • 154
9
votes
6 answers

In LINQPad can you access SYSOBJECTS using LINQ?

In LINQPad is there any way to access either the SYSOBJECTS table or the various INFORMATION_SCHEMA.xxx views using LINQ? I spend a lot of time searching through our huge company database for partial names as there are too many tables and Stored…
Xanthalas
  • 197
  • 2
  • 6
9
votes
2 answers

LinqPad access to internals of signed assemblies

Is there a signed version of LinqPad that I could use in order to access internals of signed assemblies?
Joao Silva
  • 876
  • 2
  • 8
  • 18
9
votes
3 answers

How can I get the connection string for an SQL Express database listed in LINQPad?

Is there an easy way to get the connection string of a database listed in the connection window of LINQPad (other than using the object explorer of Visual Studio)?
tuncalik
  • 1,124
  • 1
  • 14
  • 20
9
votes
3 answers

Uri.EscapeUriString with square braces

Something of a strange question but let's see what kind of response it gets... If I code a console app (VS 2013, .NET 4.5.1) and execute this line of code: Uri.EscapeUriString("[") I get this: [ However if I execute the same thing (well, technically…
Levi Botelho
  • 24,626
  • 5
  • 61
  • 96