实体框架配置驱动
我有两个 Web 服务，除了配置文件之外，它们彼此相同。但是，两者都使用实体框架 4 将数据存储在表中，并且当前指向同一个表。如何根据某些配置设置将它们拆分为使用不同的表。
理想情况下，我不想创建单独的数据库，因为我将拥有几种此类类型的孪生服务，并且我的托管提供商对额外的数据库实例收取更多费用。此外，每个表在逻辑上应该属于同一个数据库。我希望这两个模型指向两个具有不同名称的相同表。这可能吗？
更新
如果没有方法可以做到这一点。我可以复制实体并使用配置条目在两个模型之间切换。
I have two web services which are identical to each other apart from the configuration files. However, both use Entity Framework 4 to store their data in a table and are currently pointing to the same table. How can I split these to use different tables based on some configuration setting.
Ideally I do not want to create a seperate database as I will have several of these types of twin services and my hosting provider charges more for extra database instances. Also each table should logically belong to the same database. I want the two models to point to two identical tables with different names. Is this possible.
UPDATE
If there is no method of doing this. I can make a copy of the entity and use a config entry to switch between the two models.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我认为唯一可能的方法是 从 EDMX 文件中提取 CSDL、MSL 和 SSDL 文件。每种类型的配置都需要单独的 SSDL 和 MSL。 SSDL是描述数据库表的XML，MSL是描述对象和表之间的映射的XML。您必须重命名第二组文件中的表。然后，您将在每个部署场景中使用正确的这些文件集来使用连接字符串。
I think the only possible way is extracting CSDL, MSL and SSDL files from EDMX file. You will need separate SSDL and MSL for each type of configuration. SSDL is XML describing database tables and MSL is XML describing mapping between objects and table. You will have to rename table in second set of these files. Then you will use connection string using correct set of these files in your each deployment scenario.