Oracle Entity Framework with ASP.NET Core Web API

0

I want to develop Web API using ASP.NET Core 2.1. Our backend is Oracle 12c.

I would like to use Entity Framework with a code-first approach. I tried with Oracle.EntityFrameworkCore as explained in this Youtube video: https://www.youtube.com/watch?v=RDZXJYLUC7I

but I am getting an error when I try to run update-database command in the Package Manager console. I think, I need Oracle client 19c to be installed. But that is the limitation with our organization that we cannot install Oracle client on our application server.

Please let me know any alternate solution where I can use Entity Framework with ASP.NET Core 2.1 with code-first approach and without installing Oracle client ?

2020-03-14 16:37:32.188745 ThreadID:1 (ERROR) OracleDatabaseCreator.Exists() : OracleException.Number: 12592
2020-03-14 16:37:32.200213 ThreadID:1 (ERROR) OracleDatabaseCreator.Exists() : Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12592: Network Session: Invalid NS packet format (likely marker packet)

OracleInternal.Network.NetworkException (0x00003130): ORA-12592: Network Session: Invalid NS packet format (likely marker packet)

at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor) at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName) at OracleInternal.ConnectionPool.PoolManager3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch) at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch) at OracleInternal.ConnectionPool.OracleConnectionDispenser3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria) at Oracle.ManagedDataAccess.Client.OracleConnection.Open() at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Oracle.EntityFrameworkCore.Storage.Internal.OracleDatabaseCreator.Exists() Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12592: Network Session: Invalid NS packet format (likely marker packet) ---> OracleInternal.Network.NetworkException (0x00003130): ORA-12592: Network Session: Invalid NS packet format (likely marker packet) at OracleInternal.Network.OracleCommunication.DoConnect(String tnsDescriptor) at OracleInternal.ServiceObjects.OracleConnectionImpl.Connect(ConnectionString cs, Boolean bOpenEndUserSession, OracleConnection connRefForCriteria, String instanceName) at OracleInternal.ConnectionPool.PoolManager3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch) at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch) at OracleInternal.ConnectionPool.OracleConnectionDispenser3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria) at Oracle.ManagedDataAccess.Client.OracleConnection.Open() at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenDbConnection(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Oracle.EntityFrameworkCore.Storage.Internal.OracleDatabaseCreator.Exists() at Microsoft.EntityFrameworkCore.Migrations.HistoryRepository.Exists() at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration) at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType) at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action) ORA-12592: Network Session: Invalid NS packet format (likely marker packet)`

c#
oracle
entity-framework
asp.net-core-webapi
asked on Stack Overflow Mar 14, 2020 by user1957116 • edited Mar 14, 2020 by marc_s

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0