DevForce Community Forum : Adding navigation properties

DevForce Community Forum : Adding navigation properties http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Adding navigation properties Mon, 20 Apr 2026 23:18:54 -700 Mon, 18 May 2009 13:39:06 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1098 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Adding navigation properties : I went through all this again,... http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=4561#4561 Author: pucsoftware
Subject: 1098
Posted: 18-May-2009 at 1:39pm

I went through all this again, slowly, and got a completed entity model. This time I did one table at a time, first doing the navigation properties, then the Associations, saving after each changes, and didn't run into any problems. Before I was jumping around changing several tables, navigation and associations, all at the same time before saving. I probably created some type of conflict without realizing it. If I can reproduce this some time in the future I'll send you the corrupted model. Thanks for your efforts.

]]> Mon, 18 May 2009 13:39:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=4561#4561 Adding navigation properties : Originally posted by pucsoftwareI... http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=4558#4558 Author: GregD
Subject: 1098
Posted: 18-May-2009 at 12:22pm

Originally posted by pucsoftware

I started creating a new model and I'm having problems with renaming navigation properties in the object model. I'll be working with if for a while, changing the names of the Navigation properties and the Association names, periodically saving it. Eventually, I get a nondescript error when saving. I end up having to close the object mapper without saving the changes. However, the model is in an invalid state. The .Net entity designer won't display the objects and shows an error:

Warning 1 Error 11004: Association 'FK_SX_STAP_REJECTION_LU_STAP_REJECTION' has no association set. D:\Projects\Windows\Stap\StapDb\StapEntityModel.edmx 1516 9 StapDb

I failed in my effort to reproduce the problem (steps described below). Perhaps you can send us your corrupted .edmx, .ibedmx, and associated designer code files (to support@ideaBlade.com).

Here's what I did:

In NorthwindIB, I added three columns to the Order table: EmployeeId2, EmployeeId3, and EmployeeId4. (It already had an EmployeeID.)
Generated a new Entity Data Model. The Order entity got navigation properties Employee, Employee1, Employee2, and Employee3.
In the Object Mapper, I renamed the Employee-related navigation properties to Employee1, Employee2, Employee3, and Employee4 (moving backward from the one with the highest-numbered suffix). Saved the work and closed the Object Mapper.
Reopened the Object Mapper, renamed the properties to Employee10, Employee09, Employee08, and Employee07 (again moving backward from the one with the highest-numbered suffix). Saved the work but did not exit the Object Mapper.
Renamed the properties to Employee99,Employee98, Employee97, and Employee96. Saved the work but did not exitthe Object Mapper.
Repeated step 5 with different names, two more times.
Closed the Object Mapper and opened the Entity Data Model in the Entity Data Model designer. No problems, all properties named as requested.

]]> Mon, 18 May 2009 12:22:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=4558#4558 Adding navigation properties : Originally posted by pucsoftwareThe... http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=4557#4557 Author: GregD
Subject: 1098
Posted: 18-May-2009 at 11:46am

Originally posted by pucsoftware

The object mapper automatically names them:

LU_DEVICE_CODE

LU_DEVICE_CODE1

LU_DEVICE_CODE2

LU_DEVICE_CODE3

Which, to me, makes it a little confusing since the Navigations are not corresponding to the original fields:

DEVICE_CODE1 -> LU_DEVICE_CODE ( this one defaults to no number )

DEVICE_CODE2 -> LU_DEVICE_CODE1

DEVICE_CODE3 -> LU_DEVICE_CODE2

DEVICE_CODE4 -> LU_DEVICE_CODE3

So, I was renaming them to be:

DEVICE_CODE1 -> LuDeviceCode1

DEVICE_CODE2 -> LuDeviceCode2

DEVICE_CODE3 -> LuDeviceCode3

DEVICE_CODE4 -> LuDeviceCode4

