Why do I get this error when I'm trying to create models from database?

0

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.

c#
oracle
.net-core
entity-framework-core
asked on Stack Overflow May 5, 2021 by littleO

1 Answer

2

The fine manual says minimum oracle 11.2 for that provider

enter image description here

Upgrade your db or change provider

answered on Stack Overflow May 5, 2021 by Caius Jard

User contributions licensed under CC BY-SA 3.0