实体框架向导不显示在Oracle数据库中添加的新表 [英] Entity Framework Wizard not showing new tables added in Oracle database

问题描述

这是有关昨天的问题：无法更新数据库，从由于TNS错误实体数据模型

This is relevant to yesterday's question: Cannot update Entity data model from database due to TNS error

我已经安装了32位ODAC，所以现在我可以看到我的.edmx文件了。但现在我试图从Oracle数据库更新我的数据模型。我在配置文件中选择连接，连接到它，当它提示我添加/更新/删除表时，没有表出现。我不能在添加屏幕上选择任何复选框，当我按完成时也没有任何反应。我也试着删除.edmx文件并生成从数据库中一个新的，但是也没有表显示在所有的时候我尝试添加所有这些，复选框不能被选中。

I've got 32-bit ODAC installed so now I'm able to see my .edmx file just fine. But now I'm trying to update my data models from an Oracle database. I select the connection in my config file, connect to it, and when it prompts me to add/update/delete tables, there are no tables that come up. I can't select any checkboxes on the add screen either, and nothing happens when I press Finish. I've also tried deleting the .edmx file and generate a new one from the database, but again, no tables show up at all when I try to add all of them and the checkbox cannot be selected.

我检查了使用Microsoft SQL Server的Entity的另一个项目，它看起来像是正常工作。我完全困惑，为什么这不工作...

I checked another project that uses Entity with Microsoft SQL Server and it looks like it works just fine. I'm completely baffled why this doesn't work...

我相信我的web.config文件我的连接字符串是正确的，因为我可以运行应用程序很好有什么建议么？

I believe my connection string in my web.config file is right since I'm able to run the app just fine. Any suggestions?

编辑：我查看了删除选项卡，并显示了我的模型中的所有表。我知道当我去这个选项卡，它显示当前不在数据库中的所有模型。在.edmx文件中，在删除选项卡下显示的所有模型实际上都是在数据库中。奇怪的...

I checked the Delete tab, and it shows all of the tables in my model. I know that when I go to this tab, it displays all of the models that are currently not in the database. All of the models in my .edmx file that are showing up under the Delete tab are in fact, in the database. Weird...

推荐答案

最后不得不数据库到MS SQL服务器切换。没有完全解决问题，但是我在一个截止日期，似乎是无法解决的（暂时的）。

Ended up having to switch the database over to MS SQL server. Didn't exactly solve the problem, but I'm on a deadline and seemed like it's unsolvable (for the time being).

这篇关于实体框架向导不显示在Oracle数据库中添加的新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！