How to connect to oracle Database from C# Code deployed within docker using wallet file

Question

Hi All

We are currently working on establishing a connection to an Oracle database from a C# application using the Oracle.DataAccess.Client library. However, we are encountering difficulties when attempting to connect using a wallet file. Our application is an ASP.NET Core MVC application that has been deployed as a Docker image.

If you could provide any documentation, references, or guidance on the correct format for the connection string and how to reference the wallet through Oracle.DataAccess.Client, it would be greatly appreciated. Your assistance in resolving this issue would be invaluable to us.

Answer 1

Oracle published the official Data Provider for .NET Core on nuget.

using Oracle.ManagedDataAccess.Client;

public void Execute(string queryString, string connectionString)
{
    using (OracleConnection connection = new OracleConnection(connectionString))
    {
        OracleCommand command = new OracleCommand(queryString, connection);
        command.Connection.Open();
        command.ExecuteNonQuery();
    }
}