A Dependent Role has multiple principals with different values

c# entity-framework

Question

I am using Enitity Framework codefirst and I have the 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 do not want to define the relationship on Location. When I update the database, it works but I get a referential integrity error when I run my seed code. I have tried to configure it using fluent api as follows

modelBuilder.Entity<DeliveryRate>()
            .HasRequired(e => e.Origin)
            .WithOptional()
            .WillCascadeOnDelete(false);

modelBuilder.Entity<DeliveryRate>()
            .HasRequired(e => e.Destination)
            .WithOptional()
            .WillCascadeOnDelete(false);

When attempting to update the database I get the following error

System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.ConstraintException: Referential integrity constraint violation. A Dependent Role has multiple principals with different values. --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.TableChangeProcessor.DiagnoseKeyCollision(UpdateCompiler compiler, PropagatorResult change, CompositeKey key, PropagatorResult other) at System.Data.Mapping.Update.Internal.TableChangeProcessor.ProcessKeys(UpdateCompiler compiler, List1 changes, Set1 keys) at System.Data.Mapping.Update.Internal.TableChangeProcessor.CompileCommands(ChangeNode changeNode, UpdateCompiler compiler) at System.Data.Mapping.Update.Internal.UpdateTranslator.d__0.MoveNext() at System.Linq.Enumerable.d__711.MoveNext() at System.Data.Mapping.Update.Internal.UpdateCommandOrderer..ctor(IEnumerable1 commands, UpdateTranslator translator) at System.Data.Mapping.Update.Internal.UpdateTranslator.ProduceCommands() at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() --- End of inner exception stack trace --- at System.Data.Entity.Internal.InternalContext.SaveChanges() at System.Data.Entity.Internal.LazyInternalContext.SaveChanges() at System.Data.Entity.DbContext.SaveChanges() at System.Data.Entity.Migrations.DbMigrator.SeedDatabase() at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.SeedDatabase() at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable1 pendingMigrations, String targetMigrationId, String lastMigrationId) at System.Data.Entity.Migrations.Infrastructure.MigratorLoggingDecorator.Upgrade(IEnumerable1 pendingMigrations, String targetMigrationId, String lastMigrationId) at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration) at System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update(String targetMigration) at System.Data.Entity.Migrations.Design.ToolingFacade.UpdateRunner.RunCore() at System.Data.Entity.Migrations.Design.ToolingFacade.BaseRunner.Run() An error occurred while updating the entries. See the inner exception for details

Is there a better way to model the relationship between Locations and DeliveryRate. Am I making a mistake with the fluent api bit

1
3
10/1/2014 7:06:53 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

One-to-one relationships with separate foreign keys are not supported by Entity Framework. EF maps your model with shared primary keys, that is DeliveryRate.Id, DeliveryRate.Origin.Id and DeliveryRate.Destination.Id must all have the same value. They probably have not in your Seed method which is the cause of the exception.

Shared primary keys are not useful for your model because you could never create a DeliveryRate that has a Destination different from Origin.

You can solve the problem by modeling the two relationships as 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);
4
3/18/2013 6:51:07 PM

Popular Answer

This error is thrown when there is a mistake in relationship mapping, it could be mapping two reationships to the same foreign key property:

modelBuilder.Entity<TipOrder>().HasRequired(c => c.Tip).WithMany(x => x.TipOrders).HasForeignKey(x => x.TipId).WillCascadeOnDelete(false);
modelBuilder.Entity<TipOrder>().HasRequired(c => c.Order).WithMany(x => x.TipOrders).HasForeignKey(x => x.TipId).WillCascadeOnDelete(false);

both map, accidently, to TipId.

Martin Staufcik

Related Questions

Error with Entity Framework Associations Because the attributes of the Dependent Role are not the most important ones.

Using Entity Framework 4.1...I have the following tables I'm using with Entity Framework...User... ( UserId PK identity, UserName, Password )...Physician... ( PhysicianId unique identity, UserId refereces User PK, PhysicianName )...PhysicianSite... ( SiteId, Location, PhysicianId FK to Physician table)...Problem. Entity Framework would not allow me...
c# dns domain-driven-design entity entity-framework
asked by Quinntyne

