Update Model From DB

re: Update Model From DB

juliel — Tue, 01 Apr 2008 23:15:43 GMT

Oh, good, I was literally about to update a model. Could I maybe have that right now? ;-)

Looking forward to the improvements.

re: Update Model From DB

Joachim Lykke Andersen — Tue, 01 Apr 2008 23:31:31 GMT

Sounds fantastic, i hope that we will se this in a CTP very soon, as we really need these improvements. If you need somebody to try it out, let me know ;)

EDM designer CTP3 ou Beta 1, Update Model From DB

Matthieu MEZIL — Wed, 02 Apr 2008 00:17:33 GMT

Ceux qui ont un peu joué avec le designer le savent, c'est encore une CTP. La mise à jour du modèle à

re: Update Model From DB

shlomiw@gmail.com — Wed, 02 Apr 2008 14:21:24 GMT

Any ETA of next release?

we're looking forward for this improvement...

re: Update Model From DB

unbornchikken — Thu, 03 Apr 2008 14:47:11 GMT

Thank you guys for the improvements! I need that baby right now! :D A quick question: What about complex type support?

EDM Designer Improvements for UpdateModel features

Hot Topics — Thu, 03 Apr 2008 17:54:21 GMT

Noam Ben-Ami writes about the improvements we will see in how the designer updates models in the next

re: Update Model From DB

Noam Ben-Ami — Fri, 04 Apr 2008 02:12:36 GMT

Complex type support did not make it into v1.

re: Update Model From DB

N de Lioncourt — Fri, 04 Apr 2008 03:05:45 GMT

I did not realize actually writing code became a hated chore; only tools which remove us from that horrible code will help. No thanks, folks, I got into this field to write code; not be a drag-n-drop monkey. I wish you all luck since you know what monkeys are paid, right? Peanuts and bananas; not six-figure salaries.

Sheesh... if you hate writing code please get out of the field.

re: Update Model From DB

Roger Hendriks — Sun, 06 Apr 2008 22:19:21 GMT

Nice but from a software development view I would prefer putting the effort in (re)generating the database from the model ;)

re: Update Model From DB

Noam Ben-Ami — Mon, 07 Apr 2008 08:07:24 GMT

We hear you, and we're absolutely putting effort there!

re: Update Model From DB

Ben S — Mon, 07 Apr 2008 12:09:41 GMT

Good work, can’t wait! In addition to desperately wanting the next version (or at least a hint of when it might appear, even if it might change), I would like to see:

1. More method/property name consistency with Linq to SQL (eg. SubmitChanges() not SaveChanges(), DataContext.Table.InsertOnSubmit() not DataContext.AddToTable() etc)

2. Support for sql_variant with the ‘object’ type.

3. Support for inserting multiple rows like Linq to Sql (DataContext.Table.InsertAllOnSubmit(MyObject[] { row1, row2, row3 }))

Thanks!

re: Update Model From DB

Pedro Ramirez — Mon, 21 Apr 2008 21:00:43 GMT

Hi guys,

you are doing a great job with the Entity Framework, I have a question, right now, we are coding a new application that uses data from 4 different databases and I was wondering if it is possible to create an entity data model related to more than one db, i.e. I need to create one entity that maps to more than one table in more than one database.

is this possible?, I guess I can overcome this creating some Entity that encapsulates the entity data model from the different databases.

Regards,

Pedro.

re: Update Model From DB

Morten Mertner — Fri, 25 Apr 2008 17:39:21 GMT

It would be much nicer if the Update Model from Database dialog were to create a copy of the current model, update/add all available tables and then let you preview the changes associated with the individual checkboxes on the Add/Refresh tabs.

While I like the fact that you don't delete from the model, I'm sure that if you can produce a working tool all the manual maintenance will quickly become a major nuisance. Previewing changes sounds like a much nicer user interaction model, and if everything fails there's always Undo in Visual Studio.

Entity Framework Links for April, 2008

Barry Gervin's Software Architecture Perspectives — Fri, 02 May 2008 20:10:06 GMT

During the past month, Danny Simmons let us all officially know that SP1 of VS 2008/.NET Framework 3.5

Update Model – a Question of Identity – Part 1 of 3

ADO.NET team blog — Tue, 22 Jul 2008 19:25:02 GMT

I propose to explain the reason behind some of the oddities of the “Update Model from Database” functionality

ADO.NET Entity Framework "Update Model from Database"

