ADO.NET Entity Designer Video - CTP 2

Please install Silverlight or click download to watch video locally.

This video demonstrates a number of important new features in the Entity Data Model Tools December CTP. First, it is now possible to visually map the insert, update, and delete stored procedures for entity types. Additionally, support for function imports allows the mapping of query stored procedures that return primitive types as well as collections of entity types. Finally, we demonstrate the new “Update Model from Database” feature which enables adding new database objects to the model, synchronization of existing objects, such as new table rows, and deletion of removed objects. The video takes a simple, scenario-driven approach, showing a complete end-to-end use of all of these features, from the creation of a new data model to executing code against it and tracking the number of stored procedures run during the run. ASP.NET Entity Framework technology is available in the ASP.NET 3.5 Extensions Preview (December 2007).

Presented by Noam Ben-Ami

Duration: 12 minutes, 53 seconds

Date: 10 January 2008

Watch    Video   |   Download    Video

Video downloads: WMV  |  Zune  |  iPod  |  PSP  |  MPEG-4  |  3GP

Audio downloads: AAC  |  WMA  |  MPEG-4  |  MPEG-3  |  MPEG-2

Comments : 17

Leave a Comment

Nim : On April 02, 2008 6:30 AM said:

Ok, guys, I see that this extension is great, by I can't understand it's difference between the LINQ2SQL model. Would u like 2 explain it in a few words?

MWeber : On June 12, 2008 7:22 PM said:

I second that... what is the difference.

dw.egun : On June 13, 2008 3:14 AM said:

Please give more example on your video.

JSirius : On July 25, 2008 5:47 AM said:

Is it possible to download the source please?

This extension is great^^

Thanks

vik20000in : On August 12, 2008 7:14 AM said:

hmmm, The question that copmes to my mind is also the same. whats the big difference with linq 2 sql

bananas : On September 11, 2008 4:14 PM said:

MORE TUTORIAL VIDEOS ON THE ENTITY FRAMEWORK PLEASE!!! Theres not enough help out there!!! AHHHHHHHH!!!!!!!!!!!!!

jparlato : On September 13, 2008 6:55 AM said:

I know that one difference is that linq to sql only supports single table inheritance, whereas entity framework supports multiple types of inherance including entity to multiple tables.

oooshola : On September 14, 2008 5:06 AM said:

I completely agree with bananas, as well as the questions regarding the difference between this and linq2sql. It seems that MS is wanting us to gear toward using this for enterprise development, rather than linq2sql, but there is so little real support for it. I guess I'll wait until December (?) to get a decent book on it...

djibril_chimere_DIAW : On October 31, 2008 1:42 PM said:

Thanks! Jërëjëf!

r0lan2 : On January 02, 2009 8:24 AM said:

where can i download the code and the DB?

wvvjoevvw : On January 15, 2009 1:34 PM said:

come on people, ... has anyone used this? Is this replacing / phasing out linq like I've heard on the grapevine, and either way, what is the pros/cons/etc of using linq2sql or ado entity framework? thx in adv

deppe79 : On July 02, 2009 10:53 PM said:

Thanks!

jmsides : On August 04, 2009 4:04 PM said:

where can I get the code and database? great demo...

damiensawyer : On August 05, 2009 2:43 AM said:

Roses, Violets, Vase ... and an orbital space laser.

Love it :-)

omihai_2000 : On August 11, 2009 6:22 AM said:

This is a great technique, but I wonder how did you map the output parameter of the insert function ? I did the same and the idProduct (which is supposed to be populated from the database) still appears in the input parameter list. And if I add it in the output list, when I try to Validate, this error pops up: "A mapping function binding specifies a function TestModel.Store.InsertProduct with an unsupported parameter: idProduct. Output parameters may only be mapped through the RowsAffectedParameter property. Use result bindings to return values from a function invocation". idProduct is of type Guid.

skylane : On August 17, 2009 1:08 PM said:

Can all this mapping be generated. I've yet to see any discussions regarding code generation for EF + sprocs. That designer will get old quick when dealing with a large database.

sohail74 : On November 13, 2009 8:52 AM said:

I want to update any product not just the first product. Can you tell me how to update any specific product providing its product_id

Leave a Comment

You must be logged in to leave a comment. Click here to log in.

Microsoft Communities