Entity Framework Core : connect to Oracle database

Question

In a .NET 5.0 framework project, I have referenced the following packages:

<PackageReference Include="Oracle.EntityFrameworkCore" Version="5.21.1" />
<PackageReference Include="Oracle.ManagedDataAccess.Core" Version="3.21.1" />

in ConfigureSettings method I have added this code:

services.AddDbContext<IMyDbContext, MyDbContext>((provider, options) =>
        {
            OracleConfiguration.OracleDataSources.Add("dev", "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP )(HOST = <host> )(PORT = 1521 )) (CONNECT_DATA = (SERVICE_NAME = DEV ) ) )");
            options.UseOracle(connectionString);
        });

services.AddScoped(sp => (MyDbContext)sp.GetRequiredService<IMyDbContext>());

services.AddEntityFrameworkOracle();

Later in my service, I am trying to query a simple result:

await _dataContext.MyTable.CountAsync(cancellationToken)

but I get the following error (Error message is in German):

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-12154: TNS: Angegebener Connect Identifier konnte nicht aufgelöst werden

OracleInternal.Network.NetworkException (0x00002F7A): ORA-12154: TNS: Angegebener Connect Identifier konnte nicht aufgelöst werden

The same time I have created a connection in Visual Studio Server Explorer with the following Connection string:

Data Source=dev;Persist Security Info=True;User ID=*******;Password=***********;Unicode=True

and it's enough to get query data.

What do I wrong in my project setup?

You might want to try HOST = dev in your TNS connect string. Basically the connect string is simply incorrect and you have to get it right — Nick.Mc
– Nick.Mc, Commented Jul 26, 2021 at 11:33
@SvyatoslavDanyliv thank you! connectionstrings.com/net-framework-data-provider-for-oracle/… has solved my problem — Yaugen Vlasau
– Yaugen Vlasau, Commented Jul 27, 2021 at 6:02

Yaugen Vlasau · Accepted Answer · 2021-07-27 09:27:29Z

2

the problem has been solved by omiting TnsName in the connection string

https://www.connectionstrings.com/net-framework-data-provider-for-oracle/omiting-tnsnamesora/

after the change I have also removed this code line:

OracleConfiguration.OracleDataSources.Add

edited Jul 27, 2021 at 9:27

answered Jul 27, 2021 at 6:03

Yaugen Vlasau

2,2381 gold badge20 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework Core : connect to Oracle database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related