I have been struggling for more than a week trying to configure a c# app to connect and perform operations on an Oracle database using entity framework. The following is a summary of my actions:
- Installed ODT12 for VS2015, added EF 6.3 to the project, Oracle Managed Data Access 12.something using nuget package manager > Successfully able to generate EDMX. Everything was working just fine.
- New tables were added to the database. Attempt to update the EDMX failed! Update wizard simply not doing anything after checking the new tables that I wanted to add.
- Completely removed ODT12, rebooted, reinstalled ODT12 along with all nuget packages. Same result.
- Completely removed ODT12, rebooted, tried to install ODT18 but failed because even though I uninstalled ODT the installer complained that ODT is already installed.
- Followed the removal guide to completely remove everything oracle from the pc, no luck, still same error message.
By the way, if you have a web page with a "complete removal" guide then you know that the uninstaller does not uninstall everything. If you KNOW that the uninstaller does not uninstall everything why don't you just MAKE the uninstaller actually uninstall everything?
- Finally found a discussion suggesting that I should delete a registry key.
- I was able to install ODT18, updated all nuget packages to use managed access 18, rebuilt everything and then I tried opening the EDMX to update it. A message box showing "Exception has been thrown by the target of an invocation" pops up and after dismissing it nothing else happens, the EDMX does not open.
- After fruitlessly googling around I decided to reinstall ODT18. Now I am finally able to open the EDMX and see my old tables again.
- Tried to add the new tables again and this time the update wizard just vanishes with no error after choosing a data source. I tried following these steps Problems with Entity Framework wizard disappearing even though I'm using v18 not v19 and I'm uzing EZ connect, not TNS file. No luck.
- Reinstalled ODT18 again. Now the update wizard no longer vanishes but it also doesn't create the new tables.
- Deleted entire EDMX and tried to generate it again from scratch. Opened the wizard, chose a data source, checked all tables, clicked "Finish". A progress bar appeared and it seemed to do something. After it finished loading I was presented with an empty edmx.
- I now have an empty EDMX that I cannot add tables to.
I don't know what else to do.
Edit: I should also mention that I get this message in the output pane: "The model was generated with warnings or errors. Please see the Error List for more details. These issues must be fixed before running your application." The error list is empty, so is the warning list.