Korjn.Data.OracleDb.Client 8.0.2

Korjn.Data.Oradb.Client

appsettings.json

{
    "OraClient": {
      "MainDb":{
        "Host": "xxx.xxx.xxx.xxx",
        "Port": xxxx,
        "ServiceName" : "xxxx"
        "DefaultSchema": "xxxx",
        "MinPoolSize": 1,
        "MaxPoolSize": 5,
        "IncrPoolSize": 1,
        "DecrPoolSize": 1,
        "ConnectionLifeTime": 180,
        "ConnectionTimeout": 60,        
        "CredentialFile":"main-db.json",
        "DateFormat":"dd.mm.yyyy",
        "ModuleName":"app-1",        
    },
    "TestDb":{
        "Host": "xxx.xxx.xxx.xxx",
        "Port": xxxx,
        "ServiceName" : "xxxx"
        "DefaultSchema": "xxxx",
        "UserName": "xxxx",
        "Password": "xxxx",
        "MinPoolSize": 1,
        "MaxPoolSize": 5,
        "IncrPoolSize": 1,
        "DecrPoolSize": 1,
        "ConnectionLifeTime": 180,
        "ConnectionTimeout": 60,        
        "CredentialFile":"test-db.json",
        "DateFormat":"dd.mm.yyyy",
        "ModuleName":"app-1",        
    }
  },
}

CredentialFile

{
  "UserName": "",
  "Password": ""
}

Service registration

using Korjn.Data.OracleClient.DependencyInjection.Extensions;

...

builder.Services.AddOracleClient(options =>
{
    builder.Configuration.GetSection("OraClient:Main").Bind(options);
});

// **Multiple instances**

builder.Services.AddOracleClient("firts", options =>
{
    builder.Configuration.GetSection("OraClient:firts").Bind(options);
});

builder.Services.AddOracleClient("second", options =>
{
    builder.Configuration.GetSection("OraClient:second").Bind(options);
});

...

Injection

using Korjn.Data.OracleClient;
namespace DependencyInjection.Example;

public sealed class Worker : BackgroundService
{
    private readonly IMessageWriter _messageWriter;
    private readonly IOracleClient client;

    public Worker(IMessageWriter messageWriter, IOracleClient client)
    {
        _messageWriter = messageWriter;
        this.client = client;        
    }

    /*
    Multiple instances
    public Worker(IMessageWriter messageWriter, FromKeyedServices("fistr")] IOracleClient client)
    {
        _messageWriter = messageWriter;
        this.client = client;        
    }*/    

    protected override async Task ExecuteAsycn()
    {
        using var con = client.CreateConnection();
        ...
    }
}