Тестовое соединение с БД Oracle

netappcore3.1

dotnet add package Oracle.ManagedDataAccess.Core

рабочий пример строки соединения C# для тестового пользователя hr. 

string ConnectionString = "Data Source=//localhost:1521/orclpdb; User Id=hr; Password=hr;";

sqlora.net

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

tsnnames.ora

ORCLPDB =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orclpdb)

    )

  )