[dba-VB] LINQ example (was: C# - Direct data manipulation)

Gustav Brock Gustav at cactus.dk
Fri Dec 4 04:08:03 CST 2009

Hi John et all

Further to the notes below on Joseph Albahari's LINQPad, it contains a link to download all the example code from "LINQ in Action".
Also, it has a link to this amazing demo of the power of LINQ:


It's a true eye-opener and a good example showing that the scope of LINQ is much wider than "normal" database querying.

The code is included in LINQPad when downloaded, ready for you to play with at:

  Tab Samples, 
  C# 3.0 in a Nutshell, Chapter 9 - LINQ Operators, Joining, Extra - Weights Puzzle. 

It's Friday and soon weekend!


>>> Gustav at cactus.dk 04-12-2009 09:48 >>>
Hi John

Yes and no. I used an old version for some time but the current version is more powerful.

Please note that it comes with all the examples from his book, and even without the book this is a great why to get your hands on LINQ as the code is "live" - no need to copy and paste, it is right there for you try out at once.


>>> jwcolby at colbyconsulting.com 02-12-2009 19:46 >>>
Do you use it?

John W. Colby

Gustav Brock wrote:
> Hi John et al
> Don't forget LINQPad.
> Why LINQ beats SQL:
> http://www.linqpad.net/WhyLINQBeatsSQL.aspx 
> /gustav
>>>> Gustav at cactus.dk 02-12-2009 08:19 >>>
> Hi John
> As I see it, that would be LINQ and ADO.NET EF (Entity Framework). Not that I have used these in a scenario even "remotely close" to yours, but the fine thing is that is performs all the plumbing behind the scene - generates the SQL for you. Critics tell that this SQL could be long-winded (= not optimized) but what do I care? If it flips 17 or 87 switches does nothing to me as long as the result is fast and precise.
> ADO.NET EF is an amazing piece of work. It is not mature but if MS continues to evolve it with the same speed as Silverlight I'm sure it will catch up.
> /gustav

More information about the dba-VB mailing list