Scaffold-DbContext Can't find a database from tnsnames.ora?

Tridus

Hi. I'm just getting into Core now, and one of the first things I'm trying to do is reverse engineer a database for Entity Framework Core. All my hosts are in a tnsnames.ora file, so I'm trying to set OracleConfiguration.TnsAdmin.

This works fine when running the application itself, and I can connect no problem. But Scaffold-DbContext comes back with ORA-12154: TNS:could not resolve the connect identifier specified, suggesting to me that it doesn't know where to look. I haven't been able to find anything on how to tell it where to find tnsnames.ora.

Any tips?

Thanks!

Alex Keh-Oracle

You can Easy Connect, Easy Connect+ (ODP.NET 19c), or set Data Source equal to the entire connect descriptor (i.e. (DESCRIPTION = (ADDRESS...)) if you don't want to use a tnsnames.ora file.

If you'd like to use tnsnames.ora, then put the tnsnames.ora file in the same directory as Oracle.ManagedDataAccess.dll or the current working directory from where you care calling Scaffold-DbContext.

Alex Keh-Oracle

You can Easy Connect, Easy Connect+ (ODP.NET 19c), or set Data Source equal to the entire connect descriptor (i.e. (DESCRIPTION = (ADDRESS...)) if you don't want to use a tnsnames.ora file.

If you'd like to use tnsnames.ora, then put the tnsnames.ora file in the same directory as Oracle.ManagedDataAccess.dll or the current working directory from where you care calling Scaffold-DbContext.

Tridus

That worked, thanks!