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.
User contributions licensed under CC BY-SA 3.0