Error 113 in Entity Framework 4.0: Multiplicity is not acceptable in Role

entity-framework

Question

I have put a new table in my database and there are 4 tables that have a foreign key relationship with it. I thought I configured all 4 in the same way, but I get this error;

Error 15 Error 113: Multiplicity is not valid in Role 'ReportCellImage' in relationship 'FK_OtherLeaves_ReportCellImages'. Because all the properties in the Dependent Role are nullable, multiplicity of the Principal Role must be '0..1'.

So to simplify my tables;

ReportCellImage table contains the ReportCellImageId field which in the primary key and an integer

OtherLeave table contains the ReportCellImageId field as a nullable foreign key with a default of 4

The other tables are similar and all have a foreign key configured to join with the ReportCellImage table

This is a recent change, so when I update my edmx file from the database, why do I get this error and how do I fix it?

1
66
2/28/2014 9:56:21 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

If your FK is nullable your multiplicity in principal entity must be 0..1 - default value has no role in this because you can assign null to FK. So all your dependent entities must be in 0..1 - * relation with your principal entity.

59
2/15/2012 11:50:47 AM

Popular Answer

I just had the same message and it was perplexing because the tables I modified in the DB were different from the ones I was getting the message for.

I tried changing the multiplicity 0..1-to-many but the message persisted, even after "Run Custom Tool" commands, cleans and rebuilds.

Resolved by dropping the relationship EF was complaining about and updating the model from DB

Sten Petrov

Related Questions

Entity Framework 4.0 with WCF 4.0 DataContractSerializer Error

This was a pain to figure out but it is because EntityFramework creates a 'proxy' of your class. The TestObject class I had was setup correctly, but it was creating a class called: TestObject_240F2B681A782799F3A0C3AFBE4A67A7E86083C3CC4A3939573C5410B408ECCE...To make the ChannelFactory + WCF + Entity Framework all work together, you must go into you...
.net entity-framework
asked by Brandon

When utilizing entity framework with Visual Studio 2010.net 4.0, you get a 'datetime2' issue.

Entity framework handles all the dates as a Datetime2, so, if your fields in the database are Datetime, this could be a problem. We had the same problem here, and from what we found, populating all the date fields and changing the datatype, are the most commom solutions
c# entity-framework sql-server sql-server-2008
asked by Tejo

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

Entity Framework requires foreign keys to link to a table's primary key. However, the primary key to Entity Framework does not have to match the primary key in the database. If you tell EF the PhysicianId is the primary key, it won't go checking if it really is. And it will happily accept foreign keys to the PhysicianId....If you have some foreign ...
c# dns domain-driven-design entity entity-framework
asked by user743382

First, ASP.NET MVC code: Multiplicity is not acceptable in relationship roles.

I think you should have a collection of pages in your campaign, instead of the 2 children-entities,...has been a while since I've last coded in MVC but if I recall correctly it should be something like:...public virtual Collection<Page> pages ...in which you then put your 2 pages
asp.net c# entity-framework
asked by Karel-Jan Misseghers

EF6 Code First "Foreign Key Multiplicity is not valid in Role"

I'm somewhat new to EF. My situation can't be that unique, but I've been unable to find a good answer for it. ...I have three tables. First two are ...Company... and ...Client.... ...Client... has a ...CompanyId... foreign key back to the company whose client they are. Both ...Company... and ...Client... have an ...AddressId... foreign key to an ..
c# ef-code-first entity-framework entity-framework-6
asked by BrandonP72

EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship

I'm attempting to do the following:...public class class1 { public int Id {get;set;} [ForeignKey("Class2")] public int Class2Id {get;set;} public virtual Class2 Class2 {get;set;} } public class class2 { public int Id { get; set;} [Required] public virtual int Class1Id {get;set;} [Required] [ForeignKey("Class1Id"...
c# database ef-code-first entity-framework entity-framework-6
asked by JensOlsen112

Entity Framework 6.1.3 and SQL Server CE 4.0 - No Entity Framework provider found

PROBLEM: I had a website that was working with my local dev machine (VS2013, EF6.1.3, SQl Server CE 4.0, EF Tools installed). I maintain the website using a git repo locally and in VS OnLine....I am at a different (temporary) location with a new machine. I fetched the website from my git repo down to this new machine. All seemed to work OK (coul...
ef-database-first entity-framework-6 git sql-server-ce-4
asked by RRRSR

error 2019: Member Mapping specified is not valid using Entity Framework Code First

I am implementing Entity Framework Code-First methodology in my project and got stuck in an issue....Error Details:... 18,12) : error 2019: Member Mapping specified is not valid. The type 'Edm.Byte[Nullable=False,DefaultValue=]' of member 'status' in type 'IMS.DAL.Users_mast' is not compatible with 'SqlServer.binary[Nullable=False,DefaultValue=...
c# entity-framework
asked by Agnib

How to resolve " Multiplicity is not valid in Role" error?

I have the following model:...public class Retailer : Entity { public string Name { get; set; } public string Address { get; set; } public virtual ICollection<Product> Products { get; set; } public virtual ICollection<Customer> Customers { get; set; } } public class Product : Entity { public string Name { get; set; } public...
c# entity-framework
asked by DaveDev

Entity Framework error: The ForeignKeyAttribute on property is not valid

I receive error then trying to add AgendaType to database context:...An unhandled exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll Additional information: The ForeignKeyAttribute on property 'AgendaType' on type 'MyDb.Agendum' is not valid. The foreign key name 'FK_Agenda_AgendaType' was not found on the depend...
c# entity-framework entity-framework-6
asked by amuliar

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