My name is Edward Tanguay. I'm an American software and web developer living and working in Berlin, Germany.
5 hours ago: If you are a developer in Berlin and need to improve your English, I'm looking for groups to teach after work: http://tanguay.info/itenglish.
6 hours ago: As far as I'm concerned, the singularity is already here, every time I wake up twitter tells me something amazing was created while I slept.
6 hours ago: We're not suffering from information overload, we're suffering from faulty filtering.
6 hours ago: Classic literature for free as nicely formatted 1-page or 2-page PDF downloads: http://www.planetebook.com/free-ebooks.asp.
6 hours ago: Yes, when you pour coffee, "a lightning storm of neuronal activity occurs almost across the entire brain": http://is.gd/eWO1T @pholdings.
23 hours ago: If you put two spaces after a period or use underlining for emphasis, you were born before 1980.
23 hours ago: Word of the day: infovore, n. an animal with a voracious appetite for information.
yesterday: It's said that on average people use less than 10% of their brain, but I think on average computers use less than 1% of their CPU.
2 days ago: Saturday fun: team drawing on two computers with six-year-old in a shared google doc diagram.
2 days ago: Someday I want to produce a developer podcast called "What's that?" but for now "the developer's life" is a nice genre: http://is.gd/eTURO.
3 days ago: Here's a use-case for datapod format, recording human-readable data that later can be used as a datasource: http://is.gd/eSsLg @pholdings.

Categories

My Older Tutorials

My Old Web Dev Site

LINQ HOWTO created on Thursday, November 05, 2009 permalink
How to set up LINQPad to learn LINQ fast
LINQPad is one of those programs that produces an interactive learning experience beyond what any book or instructional video could do. This how-to shows how to set up everything you need to learn LINQ with LINQPad interactively just by trying out and playing with examples. The program is free and you can pay $19 for intellisense which enhances the learning experience considerably.
Download LINQPad 4.0
  1. Download LINQPad for .NET 4.0 here.
  2. When it is downloaded, double-click the .exe file, program will start.
Install the Northwind Database In LINQPad
  1. Go to Northwind database download page, execute the .msi file, next, next, next.
  2. In linqpad, "add connection", "attach database file", browse, C:SQL Server 2000 Sample Databases, NORTHWND.MDF, OK.
  3. Click on the Northwind link.
  4. click on C#Statements:
  5. type in these LINQ statements and press F5:
Use the Samples Provided:
  1. click on samples:
  2. clck on any of the samples and press F5:
Download More Samples:
  1. click on Download more samples:
  2. click the link:
  3. click on any of the book examples and press F5:
Add Your Own DLL:
  1. Open Visual C# Express 2010 which you can download here for free.
  2. new project, Class Library, "MyClasses":
  3. rename Class1.cs to VideoTutorials.cs:
  4. Replace with this code.
  5. File, Save All.
  6. Press F6 to build the .dll.
  7. In LINQPad, press CTRL-N to create a new query.
  8. Right-click query area and choose Advanced Query Properties.
  9. Click Add.
  10. click Browse:
  11. navigate to the dll file you just created and select it:
  12. Click OK.
  13. click on "Additional Namespace Imports":
  14. type in this query and press F5:
Purchase Intellisense
  1. intellisense enables you to "discover learn" much easier:
  2. it even gives you intellisense on your custom objects:
  3. You can purchase intellisense here for $19, I paid with Visa, was very easy and I could immediately type in my key and use intellisense.
Ask LINQ Questions On StackOverflow:
  1. Then experiment with all the samples and ask your questions on stackoverflow which for LINQ will usually get you numerous answers within 60 seconds.
 

Most Recently Added Items: