ADO.NET Entity Framework on Channel 9

Published 19 July 06 09:36 PM | dpblogs 

A few weeks ago we released a couple of whitepapers that discuss the future directions of the Microsoft Data Platform and in particular the specifics around the next version of ADO.NET and the ADO.NET Entity Framework.

Recently the Channel 9 folks came by Building 35 (SQL Server building at Microsoft) and we shot an episode with Mike Pizzo, Britt Johnston and myself chatting about why we chose to work on the Entity Framework for the next version of ADO.NET, what scenarios we’re targeting with it and some drill downs into what the code and designers actually look like in the current bits.

You can find the Channel 9 video here. As always, feedback is welcome.
 
Pablo Castro
ADO.NET Technical Lead
Microsoft Corporation
 

Filed under: ,

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

# Data said on July 19, 2006 8:49 PM:

While watching Jim Gray's PASS video that Alex referenced in the previous post it reminded...
# Steve said on July 20, 2006 8:14 AM:
Are you still targetting August for the first community drop?  If so are we looking at the beginning of August or the end of August? :)

What databases will be supported for the CTP?  What databases will be supported at RTM time?

Cheers,
Steve



# Dals said on July 20, 2006 10:32 AM:
Building 35 (SQL Server building at Microsoft)? ADO guys with SQL guys on the same building? Finally they are talking to each other...
# Jonathan Bruce said on July 20, 2006 1:09 PM:
Great video! I think many people will use this as a resource in the future. Personally I found the screen shots really hard to follow - perhaps next time it would be good to do a direct screen cast, but only if you don't loose the great spontaneity of this format.

Otherwise Pablo, we need to get you some art work for your office. I'll see what I can rustle up…

# Pablo [MSFT] said on July 20, 2006 4:26 PM:
>> Are you still targetting August for the first community drop?  If so are we looking at the beginning of August or the end of August? :)

Yes, we're still shooting for August; we're looking at the mid/end of August.

>> What databases will be supported for the CTP?  What databases will be supported at RTM time?

For the CTP we'll support SQL Server 2005, and we should have parity (or close) for SQL 2000 (of course, if you use 2005-specific features such as CROSS APPLY it won't work in 2000). We're working with various provider writers to get a number of databases integrated; it's looking really good, and hopefully we'll have broad database support soon. Whether that will be there over the CTP bits or on future CTPs/Betas is hard to tell at this point.

Also, the model is open, so anyone can create an updated ADO.NET provider that includes the new extensions and fit into the Entity Framework (and you get mapping, Entity SQL, LINQ, etc. support for free for your database :)

-pablo
# Karl Offenberger said on July 20, 2006 10:02 PM:
Sweet! O/R mappers, entity frameworks and the lot have all been done before, but I have to wonder over and over how you guys at Microsft manage to step it up one more over the competition.

Judging from the demos Pablo gave, EF makes perfect sense and is simply brilliant in the way that it doesn't restrict us to go all out or nothing.

We can use a similar aproach as we're now using MapConnector and data readers, we can write in-line T-SQL or add-in some eSQL, we can go further and generate concrete objects that map to our entities, use LINQ query and so on and so forth. That leaves us plenty freedom to choose from a wide range of implementation possibilities rather than tieing us to a one-way approach as many current O/R frameworks and entitiy frameworks do. Amazing!

A few questions though:

1) Will the mapping tool be available as a control that can be hosted in your own applications much like the workflow designer in WF?

2) Will there be runtime support to generate concrete classes of our database model using user defined mapping files? E.g. user defines new table, uploads/chooses XML file that provides mappings to the conceptual entity objects and the concrete model objects get generated without the need to run by Visual Studio.

3) Will we be able to define entity attributes (EAV model) dynamically; I know we can, but would it be an "out-of-the-box" feauture that you're thinking about? E.g. Could we have EntityAttributeGroup, EntityAttributeDefinition, and EntityAttributeValue that can be related in any manner to their parent entity instance?

4) A while ago the documents previewing the Entity Framework disapeared from the Microsoft Web site and resurfaced again later. However, the documents have references to further documentation which isn't available - is there any chance you guys can convince the powers to be to release those missing documents and give us some sort of roadmap as to what the planned/wishlist features of ADO.NET vNext and EF are for RTM?

Last but not least at all, Pablo, you're a great presenter and I hope yourself and the team around ADO.NET all start blogging a lot more while your user community eagerly awaits what looks to become one of the greatest releases in ADO since ADO.NET.

Many thanks!!!
# Steve said on July 20, 2006 10:57 PM:
Thanks for the responses Pablo!

I'm really looking forward to the bits so that I can start to see how new providers can be created on top of the baseline that you guys provide.

Regarding database support...What about Sql Everywhere? :)

