Should Linq To Sql Go "Open Source"?

'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_{Know thyself!}

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.