edmgen验证的目的？比较SSDL和数据库模式？ [英] Purpose of edmgen validation? Comparing SSDL and database schemas?

问题描述

不知道EDMGEN正在验证什么此处

Not sure what the EDMGEN is validating here

它会根据实时数据库模式验证ssdl文件，以寻找不一致的地方）？

It validates the ssdl file against a live database schema looking for inconsistencies)?

仅验证ssdl之间的内部一致性，是csdl和msl文件吗？

Ot it only validates the internal consistency between the ssdl, csdl and msl files?

如果没有人手动更改自动生成的ssdl，csdl和msl文件的内容，是否有理由对其进行验证？

If nobody has changed manually the contents of the autogenerated ssdl, csdl and msl files is there any reason to validate them?

在Visual Studio中，将ConceptualEntityModel的在构建时验证属性设置为true时，此验证是否与运行的验证相同？

Is this validation the same that runs when "Validate On Build" property of the ConceptualEntityModel is set to true in visual studio?

有什么方法可以检查ssdl文件和实时数据库之间的一致性吗？ （例如新表，差异字段，外键等）。类似结果类似于Redgate SQLCompare在比较模式时提供的结果...

Is there any way to check consistency between ssdl file and live database? (like new tables, diferents fields, foreign keys, etc...) A similar results like the ones provided by Redgate SQLCompare when comparing schemas...

推荐答案

可以只验证ssdl，csdl和msl文件之间的内部一致性吗？

Ot it only validates the internal consistency between the ssdl, csdl and msl files?

它仅验证EDMX文件-这意味着SSDL，MSL和CSDL之间的一致性。

It validates only EDMX file - it means consistency between SSDL, MSL and CSDL.

在Visual Studio中，当ConceptualEntityModel的 Validate On Build属性设置为true时，此验证是否与运行相同？

Is this validation the same that runs when "Validate On Build" property of the ConceptualEntityModel is set to true in visual studio?

是

有什么办法吗来检查ssdl文件和实时数据库之间的一致性？

Is there any way to check consistency between ssdl file and live database?

这不是EDMGEN验证或实体框架的目的。如果您使用的是VS Premium或Ultimate版，则可以使用其数据库工具比较两个数据库，这与RedGate的SQL Compare相当。我不确定是否有任何工具可以将SSDL和真实数据库进行比较，但是您通常只需要执行一组集成测试，即可验证您的数据库仍适用于您的模型。

That is not purpose of EDMGEN validation or entity framework. If you have VS Premium or Ultimate edition you can use its database tools to compare two databases - that is mostly equivalent to RedGate's SQL Compare. I'm not sure if there is any tool to compare SSDL and the real database but what you usually only need is set of your integration tests which will validate that your database still works with your model.

这篇关于edmgen验证的目的？比较SSDL和数据库模式？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！