THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Updateable LINQ

Bart de Smet wrote a very interesting post about the possible creation of an Updateable LINQ provider, especially if it can be used for a SQL dbms (of course it would work with LINQ to SQL but it should be applicable to LINQ to Entities too). I like this approach very much.

However, a Microsoft word on this, especially defining the "official" LINQ extensions and interfaces to implement an updatable query provider, would be fundamental to write code that will be still valid when a different LINQ provider implementation will be used.

Published Monday, November 24, 2008 12:21 PM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Kristofer said:

November 25, 2008 6:07 AM
 

Marco Russo (SQLBI) said:

Nice work, Kristofer! As I said, it would be good if Microsoft would put a word (better, a specification) about this.

Marco

November 25, 2008 6:13 AM
 

steve dassin said:

First, congradulations on you book. I assume you're planning something for the EF:)

As for the idea of an sql dml update within Linq (to sql) ,while desirable by many and expedient, I'm not sure if it's in the spirit of Linq. Here's Anders on the place

of sql in Linq:

Interview of Microsoft Distinguished Engineer Anders Hejlsberg

'Microsoft's Hejlsberg touts .Net, C-Omega technologies'

June 10, 2005

http://www.infoworld.com/article/05/06/10/HNhejlsberg_1.html

"..let's take C#, let's try and take SQL, let's try and take XML or XQuery and let's all sort of put them into one big bowl and stir and see what comes out of it"

And more specifically:

"So what we're looking at is really trying to much more deeply integrate the  capabilities of query languages and data into the C# programming language. And I don't specifically mean SQL, and I emphatically don't mean just take SQL and slap it into C# and have SQL in there. But rather try to understand what is it expressively that you can do in SQL and add those same capabilities to C#."

So it shouldn't be surprising if MS isn't thinking along the lines of a dml update. My guess is they will come at such an update in a different way than sql (if at all). Isn't the spirit of Linq to be 'different':)

More thoughts on the fascinating subject of Linq I've expressed on this site:

Linq to Sql: the 'what' and 'why' of it

http://beyondsql.blogspot.com/2008/11/linq-to-sql-what-and-why-of-it.html

Linq to Sql vs. older 4GL attempts

http://beyondsql.blogspot.com/2008/11/linq-to-sql-vs-older-4gl-attempts.html

Linq to Sql should be important to sql users

http://beyondsql.blogspot.com/2008/11/linq-to-sql-should-be-important-to-sql.html

Linq to Sql as an opportunity to sql users

http://beyondsql.blogspot.com/2008/11/linq-to-sql-as-opportunity-to-sql-users.html

November 30, 2008 11:08 PM

Leave a Comment

(required) 
(required) 
Submit

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog

Syndication

Archives

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement