c# - Two many-to-one table relationships and insertion with Entity Framework -


i have model similar this:

enter image description here

context: idea it's database of samples. 1 sample has details, , several samples can collated collatedsample, , details can collated in collateddetail. so, 1 collatedsample has many collateddetails, , starts many samples, each of has many details. collateddetail has many details too. it's "nice" square.

my approach adding records thus:

var sample = new sample(); var detail = new detail(); sample.details.add(detail); // suppose add bit more meat these entities...  var collatedsample = new collatedsample(); var collateddetail = new collateddetail(); collatedsample.samples.add(sample); collatedsample.collateddetails.add(collateddetail); collateddetail.details.add(detail);  context.collatedsamples.addobject(collatedsample); context.savechanges();

so i've added elements eachother, , added detail both sample , collateddetail. on savechanges, update exception jolly message:

unable determine principal end of 'samplingmodel.fk_detail_collateddetailid' relationship. multiple added entities may have same primary key.

what think might happening there attempt record detail entity before collateddetail recorded. detail table, 2 relationships, 1 causing trouble (not adding them either sample nor collateddetail confirms it). perhaps there way specify order of insertion? tried reverse, set parent instead of using .add() on children collections, same result. otherwise, how make sort of 2-pronged insertion in 1 shot?

edit: tl;dr:

enter image description here

i found workaround: removed foreign key between detail , collateddetail @jaderdiag suggested, , reference field collateddetail table. entity framework creates partial classes, easy create other partial classes both entities , manually join them. much slower, suspect, provides same fluidity in later exploitation entities have provided foreign key.

this workaround, , not solution looking for. vote down if could.


Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more