c# - A Dependent Role has multiple principals with different values -

-

i using enitity framework codefirst , have following design

public class location {     public int id { get; set; }     public string name { get; set; }     public bool isdeleted { get; set; } }  public class delieryrate  {     public int id { get; set; }      public int originid { get; set; }     public location origin { get; set; }      public int destinationid { get; set; }     public location destination { get; set; }      public double amount { get; set; }      public bool isactive { get; set; } }

i not want define relationship on location. when update database, works referential integrity error when run seed code. have tried configure using fluent api follows

modelbuilder.entity<deliveryrate>()             .hasrequired(e => e.origin)             .withoptional()             .willcascadeondelete(false);  modelbuilder.entity<deliveryrate>()             .hasrequired(e => e.destination)             .withoptional()             .willcascadeondelete(false);

when attempting update database following error

system.data.entity.infrastructure.dbupdateexception: error occurred while updating entries. see inner exception details. ---> system.data.updateexception: error occurred while updating entries. see inner exception details. ---> system.data.constraintexception: referential integrity constraint violation. dependent role has multiple principals different values. --- end of inner exception stack trace --- @ system.data.mapping.update.internal.tablechangeprocessor.diagnosekeycollision(updatecompiler compiler, propagatorresult change, compositekey key, propagatorresult other) @ system.data.mapping.update.internal.tablechangeprocessor.processkeys(updatecompiler compiler, list1 changes, set1 keys) @ system.data.mapping.update.internal.tablechangeprocessor.compilecommands(changenode changenode, updatecompiler compiler) @ system.data.mapping.update.internal.updatetranslator.d__0.movenext() @ system.linq.enumerable.d__711.movenext() @ system.data.mapping.update.internal.updatecommandorderer..ctor(ienumerable1 commands, updatetranslator translator) @ system.data.mapping.update.internal.updatetranslator.producecommands() @ system.data.mapping.update.internal.updatetranslator.update(ientitystatemanager statemanager, ientityadapter adapter) @ system.data.entityclient.entityadapter.update(ientitystatemanager entitycache) @ system.data.objects.objectcontext.savechanges(saveoptions options) @ system.data.entity.internal.internalcontext.savechanges() --- end of inner exception stack trace --- @ system.data.entity.internal.internalcontext.savechanges() @ system.data.entity.internal.lazyinternalcontext.savechanges() @ system.data.entity.dbcontext.savechanges() @ system.data.entity.migrations.dbmigrator.seeddatabase() @ system.data.entity.migrations.infrastructure.migratorloggingdecorator.seeddatabase() @ system.data.entity.migrations.dbmigrator.upgrade(ienumerable1 pendingmigrations, string targetmigrationid, string lastmigrationid) @ system.data.entity.migrations.infrastructure.migratorloggingdecorator.upgrade(ienumerable1 pendingmigrations, string targetmigrationid, string lastmigrationid) @ system.data.entity.migrations.dbmigrator.update(string targetmigration) @ system.data.entity.migrations.infrastructure.migratorbase.update(string targetmigration) @ system.data.entity.migrations.design.toolingfacade.updaterunner.runcore() @ system.data.entity.migrations.design.toolingfacade.baserunner.run() error occurred while updating entries. see inner exception details

is there better way model relationship between locations , deliveryrate. making mistake fluent api bit

one-to-one relationships separate foreign keys not supported entity framework. ef maps model shared primary keys, deliveryrate.id, deliveryrate.origin.id , deliveryrate.destination.id must have same value. have not in seed method cause of exception.

shared primary keys not useful model because never create deliveryrate has destination different origin.

you can solve problem modeling 2 relationships one-to-many:

modelbuilder.entity<deliveryrate>()     .hasrequired(e => e.origin)     .withmany()     .hasforeignkey(e => e.originid)     .willcascadeondelete(false);  modelbuilder.entity<deliveryrate>()     .hasrequired(e => e.destination)     .withmany()     .hasforeignkey(e => e.destinationid)     .willcascadeondelete(false);

Comments

Post a Comment

Popular posts from this blog

android - Why am I getting the message 'Youractivity.java is not an activity subclass or alias' -

-
Image
i created own android project , cut , pasted code exercise: http://androidexample.com/show_phone_contacts_in_autocomplete_suggestions_-_android_example%20/index.php?view=article_discription&aid=106&aaid=128# when build project no errors or warnings. when run project window error: annoyingly, can't make window smaller, can't click of buttons. cick 'x' @ top, close it. here's project structure: where getting 'autocompletemain' from? (note small c) class named autocompletemain. help. and have activity included in android manifest, in case you're wondering: <?xml version="1.0" encoding="utf-8"?> <manifest xmlns:android="http://schemas.android.com/apk/res/android" package="com.androidexample.autocompleteedittext" android:versioncode="1" android:versionname="1.0" > <uses-permission android:name="android.permission.read_phone_state...
Read more

python - How do I create a list index that loops through integers in another list -

-
i have list: sentences = ['the number of adults read @ least 1 novel within past 12 months fell 47%.', 'fiction reading rose 2002 2008.', 'the decline in fiction reading last year occurred among men.', 'women read more fiction.', '50% more.', 'though decreased 10% on last decade.', 'men more read nonfiction.', 'young adults more read fiction.', 'just 54% of americans cracked open book of kind last year.', 'but novels have suffered more nonfiction.'] and have list containing indexes of sequences of sentences in above list contain number. index_groupings = [[0, 1], [4, 5], [8]] i want extract specified sentence sequences in variable "sentences" using indexes in variable "index_groupings" following output: the number of adults read @ least 1 novel within past 12 months fell 47%.fiction reading rose 2002 2008. 50% more.though decreased 10% on last decade. just 54% of a...
Read more

c# - “System.Security.Cryptography.CryptographicException: Keyset does not exist” when reading private key from remote machine -

-
i trying decrypt data using certificate private key. works fine when certificate installed on local machine (i using self signed certificate testing , have private key certificate) when try access private key remote machine using same code, "keyset not exist" exception. i using console application testing, , have made sure id have read permissions on private key on remote server. here sample code using: var store = new x509store(@"\\server1\my", storelocation.localmachine); store.open(openflags.readonly); var result = store.certificates.find(x509findtype.findbysubjectname, "server1.test.com", false); var certificate = result[0]; store.close(); //this succeeds both local , remote server var rsapublic = (rsacryptoserviceprovider)certificate.publickey.key; //this succeeds local, fails remote server var rsaprivate = (rsacryptoserviceprovider)certificate.privatekey; here exception call stack unhandled exception: system.security.cryptography.crypto...
Read more