SimpleMembership MVC 4 get data from UserProfile having role in webpages_Roles

I have the following code. But there must be a more database efficient way to do this, because, correct me if Im wrong the number of database queries is (1 + (qty of users with admin role))...With a new MVC 4 project the membership defaults are the tables UserProfile, webpages_Roles and webpages_UsersInRoles. I see lots of built in methods for R...
asp.net-mvc asp.net-mvc-4 entity-framework
asked by Marc

Multi-tenancy in EF6 with multiple schemas having the same tables

In our system it has become required to provide a multi-tenant solution, where each tenant has the same data structure....During investigation I came across an article discussing multi-tenancy with EF4.1....http://romiller.com/2011/05/23/ef-4-1-multi-tenant-with-code-first/...This looks like a sensible solution, but we would prefer to avoid multipl...
.net c# entity-framework entity-framework-6 sql-server
asked by Dark Templar

"The number of properties in the Dependent and Principal Roles in a relationship constraint must be identical" issue in entity framework

I'm using .NET framework 4.0 with Entity Framework v6 code-first....I am creating 3 tables ("...Indicadores...", "...Campos..." and "...Codigos...") which use composite primary keys, but I am receiving an error when generating the model:...One or more validation errors were detected during model generation:...Codigos_Campos_Target_Codigos_Campos_So...
c# ef-code-first entity-framework
asked by aquiles

Update Database using Entity Framework having primary key on multiple Columns

Following is the error message I get:...Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. See ...http://go.microsoft.com/fwlink/?LinkId=472540... for information on understanding and handling optimistic concurrency exceptions....My model consis...
asp.net-mvc asp.net-mvc-4 c# entity-framework linq
asked by Hello

Entity Framework relationships between different DbContext and different schemas

So, I have two main objects, Member and Guild. One Member can own a Guild and one Guild can have multiple Members....I have the Members class in a separate DbContext and separate class library. I plan to reuse this class library in multiple projects and to help differentiate, I set the database schema to be "acc". I have tested this library exte...
c# dbcontext entity-framework foreign-keys repository
asked by ScubaSteve

Get all user for role or all roles for user

I am using ...Identity 2... and ...EF 6... and I would like to get a list of role objects for a user id or a list of user object for a roleId....IEnumerable<TRole> GetUserRoles<TRole>(string userId) where TRole : class, IRole<string> IEnumerable<TUser> GetRoleUsers<TUser>(string roleId) where TUser : class, IUser<string> ...Entity framework does n...
asp.net asp.net-identity entity-framework-6
asked by Ablue

How to compute dependent fields and combine rows with null values in TPH

If I have a ...De-normalized... table like this :...FinanceList (NetSales,Expenses,Receivables,...etc,Discriminator) ...And I have another table (...PeriodType...) which i categorize the year according to two methods :...Quarter... (4 periods)...1-...Period1... From Jan to Mar...2-...Period2... From Apr to Jun...3-...Period3... From Jul to Sep...4-...
dapper entity-framework sql sql-server sql-server-2012
asked by Anyname Donotcare

Select multiple columns from table based on different set of multiple columns

I'm trying to get query like this from LINQ/EF6 in C#...SELECT "ID_column" FROM "Entity" WHERE ("ColumnA","ColumnB") IN (('Value_0_0','Value_0_1'),('Value_1_0','Value_1_1'), ...); ...But I'm getting the following error for the code bellow...Unable to create a constant value of type 'Anonymous type'. Only primitive types or enumeration types are s...
.net c# entity-framework-6 linq postgresql
asked by user1833414

Having issues with a dependent property in a referential restraint

I keep getting this error when I try to submit to the database:...A dependent property in a ReferentialConstraint is mapped to a store-generated column. Column: 'NPPRProvId'...Here's where it breaks:...public static bool Save(NPPR_Provider provider, State state, string filename, bool validateBeforeSave = true ) { using (var db = new NPPRContext...
.net c# entity-framework-6
asked by Jonathan Kuhl

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow