当VS2010中sql server架构更改时更新XSD文件
我遇到了一个看似简单的问题，但当我更改 sql server 数据库中的架构时，我不知道如何让 VS2010 更新我的 .xsd 文件。
到目前为止我已经找到了两个建议。
首先右键单击 xsd 文件并选择“运行自定义工具”。据我所知，这不会更新 XSD，因为我添加的表没有出现，并且具有新列的表也没有更新。
第二个选项是删除 xsd 文件，然后重新添加数据源。此方法显然会更新表，但我为 UI 添加的任何查询都会丢失。
因为这是一个相当大的数据模型，我预计架构将会发生变化（我们仍处于该过程的早期阶段）。此时，我唯一的办法似乎是将我的 UI 特定查询移到该数据库中，因为函数是存储过程...
是否有最佳实践（或者我在这个工具集中非常缺少的东西）？
I am having what seems to be a simple problem but I can't figure out how to get VS2010 to update my .xsd file when I change the schema in my sql server database.
I have found two recommendations thus far.
The first to right click the xsd file and 'Run Custom Tool'. This does not update the XSD as far as I can tell since I my added table doesn't appear and a table with a new column isn't updated.
The second option is to delete the xsd file and then re-add the datasource. This method obviously updates the tables but any queries that I added for the UI are lost.
Because this is a fairly large data model I expect that there will be changes (we are still early in the process) to the schema. At this point it appears that my only recourse will be to move my UI specific queries into that database as functions are stored procedures...
Is there a best practice for this (or something I'm terribly missing with this toolset)?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论