LINQPad is Totally Awesome at Testing and Writing LINQ Queries

http://www.linqpad.net/ – 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.

 

image

 

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 since 2007. In addition, he's a multi-course video author at Pluralsight. 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:


Comments

  1. linqpad.net 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. http://designs-nail-art.com/ says:

    Lingpad is good Nail Art designs

  4. http://designs-nail-art.com/ 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

Trackbacks

  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:  http://peterkellner.net/2008/09/20/linqpad-sqlserver-linq-interpreter-nutshell/ […]

Follow

Get every new post delivered to your Inbox

Join other followers: