Recent study by asp.net core EFcode connecting oracle database, VS2019, some reference libraries also have references, data for 11 g, you have the account and password to modify the connection string test, if the wrong password prompt validation is not through, only input the correct account and password can hint at the back of the mistake, therefore can be connected to the conclude that the database is normal, but I don't know why the execution Tests. The ToList (); There will be a TABLE or view does not exist, use the same user name and password after login database query is this TABLE, don't know why, the know please teach,

CodePudding user response:

I only use a few times oracle.
But I remember he is with the concept of namespaces,

CodePudding user response:

Don't know if this reason,
Will you at the time of query execution, similar to select a library name in MSSQL

CodePudding user response:

No one encounter such a situation? Do you usually use what is ASP.NET MVC even database?

CodePudding user response:

No use EFCODE link oracle player?

CodePudding user response:

Met, have a problem seems to be generated model
.net code for ef now only experience version of oracle, don't feel very good, some will be submitted to the oracle error,
Most of the functionality or can use, is the need to change in some places complains

CodePudding user response:

Plus a try?

CodePudding user response:

DataAnnotation TEST table name in capitals

CodePudding user response:

This kind of circumstance should be to do mapping,,

CodePudding user response:

Connect the pit of Oracle point is more, you can refer to the answer in https://bbs.csdn.net/topics/395439418,
You said the problem now is 7th floor, the TEST need all uppercase, then all your entity name also need capital (including the fields) ~

 
Public class TEST 
{
Public string ID {get; set; } 
Public string NAME {get; set; } 
Public int the AGE {get; set; } 
} 
Public DbSet TESTS (); 

And retrieved from the database field in the header of what I remember is 1 case would mess... This was what I remember, you try it,

CodePudding user response:

This may be the problem of database, built table time to distinguish between the case and resources

CodePudding user response:

Look at the table name is consistent