LINQPad is Totally Awesome at Testing and Writing LINQ Queries – Use with Microsoft .Net for building Query type expressions with LINQ

I’m not a wizard at writing LINQ expressions so I often find myself in Google looking for something similar to what I want, then I put it into my application and run it. This has worked pretty well, but it takes a couple iterations to get it right. It occured to me that someone probably has written a LINQ interpreter so I just guessed the name, LINQPad, typed it into search, and I find the authors of the book C# 3.0 in a nutshell, Joseph Albahari and Ben Albahari, (which I like a lot) have written it.

I download it (it’s an exe file), run it (OK, I trust you guys somehow), and presto, I get a very nice interface that not only has tons of examples built into it with a nice tree view, but lets me make a connection to my database and run LINQ queries against it. It even cancels them when you create one that will run forever (very nice guys!).

So, the query I was going after is I have a huge list of cities that includes states. From that, I just want a unique list of states (this list does not have all the states so I want just the ones contained in it). Below is a screen shot of the LINQPad with my Query in it. I simply pressed the green triangle (trained by Sql Server Enterprise Manager), and presto, my list! Could not be much easier. This tool will be in my box for a long time.




Grab this now!  It’s a winner, believe me.

About Peter Kellner

Peter is a software professional specializing in mobile and web technologies. He has also been a Microsoft MVP for the past 7 years. To read more about Peter Kellner and his experience click here. For information about how Peter Kellner might be able to help you with your project click here.

Follow me:


  1. is a good and useful source. I use it a lot.

  2. nursing journals online says:

    I tested this out christian youth group activities <a href="http://mechanicalengineeringinternships&quot;best mechanical engineering internships. It is really nice and has a great interface.

  3. says:

    Lingpad is good Nail Art designs

  4. says:

    Lingpad is good

  5. Nail Art designs says:

    Linqpad is good thing for us.

  6. Been using LinqPad for last few days, good tool but going take a little time to fully learn. Google is my friend in the learning stages.

  7. Chad Larson says:

    I have been using LinqPad for several months now and recently upgraded to the intellisense for a mere $17. It is great! I love LinqPad.

  8. yeah, very good tool. using it for last few months


  1. […] Today, I discovered you can actually put c# right into the editor!  I’m attaching a screen shot of how it helped me solve a simple LINQ command that involved an integer list.  I reviewed it in a little more detail on a previous post here: […]


Get every new post delivered to your Inbox

Join other followers: