blocks|key|1627162|text|将主键设置为所有表，或者只将一个未选中的复选框"Allow+null“设置为每个表的任何列。它适用于我:)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1627163|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|$]]

Set Primary Keys to all tables or just one unchecked check-box "Allow null" to any column of each table. It works for me :)

blocks|key|1627420|text|检查特定表中的“Nulls”。如果所有列都设置为“Allow+Null”，则Entity+Framework将其视为“Null”表。我也有同样的问题，没有勾选'Allow+Null‘，它就添加了所需的表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1627421|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|$]]

Check for 'Nulls' in your particular table. If all the columns are set to 'Allow Null' Entity Framework considers it as a 'Null' table. I had the same problem and unchecked 'Allow Null' and it added the required table.

blocks|key|1627440|text|不会添加没有主键的表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1627441|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|$]]

Tables without primary keys will not be added.

blocks|key|1412391|text|我的解决方案是删除整个模型并读取它，包括我想要的新表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1412392|我在设计器中不小心删除了一个表，无法读取它。因此，删除整个模型并读取它。|1412393|我对此也有一些问题(Ado.Net+Entity+Data+Model+Not+Updating+Correctly)|offset|length|1412394|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/774645/ado-net-entity-data-model-not-updating-correctly/774737#774737^0|0|0|A|1C|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

My solution to this is to delete the entire model and readd it including the new tables that I want. 

I accidentally deleted a table in the designer once and could not readd it. Hence removing entire model and readding it. 

I had some issues with this as well (<a href="https://stackoverflow.com/questions/774645/ado-net-entity-data-model-not-updating-correctly/774737#774737">Ado.Net Entity Data Model Not Updating Correctly</a>)

blocks|key|1412495|text|您不需要删除整个模型(可能有数百个表！)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1412496|向导可以处理“添加新的”项，但一些更改，如更改组合键和重命名列-它不知道该做什么-所以它不尝试-并且事情变得不同步。|1412497|因此:从模型(概念模式)和Model.Store中删除有问题的表，然后使用向导更新模型，然后重新添加有问题的表。|1412498|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|$]]

You do not need to delete the entire model (that might be hundreds of tables!).

The Wizard can handle "adding new" items, but some changes such as changing composite keys and renaming columns - it doesn't know what to do - so it doesn't try - and things get out of sync.

SO:
DELETE the tables in question from the Model (conceptual mode) AND from the Model.Store, and then Update the model using the Wizard, and re-add just the tables in question.

blocks|key|1627293|text|只是为那些以前没有做过这件事的人抛出更多细节。我使用的是安装了更新4的visual+studio+2013。我向一个表中添加了一些字段，从我的模型中删除了该表，然后转到update，它不允许我检查任何表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1627294|我确实有一个主键。|1627295|我创建了一个新的测试台，它出现了，它可以让我检查它，但不是我的原始。|1627296|我以前从来没有用XML打开过它，也不知道如何打开它。右键单击.edmx文件并“打开”--选择xml编辑器。|1627297|有问题的表就在那里，它甚至有新的字段(奇怪)。|1627298|我删除了对它的所有引用(用了几次)+--在您删除一个并保存之后，如果您尝试打开它，但它不显示，请继续并选择"view+XML“-查看错误，基本上跟随弹跳球，直到您将其清理干净。|1627299|希望这些额外的细节能帮助到别人。|1627300|乔|1627301|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|V|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|Y|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|Q|$]]

Just throwing out some more detail for anybody who has not had to do this before.
I am using visual studio 2013 with update 4 installed.
I added some fields to a table, deleted the table from my model then went to update and it would not let me check any of the tables.

I do have a primary key.

I created a new test table, that showed up and it would let me check it but not my original.

I have never opened it in XML before and did not know how to do that.
You right click on the .edmx file and "open with" -- choose the xml editor.

the table in question was there all right, it even had the new fields (strange).

I deleted all the references to it (took a couple times) -- after you delete one and save, if you try to open it and it won't display just go ahead and choose "view XML" - look at the errors and basically follow the bouncing ball until you have cleaned it up.

hope the extra detail helps somebody.

Joe

blocks|key|1412702|text|我发现的一种简单方法是(在SQL+Server+Management+Studio中)添加一个INT类型的ID列，取消选择"Allow+Nulls"，然后在列属性(of+ID)+>>+Identity+Specification+>>+check+(Is+Identity)下，确保设置了增量。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1412703|完成上述操作后，返回到.edmx窗口，右键单击，然后从数据库更新模型。|1412704|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

One easy way I found was to (in SQL Server Management Studio) add an ID column of type INT, deselect "Allow Nulls", and under Column properties (of ID) >> Identity Specification >> check (Is Identity), and make sure increment is set. 

Once the above is done, go back to your .edmx window, right-click, and Update Model from Database.

blocks|key|1412833|text|您可以添加主键列交叉表。然后问题就解决了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1412834|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|$]]

You can add a Primary Key column cross table. Then problem is resolving

blocks|key|1627543|text|另一种解决方案是确保您访问数据库的帐户对表有一定的权限，至少选择。如果该帐户没有该表的权限，则不会添加表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1627544|在SSMS的安全性下，右键单击用户或角色，然后单击属性。然后单击Securables。顶部的表格显示了当前可访问的表格。如果缺少的表不在那里，请单击search+and+find，然后在顶部的表中突出显示它们，然后在下部的表中分配权限|1627545|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

One other solution is to ensure the account you are accessing the database via has some permissions to the table, Select at least. The table won't be added if the account has no permissions to it.
In SSMS under Security, right click the user or role, then Properties. Then click on Securables. The top table shows tables currently accessible. If the missing tables aren't there, click on search and find then, highlight them in the top table, then assign permissions in the lower table

I <a href="https://i.stack.imgur.com/5CduL.png" rel="nofollow noreferrer">added a new ADO.Net Entity Data Model</a> into my project and used the <a href="https://i.stack.imgur.com/c4Pju.png" rel="nofollow noreferrer">Update Wizard</a> to add tables into the model. Five of the selected tables were added to the design surface. Two other tables will not add. I select them in the wizard and click Finish, yet they never show up on the design surface.

Is this a bug, or are there some situations where a table cannot be added to the model (by design)?

<hr />

UPDATE: The XML (*.edmx) reveals the problem. 

<pre><code>&lt;!--Errors Found During Generation:
warning 6013: The table/view 'FooBar.dbo.Roles' does not 
have a primary key defined and no valid primary key could be inferred. 
This table/view has been excluded. To use the entity you will need to 
review your schema, add the correct keys and uncomment it.--&gt;
&lt;!--&lt;EntityType Name="Roles"&gt;
 &lt;Property Name="role_id" Type="decimal" /&gt;
 &lt;Property Name="role_desc" Type="nvarchar" MaxLength="30" /&gt;
&lt;/EntityType&gt;--&gt;
</code></pre>

ADO.NET Entity Framework: Update Wizard will not add tables

SQL Server

数据库

我使用进入我的项目并使用将表添加到模型中。所选表中的五个已添加到设计图面。另外两个表将不会添加。我在向导中选择它们并单击Finish，但它们从未出现在设计图面上。这是一个bug吗?或者在某些情况下，表不能被添加到模型中(根据设计)？更新: XML (*.edmx)揭示了这个问题。<!--Errors Found During Generation:warning 6013: The table/v

问ADO.NET实体框架:更新向导将不添加表
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ADO.NET实体框架:更新向导将不添加表EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ADO.NET实体框架:更新向导将不添加表
EN