Are there any common database scenarios that you won't be supporting?  I know DLinq (Linq to Sql) doesn't currently support many to many relationships, will ADO.NET EF support creating conceptual models over all the typical relational models that we all have in use today?  Or are there some common scenarios (such as Many to Many) that you won't be supporting?

Finally, if I give you $5 can you release it in the beginning of August instead of the middle/end? :-)

Cheers,
Steve
# Pablo [MSFT] said on July 21, 2006 2:25 AM:
Thanks for the feedback Karl, here are comments for your questions:

1) Will the mapping tool be available as a control that can be hosted in your own applications much like the workflow designer in WF?

To be honest, I haven't thought about that, but may be that's why I don't do tools :). I'll definitely run this by our tools folks.

2) Will there be runtime support to generate concrete classes of our database model using user defined mapping files? E.g. user defines new table, uploads/chooses XML file that provides mappings to the conceptual entity objects and the concrete model objects get generated without the need to run by Visual Studio.

err, some of the pieces are there (class generation is part of the runtime right now, not sure if it'll stay like this through RTM), but I'm not sure how straightforward will it be to do this. Feedback taken though.

3) Will we be able to define entity attributes (EAV model) dynamically; I know we can, but would it be an "out-of-the-box" feauture that you're thinking about? E.g. Could we have EntityAttributeGroup, EntityAttributeDefinition, and EntityAttributeValue that can be related in any manner to their parent entity instance?

That's not there right now, but may happen in a future release.

4) A while ago the documents previewing the Entity Framework disapeared from the Microsoft Web site and resurfaced again later. However, the documents have references to further documentation which isn't available - is there any chance you guys can convince the powers to be to release those missing documents and give us some sort of roadmap as to what the planned/wishlist features of ADO.NET vNext and EF are for RTM?

There should be at least the same set of docs out there, if not more. If you could let me know which one is missing, I'll chase it down for you.

-pablo
# Pablo [MSFT] said on July 21, 2006 2:32 AM:
>> Regarding database support...What about Sql Everywhere? :)

Very likely, although I don't know release dates, version numbers, etc.

>> Are there any common database scenarios that you won't be supporting?

Yes, there are scenarios that we won't support. When we come out with the CTP I'll let you guys take a look and come back with feedback. Many to many will most likely be supported, but other constructs won't.

>> Finally, if I give you $5 can you release it in the beginning of August instead of the middle/end? :-)

I'll take your offer to upper management, may be it does the trick ;)
# Alex Barnett blog said on July 21, 2006 4:25 AM:
Britt Johnston, Mike Pizzo and Pablo Castro are interviewed by Charles Torre in this Channel 9 video...
# Robert Boeckel said on July 22, 2006 4:35 PM:
Very existing stuff!

Will it also be possible to access XML-Documents this way?
# Alex James said on July 25, 2006 6:19 AM:
Nice one pablo, you do a mean presentation!
# Joel said on July 26, 2006 7:00 PM:
Will the entity classes implement the INotifyPropertyChanged and/or ObservableCollection<> interfaces?

By the way this is great technology. I am very tired of writing data access code.
# Pablo [MSFT] said on July 26, 2006 7:17 PM:
>> Will the entity classes implement the INotifyPropertyChanged and/or ObservableCollection<> interfaces?

Yes, entities implement INotifyPropertyChanged (only, no ObservableCollection).

-pablo
# Ovidiu Platon said on August 15, 2006 8:25 PM:
Tocmai am aflat că a apărut ediţia august 2006 a CTP-ului de ADO.NET vNext. Dacă v-au plăcut demo-urile...
# Alex Barnett blog said on August 15, 2006 11:53 PM:
The ADO.NET vNext Community Technology Preview ('CTP') went live today...Hopefully I can convince Tommy...
# Tiernans Comms Closet said on August 16, 2006 7:46 AM:
the August CTP release of the next release of ADO.NET, vNext, has been released. the announcement is...
# Weddings said on June 5, 2008 4:47 AM:

A few weeks ago we released a couple of whitepapers that discuss the future directions of the Microsoft Data Platform and in particular the specifics around the next version of ADO.NET and the ADO.NET Entity Framework. Recently the Channel 9 folks cam

# ADO.NET Entity Framework &laquo; using &#8230; said on October 26, 2008 3:13 AM:

PingBack from http://esersahin.wordpress.com/2008/10/26/adonet-entity-framework-2/

# Wriju's BLOG said on March 10, 2009 3:38 PM:

Compiled Resources http://www.renaissance.co.il/downloads/Entity%20Framework%20Essential%20Resources.pdf

# 勝ち組負け組 said on June 21, 2009 11:09 PM:

当サイトは、みんなの「勝ち組負け組度」をチェックする性格診断のサイトです。ホントのあなたをズバリ分析しちゃいます!勝ち組負け組度には、期待以上の意外な結果があるかもしれません

# セレブラブ said on June 26, 2009 10:58 PM:

セレブラブではココロとカラダに癒しを求めるセレブ達と会って頂ける男性を募集しています。セレブ女性が集まる当サイトではリッチな彼女たちからの謝礼を保証、安心して男性はお金、女性は体の欲求を満たしていただけます。無料登録は当サイトトップページからどうぞ

# スローセックス said on June 30, 2009 11:03 PM:

楽しく、気持ちよく絶頂を味わえることで若い女性から熟女の女性まで幅広い世代で爆発的な人気がある、スローセックス。当サイトはプレイに興味がある、あるいは試してみたいけれど相手がいない…といった方の支援サイトです。当サイトでSEXパートナーを探してみませんか

# Van said on July 3, 2009 8:44 AM:

Hi

I have modeled my DB in Entities.

But now I have run into a problem.

I have a generic table called message and another which is called emailmessage which is link to message in a one-to-zero-or-one relationship. This emailmessage table has more type specifiec data link To,CC,BCC and so on. So in my entity model I created a EMAIL entity which maps to both message and emailmessage. This works 100%.

Now I want to add a new table smsMessage (with the same relationship) and create a entity SMS which also maps to message and smsMessage. But as soon as I create this I get the following error:

"Error 3033: Problem in Mapping Fragment starting at line 1002: EntitySets 'EmailMessageSet' and 'SMSMessageSet' are both mapped to table 'Message'. Their Primary Keys may collide."

This is the only error I get. Can any one please help me? I will later have to add even more message types lik "IM","MMS".... So we want the generic message table to stay there and not split it all out.

Thanx in advance.

Regards

Van

# 家出 said on July 4, 2009 11:33 PM:

これから家出したい少女や、現在家出中の娘とそんな娘を助けたい人を繋げるSOS掲示板です。10代、20代の女の子が家庭内の問題などでやむなく家出している子が多数書き込みしています。女の子リストを見て彼女たちにアプローチしてみませんか

# 精神年齢 said on July 6, 2009 12:04 AM:

みんなの精神年齢を測定できる、メンタル年齢チェッカーで秘められた年齢がズバリわかっちゃう!かわいいあの子も実は精神年齢オバサンということも…合コンや話のネタに一度チャレンジしてみよう

# 童貞卒業 said on July 6, 2009 11:39 PM:

童貞卒業を考えているなら、迷わずココ!今まで童貞とヤッた事がない女性というのは意外と多いものです。そんな彼女たちは一度童貞とやってみたいと考えるのは自然な事と言えるでしょう。当サイトにはそんな好奇心旺盛な女性たちが登録されています

# 素人 said on July 7, 2009 10:36 PM:

素人ホストでは日頃のストレスを発散したい、もう一度恋がしたい、そういた女性が癒しを求めて登録されています。当サイトは癒やされたい女性・寂しい女性を癒やす男性が集うカップリングサイトです

# 熟女 said on July 8, 2009 11:30 PM:

熟女だって性欲がある、貴方がもし人妻とSEXしてお金を稼ぎたいのなら、一度人妻ワイフをご利用ください。当サイトには全国各地からお金持ちのセレブたちが集まっています。女性から男性への報酬は、 最低15万円からと決めております。興味のある方は一度当サイト案内をご覧ください

# 小向美奈子 said on July 13, 2009 1:09 AM:

話題の小向美奈子ストリップを盗撮!入念なボディチェックをすり抜けて超小型カメラで撮影した神動画がアップ中!期間限定配信の衝撃的映像を見逃すな

# メル友募集 said on July 16, 2009 11:54 PM:

最近してないし欲求不満です。一緒にいやらしいことしませんか?エッチには自信あるよ(笑) nyaon.chuki@docomo.ne.jp メール待ってるよ☆

# 動物占い said on July 19, 2009 11:38 PM:

あなたの性格を、動物に例えて占っちゃいます。もしかしたらこんな動物かも!?動物占いをうまく使って、楽しい人間関係を築いてください

# 家出 said on July 21, 2009 11:29 PM:

家出中の女性や泊まる所が無い女性達がネットカフェなどで、飲み放題のドリンクで空腹を満たす生活を送っています。当サイトはそんな女性達をサポートしたいという人たちと困っている女性たちの為のサイトです

# セレブラブ said on July 22, 2009 11:34 PM:

セレブ女性との割り切りお付き合いで大金を稼いでみませんか?女性に癒しと快楽、男性に謝礼とお互い満たしあえる当サイト、セレブラブはあなたの登録をお待ちしております。

# モテる度チェッカー said on August 24, 2009 12:36 AM:

あなたのモテ度数を診断できる、モテる度チェッカー!日頃モテモテでリア充のあなたもそうでないヒキニートの貴方も隠されたモテスキルを測定して今以上にモッテモテになること間違いなし

Leave a Comment

(required) 
(optional)
(required) 

  
Enter Code Here: Required

Search

This Blog

Syndication

Page view tracker