blocks|key|3120153|text|如果您的FK可以为空，则主体实体中的重数必须为0..1+-默认值与此无关，因为您可以将null赋值给FK。所以你所有的依赖实体必须与你的主体实体有0..1+-*的关系。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3120154|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|236069|text|我刚刚收到了相同的消息，这很令人费解，因为我在数据库中修改的表与我收到消息的表不同。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|236070|我尝试更改重数为0..1对多，但消息仍然存在，即使在“运行自定义工具”命令、清理和重建之后也是如此。|236071|已通过删除EF抱怨的关系并从DB更新模型来解决|236072|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

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

blocks|key|238529|text|右键单击EDX图中的关系。在属性中，将END1多重性更改为0..1+(零或YOURTABLENAME之一)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|238530|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Right click on the relationship in your EDX diagrame.
In proprety, change END1 Multiplicity to 0..1 (Zero or One of YOURTABLENAME)

blocks|key|239748|text|我从模型中删除了更新的表，然后在从数据库更新模型中，再次添加它，这很有帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239749|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I deleted the updated table from the model and then in Update Model from Database, added it again and it helped.

blocks|key|241480|text|我使用数据库优先的方法来创建.edmx文件。当我遇到这个问题时，我尝试了上面的几个建议，但仍然收到错误，所以我删除了.edmx文件，并从更新的数据库中刷新了整个文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|241481|我发现，有时EF在更新现有数据库后会感到困惑，虽然找到根本原因是理想的，但在工作环境中(比如我的)花一个小时做一些事情可能是不可能的。|241482|我们的数据库是新的和小的，所以刷新文件很容易，而且不会花太长时间。|241483|问题消失了，继续前进。。。|241484|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

I'm using a database first approach to create the .edmx file. When I ran into this issue, I tried a couple of the suggestions above, but was still getting errors, so I deleted the .edmx file and refreshed the entire file from the updated database.

I've found that sometimes EF gets confused after updates to the existing database, and while it's ideal to find the root cause, spending an hour working on something may not be possible in a work environment (such as mine)

Our DB is new and small so refreshing the file is easy and doesn't take that long. 
Problem went away, moving on . . .

blocks|key|2905965|text|在添加了一个新表之后，我也遇到了同样的问题，我尝试了这里的所有解决方案，包括删除关系，但都不起作用。对我有效的解决方案是完全删除模型并创建一个新模型。不要忘记删除web.config中的连接字符串，以便您的新EF能够使用相同的名称。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2905966|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had the same problem after adding a new table, I tried all the solutions here including dropping the relationship, but that didn't work. The solution that worked for me was to actually delete the model completely and create a new model. Don't forget to delete the connection string in the web.config so that your new EF will be able to use the same name.

blocks|key|239767|text|此错误主要是因为在添加到EF后，表定义可能已更改。解决方案是将其从EF模型中删除，然后使用数据库中的更新模型重新添加。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|239768|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This error is mainly because the table definitions might have changed after adding to the EF.
The solution is to delete it from EF Model and add again using update model from database.

blocks|key|238570|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|238571|将Multiplicity="1“更改为Multiplicity="0..1”|blockquote|238572|238573|238574|+<Association+Name="FK_O_Personel_PBS_AtanmaSekilleri">
++++++++++<End+Type="eKampus_RTEUModel.PBS_AtanmaSekilleri"+Role="PBS_AtanmaSekilleri"+Multiplicity="0..1"+/>
++++++++++<End+Type="eKampus_RTEUModel.O_Personel"+Role="O_Personel"+Multiplicity="*"+/>
++++++++++<ReferentialConstraint>
++++++++++++<Principal+Role="PBS_AtanmaSekilleri">
++++++++++++++<PropertyRef+Name="ID"+/>
++++++++++++</Principal>
++++++++++++<Dependent+Role="O_Personel">
++++++++++++++<PropertyRef+Name="atamaSekliID"+/>
++++++++++++</Dependent>
++++++++++</ReferentialConstraint>
++++++++</Association>|code-block|syntax|javascript|238575|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|M|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|N|7|@]|8|@]|9|$]]|$1|D|3|-4|4|5|6|O|7|@]|8|@]|9|$]]|$1|E|3|-4|4|5|6|P|7|@]|8|@]|9|$]]|$1|F|3|G|4|H|6|Q|7|@]|8|@]|9|$I|J]]|$1|K|3|-4|4|5|6|R|7|@]|8|@]|9|$]]]|L|$]]

<blockquote>
 Change Multiplicity="1" to Multiplicity="0..1"
</blockquote>

<pre><code> &lt;Association Name="FK_O_Personel_PBS_AtanmaSekilleri"&gt;
 &lt;End Type="eKampus_RTEUModel.PBS_AtanmaSekilleri" Role="PBS_AtanmaSekilleri" Multiplicity="0..1" /&gt;
 &lt;End Type="eKampus_RTEUModel.O_Personel" Role="O_Personel" Multiplicity="*" /&gt;
 &lt;ReferentialConstraint&gt;
 &lt;Principal Role="PBS_AtanmaSekilleri"&gt;
 &lt;PropertyRef Name="ID" /&gt;
 &lt;/Principal&gt;
 &lt;Dependent Role="O_Personel"&gt;
 &lt;PropertyRef Name="atamaSekliID" /&gt;
 &lt;/Dependent&gt;
 &lt;/ReferentialConstraint&gt;
 &lt;/Association&gt;
</code></pre>

blocks|key|3120295|text|它要求您将主体角色更改为0..1，而不是整个关系，以便关系变为0-1对多。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3120296|从1到0..1|3120297|Rebuild|unordered-list-item|3120298|
，右键单击edmx图形中的关系线，选择|3120299|(|ordered-list-item|3120300|+properties|3120301|Change+End1Multiplicity+(ReportCellImages)|3120302|3120303|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|V|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|K|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|K|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|R|$]]

It is asking you to change the Principal Role to 0..1 not the entire relationship so that the relation ship becomes 0-1 to Many.
<ol>
<li>Right click on the relationship line in the edmx graph</li>
<li>Select properties</li>
<li>Change End1Multiplicity (ReportCellImages) from 1 to 0..1</li>
<li>Rebuild</li>
</ol>

blocks|key|238546|text|删除实体类中的实体引用，然后手动删除数据库中的引用，然后将它们放回原处，以解决我在完成后意识到的问题，快速解决方案是在我首次将字段从可为空更改为不可为空之后，在上下文中使用WithRequired替换WithOptional。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|238547|protected+override+void+OnModelCreating(DbModelBuilder+modelBuilder)|offset|length|style|CODE|238548|entityMap^0|0|0|1W|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

After removing the Entity reference in the entity classes then removing the reference manually in the database, then putting them back step by step to resolve the issue I realized after I finished the quick solution would have been to replace the WithOptional with WithRequired in the Context after I first changed the field from nullable to non nullable.

<code>protected override void OnModelCreating(DbModelBuilder modelBuilder)</code>

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;

<blockquote>
 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'. 
</blockquote>

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?

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

数据库

我已经在我的数据库中放入了一个新表，并且有4个表与它有外键关系。我以为我以相同的方式配置了所有4个，但我得到了这个错误；错误15错误113:关系'FK_OtherLeaves_ReportCellImages‘中的角色'ReportCellImage’的重数无效。因为Dependent Role中的所有属性都可以为must，所以Principal Role的重数必须为'0..1‘。所以为了简化我的

问Entity Framework 4.0:错误113:角色中的重数无效
EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Entity Framework 4.0:错误113:角色中的重数无效EN

回答 10

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Entity Framework 4.0:错误113:角色中的重数无效
EN