SELECT * FROM "dbo"."Woningen"
The code runs without the "dbo." prefix fine, but when it does, it throws the "table or view does not exist" problem. This is probable because the user does not have access to that schema since it is not a "dbo" user. I'm using the following Entity Framework code:
[Table("Woningen")] public class Woningen
When I try to update the Oracle nuget package, the message "Connection string is not well-formed" appears. As a result, it most likely contains the same fault as previously but failed earlier. The connectionString format I used is as follows:
<add name="DefaultConnection" providerName="Oracle.ManagedDataAccess.Client" connectionString="USER ID=testUser;PASSWORD=password; Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=serverUrl)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Database)));"/>
I see three potential fixes for this issue, but I have no clue how to put any of them into practise:
The current version should be acceptable since the existing code is already functional in production. Since the database and its user are new, their creation may be the source of the issue.