Henry is Sharing Points about MOSS 2007 & Busy Talking about BizTalk 2006 — Wed, 23 Jul 2008 20:48:35 GMT

Based on the from ADO.NET team blog post and my experiment, changing the data type in the phyiscal table

ADO.NET Entity Framework "Update Model from Database"

Henry is Sharing Points about MOSS 2007 & Busy Talking about BizTalk 2006 — Thu, 24 Jul 2008 02:42:28 GMT

Based on the from ADO.NET team blog post and my experiment, changing the data type in the phyiscal table

re: Update Model From DB

VB — Tue, 29 Jul 2008 21:18:49 GMT

When I select "Update Model from DB" it shows me the pop up windows with "Add" and "Update" tables, views, SP option. When I select "Update" it throws an message:

"You cannot select or deselect....."

Hence I end up with all my DB tables again in my EDMX. If I want to update and get only 1/2 DBtables I still end up getting all tables again.

Is there any way out?????

re: Update Model From DB

Mathias — Fri, 15 Aug 2008 15:35:28 GMT

Is there a way to update only the SSDL and not the Model?

I only want a simple "refresh tables" function without adding new columns to my model.

Not all columns in database are needed in these models (e.g for implementing inheritence)

Entity Framework – Update Model From Database, Part 2

EntLib — Tue, 21 Oct 2008 02:59:22 GMT

Update Model from Database 是EDM 设计器的一个重要改进功能，支持增加新的数据库表和列，Model能够正确处理类型（Type）和属性（Property）的改名，能够检测继承和映射的改变。这里，我们简要介绍这一功能的使用及其限制。上一篇文章《Entity Framework – Update Model From Database, Part 1》

re: Update Model From DB

Moon — Thu, 01 Jan 2009 21:37:04 GMT

I've been watching your video and now found this. It is the same. When you use Update Model, it has checkboxes which open up sub checkboxes for tables, views, sp's. However, I am using VS2008 with SP1 and when I do the same thing, it simply has one checkbox each for the tables, views, stored procedures, but does not open a subtree with all of my tables, views and sp's from which to select.

Why is that? Did they take that option out? Or do I have an old version or what is going on? I just recently bought my 2008 a few months ago and have SP1. I just cannot select my tables, etc. using the update model.

Also, when I update the model based on changes in the tables sometimes it works, and other times it doesn't. And I end up having to delete the entire model and recreate it.

So far, I am really disappointed in the Entity model.

1) the model doesn't update as it should without deleting and rebuilding. So forget trying to customize.

2) the model doesn't support stored procedures that are not insert/update/delete. Even though you can Create Function Import and it allows you to have a return type of None, forget ever trying to use it. It doesn't allow you to use it!! So why tease us with it? I have checked all over the forums and blogs and the consensus is, unless it returns the exact structure of your entities, forget using it.

3) if I combine linq to entities with an ado.net stored procedure (to use my unsupported stored procedure from #2), the changes made within my stored procedure simply do not get propagated to my entities model and somehow when I use linq to entities to pull from my tables, they are still using the old data prior to my calling the stored procedure. If I use ado.net with a sqlcommand, it will pull the latest. The changes are not flushed to the entity model. Which brings me to #4.

4) I can't get any help on using this. Rarely does anyone write about how to do real world things such as using the Create Function Import to run a stored procedure that returns nothing. Has anyone done it? I don't think so. Because numerous have told me it can't be done. And when I ask questions in the asp.net forum, I just don't get answers. I thought I'd "move ahead" with the latest technologies, but the technology doesn't seem to be well supported, well discussed and seems to be very incomplete. And using this has put me weeks behind in development. I'm not the only frustrated user, just check the forums.

5) You can find all kinds of support for dynamic data, silverlight, and MVC, but where is the support for ADO.NET Linq to Entities? There isn't even an asp.net forum dedicated to it.

I'm simply tired of being Microsoft's unpaid debugger.

re: Update Model From DB

Jeff Ballard — Wed, 16 Dec 2009 07:08:22 GMT

Thank you so much for the info on this error:

“Problem in Mapping Fragment(s) starting at line(s) (110, 176): Non-primary-key column(s) [SupplierID] being mapped in both fragments to different conceptual side properties - data inconsistency is possible because the corresponding conceptual side properties can be independently modified.”

I was running into a similar error and sure enough, I had the field as a scalar property and navigation property because I added the FK after the initial create of the model. Removed the scalar property and all was well.

Jeff