I'm trying to create models from my Oracle database 10g using Entity Framework Core 5 dbcontext scaffold
:
dotnet ef dbcontext scaffold "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=mssrv.infofer.local)(PORT=1533)))(CONNECT_DATA=(SERVICE_NAME=medusa)));User ID=TRAFICALERT_EFC;Password=traficalert" Oracle.EntityFrameworkCore -o Entities -f
However, I got the following error:
2021-05-05 08:21:12.783360 ThreadID:1 (ERROR) OracleDatabaseModelFactory.Cre
ate() : Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00904
: "DEFAULT_COLLATION": invalid identifier
at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32&
cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementTyp
e, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& has
MoreRowsInDB, Boolean bFirstIterationDone)
at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConn
ectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors
, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean b
FirstIterationDone)
at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String comma
ndText, OracleParameterCollection paramColl, CommandType commandType, OracleConn
ectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, I
nt64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnFor
Execution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionP
aramColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 interna
lInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection conn
ection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrian
ParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requer
y, Boolean fillRequest, CommandBehavior behavior)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader()
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteScalar()
at Oracle.EntityFrameworkCore.Scaffolding.Internal.OracleDatabaseModelFactory
.<Create>g__GetCollation|9_0(DbConnection connection, String schema)
at Oracle.EntityFrameworkCore.Scaffolding.Internal.OracleDatabaseModelFactory
.Create(DbConnection connection, IEnumerable`1 tables, IEnumerable`1 schemas)
Why do I get this error when I'm trying to create models from database?
Thank you.
The fine manual says minimum oracle 11.2 for that provider
Upgrade your db or change provider
User contributions licensed under CC BY-SA 3.0