software solutions / project leadership / agile coaching and training

LINQ to SQL is NOT dead!

Posted on June 6, 2009

Ever since Microsoft announced that the Entity Framework was their ORM of choice, people everywhere have been saying, “LINQ to SQL is dead!” A lot of people feel like they’re not allowed to use LINQ to SQL anymore and that they have to use Entity Framework instead.

In fact, LINQ to SQL is not only alive and well, Microsoft has even announced LINQ to SQL improvements in .NET 4.0, including finally adding using ITable<T> for tables instead of Table<T>, which makes it much easier to test. Combine that with this open source tool that will create an IDataContext interface for you and you’re on your way to testable LINQ to SQL. So no, LINQ to SQL is not dead!!

Look, just because Microsoft says you should do something a certain way doesn’t mean that you have to do everything that they say. For example, Microsoft will almost never recommend using an open source software package over something that they’ve built (I say almost never because I’m sure they’ve done it at some point, but I’ve never seen it done). That certainly doesn’t mean that the Microsoft product is better than every open source tool.

For example, if you’re going to use an ORM, LINQ to SQL can get the job done for you, but if you’re looking for an ORM with more features, you owe it to yourself to check out Fluent NHibernate.


  1. LINQ to SQL is NOT dead!…

    You’ve been kicked (a good thing) – Trackback from… — June 6, 2009 @ 9:50 pm

  2. But from your point of view, why they are announcing that? they want to kill linq to sql? or what i can’t understand microsoft in this point

    amr elgarhy — June 7, 2009 @ 3:31 pm

  3. @amr,

    I don’t think that MS thinks that LINQ to SQL sucks or anything like that, it’s just that they’ve chosen to promote Entity Framework and they’re not going to add big features (like many-to-many mapping table support) to LINQ to SQL. The problem is that EF v1 is (IMO) not as good as LINQ to SQL or NHibernate or most other ORMs and it’s not really a good choice at this point (haven’t seen enough of EF v2 yet to make a judgment on it).

    Jon Kruger — June 7, 2009 @ 9:56 pm

  4. Umm, they’re adding a few TINY improvements, and they’re leaving massive gaping holes in the implementation. When we say that Linq to SQL is dead, what we mean is that MS are not doing any significant development on it.

    Sure, they’re fixing some of the more egregious issues, but they are deliberately crippling Linq to SQL in favour of that piece of crud EF.

    Sean Hederman — June 8, 2009 @ 2:23 am

  5. Linq to SQL is dead. Deal with it. Move on.
    Not on the next .NET version (requires v4!!!) which is impossible to set in production environment within a year (mono support, anyone?) but to another ORM mapper.

    Thank God there are so many to choose from these days, Lightspeed is nice example (check David Hayden’s blog, lots of info why it beats the shit out of L2S).

    Linq to Entities v4 looks promissing but they didn’t get it really right (many gotchas, check blogs…) and their idea of Domain Driven Design of dragging tables to a “DDD visualizer” and using POCOs is laughable…

    when will they understand that in DDD you start with entities/value objects/specific types not your tables, argh…

    cowgaR — June 8, 2009 @ 6:19 am

  6. Link-to-SQL is NOT Dead…it’s just slow. :P

    Our Republic

    Micah Burnett — June 8, 2009 @ 8:38 am

  7. Jon Kruger’s Blog » LINQ to SQL is NOT dead!…

    DotNetBurner – burning hot .net content…

    DotNetBurner - Linq To SQL — June 8, 2009 @ 8:47 am

  8. I think my point here is that while MS would like to deprecate LINQ to SQL, I don’t feel like their replacement (Entity Framework) is as usable at this point. (Neither L2S or EF can touch Fluent NHibernate though.)

    Jon Kruger — June 8, 2009 @ 9:22 am

  9. Jon Kruger’s Blog » LINQ to SQL is NOT dead!…

    Thank you for submitting this cool story – Trackback from… — June 8, 2009 @ 12:45 pm

  10. I hate LINQ to SQL and honestly it is limited and it sucks and no control over final SQL and it is slow as hell compared to SQLCommands especially if you convert output of LINQ to SQL to datatable. Bottom line it is utter crap.

    I still prefer doing SQLCommands or Stored Procedures, only way to go. LINQ to SQL is made for people who suck at programming.

    Red Star — November 29, 2011 @ 10:47 am

Leave a comment

I have over 15 years of software development experience on several different platforms (.NET, Ruby, JavaScript, SQL Server, and more). I recognize that software is expensive, so I'm always trying to find ways to speed up the software development process, but at the same time remembering that high quality is essential to building software that stands the test of time.
I have experience leading and architecting large Agile software projects and coordinating all aspects of a project's lifecycle. Whether you're looking for technical expertise or someone to lead all aspects of an Agile project, I have proven experience from multiple projects in different environments that can help make your project a success.
Every team and every situation is different, and I believe that processes and tools should be applied with common sense. I've spent the last 10+ years working on projects using Agile and Lean concepts in many different environments, both in leadership roles and as a practitioner doing the work. I can help you develop a process that works best in your organization, not just apply a prescriptive process.
Have any questions? Contact me for more information.
From Stir Trek 2017
Iteration Management - Your Key to Predictable Delivery
From Stir Trek 2016 and QA or the Highway 2015
From CodeMash 2016, QA or the Highway 2014, Stir Trek 2012
The Business of You: 10 Steps For Running Your Career Like a Business
From CodeMash 2015, Stir Trek 2014, CONDG 2012
From Stir Trek 2013, DogFoodCon 2013
(presented with Brandon Childers, Chris Hoover, Laurel Odronic, and Lan Bloch from IGS Energy) from Path to Agility 2012
From CodeMash 2012 and 2013
(presented with Paul Bahler and Kevin Chivington from IGS Energy)
From CodeMash 2011
An idea of how to make JavaScript testable, presented at Stir Trek 2011. The world of JavaScript frameworks has changed greatly since then, but I still agree with the concepts.
A description of how test-driven development works along with some hands-on examples.
From CodeMash 2010
From CodeMash 2010