It's the ADO.NET Entity Data Model designer, not the DevForce Object Mapper, that makes the initial name assignments. It uses the name of the type on the other end of the association (LU_DEVICE_CODE) rather than the name of the foreign key; and that's generally a good thing, since foreign keys often have names that aren't appropriate for an entity (like OrderId, etc.). If you have more than one navigation property that returns the same type, the EF code generator then just starts appending integer suffixes, leaving it up to you to adjust the names to something that's meaningful to you.

But you should be able to do it!
]]> Mon, 18 May 2009 11:46:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=4557#4557 Adding navigation properties : Let me cook up a similar database... http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=4556#4556 Author: GregD
Subject: 1098
Posted: 18-May-2009 at 11:37am

Let me cook up a similar database structure and see if I can reproduce what you're seeing. I'll be back.
]]> Mon, 18 May 2009 11:37:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=4556#4556 Adding navigation properties : I started creating a new model... http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=4552#4552 Author: pucsoftware
Subject: 1098
Posted: 18-May-2009 at 8:44am

I started creating a new model and I'm having problems with renaming navigation properties in the object model. I'll be working with if for a while, changing the names of the Navigation properties and the Association names, periodically saving it. Eventually, I get a nondescript error when saving. I end up having to close the object mapper without saving the changes. However, the model is in an invalid state. The .Net entity designer won't display the objects and shows an error:

Warning 1 Error 11004: Association 'FK_SX_STAP_REJECTION_LU_STAP_REJECTION' has no association set. D:\Projects\Windows\Stap\StapDb\StapEntityModel.edmx 1516 9 StapDb

I worked on this all day Friday. I ended up having to start over with the project. I've had to start completely over 3 times now and currently it is corrupted. Should I be renaming the Navigation and Association properties? I've done this before and never had any problems. The only difference that I can think of is with main table. It has several fields that are related to the same lookup table. for example:

DEVICE_CODE1 -> LU_DEVICE_CODE

DEVICE_CODE2 -> LU_DEVICE_CODE

DEVICE_CODE3 -> LU_DEVICE_CODE

DEVICE_CODE4 -> LU_DEVICE_CODE

The object mapper automatically names them:

LU_DEVICE_CODE

LU_DEVICE_CODE1

LU_DEVICE_CODE2

LU_DEVICE_CODE3

Which, to me, makes it a little confusing since the Navigations are not corresponding to the original fields:

DEVICE_CODE1 -> LU_DEVICE_CODE ( this one defaults to no number )

DEVICE_CODE2 -> LU_DEVICE_CODE1

DEVICE_CODE3 -> LU_DEVICE_CODE2

DEVICE_CODE4 -> LU_DEVICE_CODE3

So, I was renaming them to be:

DEVICE_CODE1 -> LuDeviceCode1

DEVICE_CODE2 -> LuDeviceCode2

DEVICE_CODE3 -> LuDeviceCode3

DEVICE_CODE4 -> LuDeviceCode4

This table has 4 sets of fields that are setup this way. It's a legacy application that I can't change, too.

Not sure if this causes the problem as the errors don't seem to reflect these particular fields, but the results have been pretty consistent - corrupted entity model that I can't fix.

Any suggestions?

]]> Mon, 18 May 2009 08:44:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=4552#4552 Adding navigation properties : There are plans to beef up the... http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=3936#3936 Author: kimj
Subject: 1098
Posted: 25-Feb-2009 at 8:07am

There are plans to beef up the functionality within the Object Mapper, but we just haven't had the time and resources to get to it yet. So unfortunately for now you will still need to use the EDM designer (and we agree, it is horrible to work with :)).]]> Wed, 25 Feb 2009 08:07:51 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=3936#3936 Adding navigation properties : Hi,Are there any plans to support... http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=3933#3933 Author: smi-mark
Subject: 1098
Posted: 24-Feb-2009 at 12:11pm

Hi,

Are there any plans to support adding navigation properties through the object mapper like in classic? One database we are currently working against does not have relationships setup in the database, and we cannot add them due to legacy applications currently in use. I realize you can do it with the EF designer but frankly it is horrible to work with!

Thanks,

Mark
]]> Tue, 24 Feb 2009 12:11:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1098&PID=3933#3933