Should LINQ to SQL Go Open Source

Posted by Jonathan Allen on Jul 24, 2008

Community

.NET

Topics

Open Source ,

Data Access

Tags

LINQ ,

ADO.NET Entity Framework

More and more, LINQ to SQL is being seen as a temporary solution. With the impending release of ADO.NET Entity Framework, a lot of people are worried that development on LINQ to SQL will fall by the wayside. With Microsoft's long history of developing and discarding database access technologies, these concerns are not without merit.

Further compounding the issue is that LINQ to SQL has been transferred to the SQL Data Programmability team, the very same group working on ADO.NET Entity Framework. With their own project filling a similar role, it is hard to see them wanting to devote a lot of time to the adopted project.

So this raises the question, "Should LINQ to SQL Go Open Source?" Leon Bambrick asks that question and provides some analysis. One of the biggest concerns he raises is the liability issue, wherein Microsoft may be reluctant to ship something with the framework that has had external contributions. On the other hand, it might be what's needed to push through community-driven features such as mockability and multiple providers.

1. Back to top

   Not completly temporary

   Jul 24, 2008 8:17 AM by Francois Ward

   LINQ to SQL is for small to "less small" (not quite medium =P) solutions... half a notch up from Typed Datasets. LINQ to Entity doesn't replace that, and its with that mindset that LINQ to SQL was developed (also as an introduction to other ORMs, to put the idea on the map).
   
   LINQ to SQL serves its purpose pretty well seen from that angle, so its probably fine.

   Reply

2. Back to top

   LINQ to SQL was never even supposed to exist

   Jul 26, 2008 12:17 PM by Danijel Arsenovski

   It would be a shame if LINQ to SQL proves to be only a temporary solution; now that it has been officially released I think Microsoft has a duty to provide a decent lifecycle for this product.
   My biggest objections to LINQ to SQL are following:
   
   1. LINQ to SQL works only with Microsoft SQL Server
   
   2. LINQ to SQL is that it is no 100% POCO. Framework forces you to use System.Data.Linq.EntitySet type on "many" side of one-to-many relationship and EntityRef on the "one" side of one-to-many relationship.
   
   3. Single table inheritance
   
   These are not the only ones, but you have to give them some slack since this is the first version of the product.
   
   Some interesting background on LINQ to SQL origins:
   The LINQ to SQL was never even supposed to exist

   Reply

• Older >