DevForce Community Forum : Add/Insert & one to one mappings (SL) http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Add/Insert & one to one mappings (SL) Wed, 13 May 2026 03:48:41 -700 Fri, 31 Aug 2012 08:05:55 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2365 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Add/Insert & one to one mappings (SL) : Originally posted by pompomJuiceAah,... http://www.ideablade.com/forum/forum_posts.asp?TID=2365&PID=14295#14295 Author: olegasd
Subject: 2365
Posted: 31-Aug-2012 at 8:05am

Originally posted by pompomJuice

Aah, never mind.
 
I found the problem.
 
If you create the FK relationship Entity1.PK <------- Entity2.PK/FK then you must drag the mouse from entity1.PK to entity2.PK/FK when you are in SSMS's Database Diagram Mode. Basically my foreign key was the wrong way around and I failed to spot it.
 
Usually when you make FKs you drag the FK from the Foreign Key Base Table to the Primary/Unique Key Base table's PK. But when your FK is a PK, you have to drag it the other way around for some reason. Bizarre.


Thanks a lot! It was helpful for me, my problem solved. Thanks!

]]> Fri, 31 Aug 2012 08:05:55 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2365&PID=14295#14295 Add/Insert & one to one mappings (SL) : Aah, never mind. I found the... http://www.ideablade.com/forum/forum_posts.asp?TID=2365&PID=9362#9362 Author: pompomJuice
Subject: 2365
Posted: 10-Dec-2010 at 5:53am

Aah, never mind.
 
I found the problem.
 
If you create the FK relationship Entity1.PK <------- Entity2.PK/FK then you must drag the mouse from entity1.PK to entity2.PK/FK when you are in SSMS's Database Diagram Mode. Basically my foreign key was the wrong way around and I failed to spot it.
 
Usually when you make FKs you drag the FK from the Foreign Key Base Table to the Primary/Unique Key Base table's PK. But when your FK is a PK, you have to drag it the other way around for some reason. Bizarre.


Edited by pompomJuice - 10-Dec-2010 at 5:57am]]> Fri, 10 Dec 2010 05:53:48 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2365&PID=9362#9362 Add/Insert & one to one mappings (SL) : Hi. I am trying to achieve... http://www.ideablade.com/forum/forum_posts.asp?TID=2365&PID=9358#9358 Author: pompomJuice
Subject: 2365
Posted: 10-Dec-2010 at 1:54am

Hi.

I am trying to achieve a one to one mapping in my data. Firstly I set up this relationship in the database by setting one table's primary key as a foreign key into another table.
 
Entity1.PK  <-------- Entity2.PK/FK
 
Ideablade imports the model and everything seems to work until you try to do an insert Entity1/Entity2 pair in one transaction. An exception is thrown: A dependent property in a ReferentialConstraint is mapped to a store-generated column. Column:Entity1.PK"
 
A Entity1/Entity2 pair insert within one transaction works fine if you relate them in a one to many fashion though:
 
                               Entity2.PK
Entity1.PK <--------- Entity2.FK
 
... where I presume EntityManger or EF 4.0 first insterts Entity1, extracts its generated PK and use that when inserting Entity2. I'm guessing.
 
I am assuming this does not work with one to one relationships? Do I have to manually commit entity1, extract its PK so that I can use it to insert Entity2. This makes reject changes more compicated etc etc. What do I do here?
 
]]> Fri, 10 Dec 2010 01:54:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2365&PID=9358#9358