blocks|key|1274735|text|这通常是相当痛苦的。重新编译，关闭VS，打开它，等等。它应该可以工作，但对我来说总是有延迟。不过，使用LINQ手动创建模型可能会更容易，这就是我所做的。这样我就能完全控制它了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1274736|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|$]]

It's usually quite a pain. Recompile, shut down VS, open it back up etc. It should work, but for me there was always a delay. It may be easier to manually create your model using LINQ though which is what I do. That way I've got full control over it.

blocks|key|1489645|text|据我所知，设计器中没有内置的功能来使用数据库中的更改来更新表。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1489646|有一些第三方工具(http://www.huagati.com/dbmltools/)提供了这种功能。|offset|length|1489647|每当我遇到这个问题时，都是在一个已经设置了多个手动关系的表上有一两列，所以我只是编辑了->+(右键单击DBML并选择open+with+XML+XML)，并将这些列添加到表定义中。|1489648|当保存DBML文件时，关联的.designer.cs文件将自动更新为新添加的列的代码。因此，不需要在设计器模式下删除和重新创建表。|style|CODE|1489649|entityMap|0|LINK|mutability|MUTABLE|url|http://www.huagati.com/dbmltools/^0|0|9|X|0|0|0|E|C|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|U|8|@]|9|@$D|V|E|W|1|X]]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Z|8|@$D|10|E|11|J|K]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S]]]]

So far as I know there's no built-in functionality in the designer to update a table with changes in a database.

There are third party tools (<a href="http://www.huagati.com/dbmltools/" rel="nofollow noreferrer">http://www.huagati.com/dbmltools/</a>) that offer that sort of functionality.

Whenever I ran into this issue it was on the order of one or two columns on a table with multiple manual relationships already set up, so I just edited the XML (right click on the DBML and select open with -> XML) and added the columns to the table definition.

When DBML file is saved the associated <code>.designer.cs</code> file is automatically updated with code for newly added columns. Therefore, there is no need to drop and recreate table in designer mode.

blocks|key|1274881|text|没有自动刷新DBML或告诉DBML重新读取数据库的机制。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1274882|我认为最简单的方法是在设计器中打开dbml文件，删除表，然后将其重新添加到设计图面。尽管这可能取决于数据库的复杂性，即您可能会丢失某些信息。|1274883|我会先备份dbml文件，然后再尝试:)|1274884|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|$]]

There's no mechanism to automatically refresh the DBML or to tell the DBML to re-read the database.

I believe the easiest way is to open the dbml file in the designer, delete the table and then re-add it to the design surface. Although this may depend on the complexity of the database, i.e. you may lose certain information.

I'd backup the dbml file first before trying :)

blocks|key|1489768|text|如果您对模型进行了修改，则删除该表并重新添加它可能会导致比其价值更多的问题。在这些情况下，我建议手动修改设计器(或dbml文件)。请不要接触.Designer文件，因为这些更改将被覆盖。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1489769|另一个要考虑的替代方案是使用SqlMetal作为构建过程的一部分，以便从数据库重新生成模型。|1489770|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|$]]

If you have made modifications to your model, droping the table and re-adding it may cause more problems than it's worth. In those cases, I would recommend manually modifying the designer (or dbml file). Don't touch the .Designer file as those changes will be overwritten.

Another alternative to consider is to use SqlMetal as part of your build process to regenerate the model from the database.

blocks|key|1489840|text|我不能删除我的表并重新添加(这是最快的方法)，因为它在某个地方用作返回类型。如果你的数据库真的很复杂，这也可能是个坏主意。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1489841|对我来说最好的方法是：|1489842|Add+Same+to+dbml+Open+dbml+with+xml+edit+(右键单击->打开)从表中复制您刚添加的XML列部分，并粘贴到有问题的表的列部分中。保存Open+Dbml常规方式删除添加的表|1489843|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 couldnt delete my table and re-add (this is the quickest way) since its used as a return type somewhere. Also its probably a bad idea if your db is really complex

Best way for me was this:

Add Same Table to dbml
Open dbml with xml edit (right click -> open with)
Copy XML column section from table you just added and paste in column section of offending table.
Save
Open Dbml regular way
Delete added table

Is there a way I can refresh the dbml file or do I have to delete it and generate a whole new one?

Add column to the database - how do I update the dbml file?

有没有一种方法可以刷新dbml文件，或者我必须删除它并生成一个全新的文件？

问向数据库添加列-如何更新dbml文件？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问向数据库添加列-如何更新dbml文件？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问向数据库添加列-如何更新dbml文件？
EN