THE SQL Server Blog Spot on the Web

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

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
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)



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.


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

"..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

Linq to Sql vs. older 4GL attempts

Linq to Sql should be important to sql users

Linq to Sql as an opportunity to sql users

November 30, 2008 11:08 PM
New Comments to this post are disabled

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



Privacy Statement