Should Linq To Sql Go "Open Source"?
secretGeek .:dot Nuts about dot Net:.
home .: about .: sign up .: sitemap .: secretGeek RSS

Should Linq To Sql Go "Open Source"?

Linq to Sql started life as:

" ...a humble Visual Studio project on my desktop machine way back in the fall of 2003..."
Matt Warren

It only reached production when ObjectSpaces failed to ship with VS2005 (it took a dependency on the ill-fated WinFS).

In November 2007, ownership of Linq 2 Sql was transferred from the C# team to the SQL Data Programmability team.

And now, microsoft are finally poised to release their long-anticipated ADO.Net Entity Framework (aka, 'EF').

Maintaining both EF and L2S involves some clear conflicts of interest.

So, here's a brief Edward De Bono style "Plus/Minus/Interesting" analysis of the question:

'should Linq to sql go open source?'

Plus:

  • It could get a lot of people working on it.
  • Features could be added based directly on community need, eg.
    • mockability
    • multiple providers
    • ability to refresh portions of the model without refreshing the entire thing.
    • ...and other alleged showstoppers

Minus:

  • If it doesn't get many contributions, then it could effectively kill the product, as it would be hard to move it back in-house.
  • It would probably become impossible to ship it as part of the framework, due to liability concerns.
  • Open Source is Communism ;-). (ah, kidding)

Interesting:

  • It could represent a hedge-bet / fallback position in case Entity Framework doesn't take off. (EF is pretty big and i'm a little worried that it won't take off).
  • With or without it being open sourced, the community (that's us!) can create awesome third party products, add-ons and scary work arounds to extend or test linq to sql

What are the chances?





'prole' on Sat, 21 Jun 2008 12:07:36 GMT, sez:

Have an open source edition, at codeplex.

and then have an internal version too, with a difference license, so it can be installed into companies that don't accept open source.

that's what Mysql do!

Linq To Sql is brilliant and we have poured everything into it. there are limiting factors and Microsoft will not fix them!

So we are caught out, just like we were with Remoting!



'barryd' on Sat, 21 Jun 2008 12:28:41 GMT, sez:

The problem will be assignment of copyright; in order for it work patches and contributions would have to have their copyright assigned to MS. MS would have to idemnify. Very messy.



'John Rusk' on Sat, 21 Jun 2008 19:09:43 GMT, sez:

I think it probably shouldn't go open source actually. Right now I think we have two viable paths to LINQ-style ORM work:

(a) Use LINQ-to-SQL. I've been using it all year, and it's not as bad as the critics suggest. I should add that we're deliberately not attempting multi-tier work with it. For single-tier (i.e. in our ASP.NET web server) it is working well. Yes, we have had to do some work arounds. But we're happy with them. Our testability workaround, for instance, is based on "fakes" rather than "mocks" and it works very well. It's not nearly as scary as one you link to. All in all, I'm pleased with LINQ-to-SQL.

(b) If you want more advanced solutions (including cross-database support) look at Lightspeed, LLBLGen Pro or any of the other ORMs which do (or soon will) offer a LINQ query API.

I think we'll see on-going community effort in (b), and to a lesser extent in community-authored addons for (a). Microsoft's product doesn't have to be all things to all people; they have already given us the great LINQ-style query API, so competing products can offer their capabilities throgh the same langauge-integrated API.

Rather than trying to make LINQ-to-SQL open source, I think it's better for the community to have an "out of the box" ORM from Microsoft (even if it's limited) plus a good selection of commercial and open source alternatives.

Check out MindScape LightSpeed if you haven't already - it's a good example of the kind of alternative I'm talking about.



'Jason' on Mon, 23 Jun 2008 03:45:55 GMT, sez:

LLBLGen Pro ftw!!

That is one awesome tool.

I have not used Mindscape Lightspeed tho'



'David' on Tue, 24 Jun 2008 01:30:07 GMT, sez:

Another product to look at is EntitySpaces. This is a Linq style entity model that is generated directly out of the database schema, and works with about 7 different databases using .NET 2.0



'lb' on Fri, 27 Jun 2008 04:30:30 GMT, sez:

I've heard about Entity Spaces quite a bit, and toyed with some of its earlier incarnations.

MindScape lightspeed sounds good.

Just cooking up a new little project that will perhaps use JQuery with WCF for the front end and api -- and i was thinking of using Linq2Sql for the back end translation.

Appreciate the feedback.

lb



'Frans Bouma' on Thu, 24 Jul 2008 13:09:00 GMT, sez:

I don't see that they'll open source Linq to Sql, simply because there's nothing to gain from it from MS' perspective. It's part of the .NET framework now, and therefore it can't be removed nor changed that much.

Personally, I think MS will wait with deciding what to do with Linq to Sql till EF has been released and it's clear if it is going to fly or not.



'Kristofer' on Wed, 30 Jul 2008 08:18:14 GMT, sez:

If you want to add the "ability to refresh portions of the model without refreshing the entire thing" to visual studio without waiting, I have written an add-in for that. Take a look at http://www.huagati.com/dbmltools/



'lb' on Wed, 30 Jul 2008 09:07:21 GMT, sez:

@Kristofer, re:'I have written an add-in for that'

Excellent!




name


website (optional)


enter the word:
 

comment (HTML not allowed)


All viewpoints welcome. But the right to delete any post for any reason is reserved. Don't make me do it. Comments may be republished, emailed to your loved ones or printed and used as toilet paper. Who reads this legal bit anyhow?

TimeSnapper is a life analysis system that stores and plays-back your computer use. It makes timesheet recording a breeze, helps you recover lost work and shows you how to sharpen your act.

TimeSnapper won last year's Developer Competition at Larkware.com, and is used by over 10,000 people.

Articles

The Bluffer's Guide To Yegge: Business Requirements R Bullsh*t The Bluffer's Guide To Yegge: Business Requirements R Bullsh*t
Prototype Ready for Launch Prototype Ready for Launch
Idea: a poor man's eye-tracking heatmap for win forms Idea: a poor man's eye-tracking heatmap for win forms
'The Register' seems to have plagiarised Mary Jo Foley 'The Register' seems to have plagiarised Mary Jo Foley
A magic goal for software businesses A magic goal for software businesses
A to Z of Software Methodologies A to Z of Software Methodologies
TimeSnapper in Music! TimeSnapper in Music!
Fixing problems can give you a glimpse of something terrible Fixing problems can give you a glimpse of something terrible
Web Tablet: Toward Less Complexity Web Tablet: Toward Less Complexity
Do they store the code for TFS in TFS? Do they store the code for TFS in TFS?
Sudden TimeSnapper Discount! Sudden TimeSnapper Discount!
How Can Microsoft Beat Google? How Can Microsoft Beat Google?
TimeSnapper 3.1: Attack of the the Red/Green Stripes TimeSnapper 3.1: Attack of the the Red/Green Stripes
21 tools used in our MicroISV 21 tools used in our MicroISV
Lost Treasures of the DOS World: tree! Lost Treasures of the DOS World: tree!
The Virtual Machine Machine and the Virtual Virtual Machine The Virtual Machine Machine and the Virtual Virtual Machine
Should Linq To Sql Go Should Linq To Sql Go "Open Source"?
Redux: New Synchronisation Idea Overlooked By Microsoft Redux: New Synchronisation Idea Overlooked By Microsoft
New Synchronisation Idea Overlooked By Microsoft Live team New Synchronisation Idea Overlooked By Microsoft Live team
Visual Studio UX Taskforce, Office UX Taskforce... etc. Visual Studio UX Taskforce, Office UX Taskforce... etc.
How to be Jeff Atwood How to be Jeff Atwood

Archives .: secretGeek :: Complete Archives :.
25 steps for building a Micro-ISV 25 steps for building a Micro-ISV
3 minute guides -- babysteps in new technologies: powershell, JSON, watir, F# 3 Minute Guide Series
Top 10 SecretGeek articles Top 10 SecretGeek articles

Downloads

TimeSnapper -- Automated Screenshot Journal TimeSnapper.com    
Version 3.1: instant productivity profiles

ShinyPower (help with Powershell) ShinyPower
Now at CodePlex

Next Action NextAction
Managing the top of your mind



[powered by Google] 


World's Simplest Code Generator (html edition) World's Simplest Code Generator
Gradient Maker -- a tool for making background images that blend from one colour to another. Forget photoshop, this is the bomb. Gradient Maker
How to be depressed How to be depressed
You are not inadequate.



Recommended Reading

The Best Software Writing I
The Business Of Software (Eric Sink)

Recommended blogs

Jeff Atwood
Reginald Braithwaite
Joseph Cooney
Phil Haack
Scott Hanselman
Julia Lerman
Joel Pobar
Eric Sink
Joel Spolsky
Des Traynor

Aggregated Links

programming.reddit.com
dzone
dot net kicks

Human Link Machines

interesting finds
a continuous learner's weblog
arjan's world
n links today
new and notable
morning coffee
learning .net
weekly link post
(my del.icio.us account)

LinkedIn profile
 
home .: about .: sign up .: sitemap .: secretGeek RSS .: © Leon Bambrick 2006 .: privacy

home .: about .: sign up .: sitemap .: RSS .: © Leon Bambrick 2006 .: privacy