Welcome to MSDN Blogs Sign in | Join | Help

View This Blog In

LINQ and ADO.NET innovations

Language-Integrated Query (LINQ) is a breakthrough technology that eliminates the impedance mismatch among different data domains.  With LINQ, developers do not need to learn separate query syntaxes when querying over diverse data domains such as XML, Relational and Objects.  LINQ has been very well received both last year at its announcement at the PDC, and more recently at Tech-Ed in Boston.  Orcas, the next version of Visual Studio, includes LINQ infrastructure that enables this powerful combination of languages and API’s, as well as concrete support in multiple programming languages and data domains.

 

At the same time, our ADO team has been building a new data mapping substrate called ADO.NET Entities.  Entities move the data model up from the physical structure of relational tables to a data model that more accurately represents business entities such as “Customer” or “Order” that could map to multiple relational tables and views.  You can think about entities as a declarative way to specify the structure of a business object which you can then add business logic to and, through the power of LINQ, be able to query over them as well.  Entities will allow us to provide a common data model within the familiar ADO.NET environment that can be used across high-level functions such as reporting, replication, and BI.  For major enterprise applications, Entities allow developers to define complex mapping to relational data, enabling the creation of new business structures when the underlying database schema cannot be changed.

 

These two major advances in programmatically accessing data will help developers on our platform be even more productive.   Check out the channel 9 session that Anders Hejlsberg and Sam Druker did recently on this.

 

So that you can better identify these technologies, we have simplified our naming scheme as follows:

 

LINQ to ADO.NET, which includes:

            LINQ to DataSet

            LINQ to Entities

            LINQ to SQL (formerly DLinq)

 

LINQ support for other data types include:

            LINQ to XML (formerly XLinq)

            LINQ to Objects

 

Our teams are busy working on the next version of Visual Studio and incorporating these technologies in a consolidated way to ensure the very best experience for our developers.  We have the May CTP for LINQ available here and keep an eye out for a preview of the Entities work before the end of this year.

 

Namaste!

Posted: Wednesday, June 21, 2006 10:53 AM by Somasegar

Comments

Mike said:


So it took two years to make UDM finally irrelevant in the future. How many new and incompatible data access stacks do you guys produce every month?
# June 21, 2006 2:16 PM

Pazu said:

It was always irrelevant - Google:
UDM - 3M records, on first page nothing about software, first "Ultimate Dance Music"; LINQ - 4M records, only about software
# June 21, 2006 2:34 PM

Wooley's Wonderings said:

Soma just announced some additional re-branding of some of the LINQ stack. In addition to LINQ to SQL...
# June 21, 2006 2:49 PM

Data said:

Welcome to the Microsoft Data blog. I’m Samuel Druker and I lead a group that’s responsible for building...
# June 21, 2006 7:18 PM

Linq in Action News said:

Soma announced that the naming scheme for the Linq technologies has been simplified:LINQ to ADO.NET includes:     ...
# June 21, 2006 7:49 PM

Fabrice's weblog said:

Soma announced that the naming scheme for the Linq technologies has been simplified:LINQ to ADO.NET includes:     ...
# June 21, 2006 7:49 PM

Alex James said:

FYI: They are aiming for a preview of ADO.NET Entities in August:

http://www.base4.net/Blog.aspx?ID=44
# June 21, 2006 8:23 PM

Bruce Johnson's SOA(P) Box said:

# June 21, 2006 9:40 PM

Data Access blog said:

Hi - I'm Shyam Pather, Development Lead on ADO.NET vNext team.
I’m incredibly excited to share...
# June 21, 2006 10:37 PM

Alex Barnett blog said:

In case you missed it, Somasegar (Microsoft's VP of Developer Division) blogged today about some of the...
# June 22, 2006 12:49 AM

the roarty blog said:

Just some stuff I've noticed floating about and I think is worthy of note:

Pablo Castro points to...
# June 22, 2006 2:08 AM

davidacoder said:

"...move the data model up from the physical structure of relational tables to a..."

I know what you mean, but the data team uses the term "physical structure" in a different way in their whitepaper. They use "logical structure" for tables, views, keys etc and "physical structure" for disc partitions and the actual structure of the bits on the disc (i.e. something devs normally never see). Might be good to be consistent in the terms and replace "physical structure" in your text with "logical" :)
# June 22, 2006 5:33 AM

cs said:

I'm interested about the performance of ADO.NET entities. Will it be clever enough to optimise its SQL (table joins, indexes etc.), not bring back every row (but not ask for each row at a time) and so forth?

For the most simple 3 tier applications, with very basic < 10 table databases these type of middleware/business layers work very well. For complex databases they are generally slow and bulky and not worth using in my experience.
# June 22, 2006 6:31 AM

Erwyn van der Meer said:

[Update 2006-06-22: Microsoft's Pablo Castro from the ADO.NET team posted a comment on my blog in which...
# June 22, 2006 9:09 AM

Keith Elder said:

It is great if you guys are moving towards business entities.  The BIG thing you can't screw up with this is business rules.  Providing a business entity without being able to add in business rules easily is going to be worthless and I haven't seen any mention if this is going to be done.  

If you haven't done it yet, then just download nettiers and build it with Codesmith and copy the validation code it generates.  The generted validation code is based on delegates which allow you to wire up any business entity with specific validation rules.

Business entities are great, but the reason we want them is to validate them against our rules, that's the biggest concern in the enterprise.  Please don't miss out on this fact and be sure it is accounted for.
# June 22, 2006 9:58 AM

Federal Developer Weblog said:

If you write database applications using ADO.NET (which means almost everyone is still reading this),...
# June 22, 2006 11:31 AM

Federal Developer Weblog said:

If you write database applications using ADO.NET (which means almost everyone is still reading this),...
# June 22, 2006 6:26 PM

Data Access blog said:

Since announcing our ADO.NET vNext plans at TechEd last week, the team has been on the lookout for your...
# June 24, 2006 12:50 AM

Olivier Le Pichon said:

It sounds like the next revival of ObjectSpaces but with a different name.
Renaming is a MS favorite sports this days :)
# June 25, 2006 7:33 AM

George Birbilis said:

So why just have LINQ for VB.net and C# and not for J# too?
# July 3, 2006 8:23 AM

ADO.NET team blog said:

Hi - I'm Shyam Pather, Development Lead&amp;nbsp;on the ADO.NET vNext team.
I’m incredibly excited to share...
# July 11, 2006 1:06 PM

ADO.NET team blog said:

(this post&amp;nbsp;was originally posted here)

Since announcing our ADO.NET vNext plans at TechEd
...
# July 11, 2006 1:34 PM

Andy said:

If you write database applications using ADO.
# July 16, 2006 4:05 AM

Alex Barnett blog said:

The ADO.NET vNext Community Technology Preview ('CTP') went live today...Hopefully I can convince Tommy...
# August 15, 2006 11:58 PM

Microsoft XML Team's WebLog said:

Announcing the LINQ to XSD Preview Ever since PDC 2005, when XLinq was unleashed ( now called LINQ to

# November 27, 2006 8:59 PM

Roller said:

# January 9, 2007 4:13 PM

Tom Lee's blog said:

LINQ (Language Integrated Query) 是 Microsoft .NET Framework 未來本版的延伸功能,目的在 C# 與 Visual Basic 程式語言原生語法

# March 17, 2007 11:11 PM

sunrack said:

好爽,晚上抽空看了Mtaulty有关LinqtoSQL的N集连播,大呼过瘾,看完才有不少感概,国外DPE的这些Evangelist真是在传教解惑,如果换成中文的,哪估计能普及更多中国的.NET爱好...

# July 27, 2007 6:44 AM
Leave a Comment

(required) 

(required) 

(optional)

(required) 

  
Enter Code Here: Required

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


Page view tracker