استفاده از دیتابیس Oracle در .Net Core

using Microsoft.EntityFrameworkCore;

namespace DataAccess;

public class OracleDbContext : DbContext
{
    public OracleDbContext(DbContextOptions<OracleDbContext> options) : base(options)
    {
        
    }
        
    public DbSet<MainLog> MainLogs { get; set; }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<MainLog>().Property(p => p.REQUEST_TIME).HasColumnType("TIMESTAMP");
        modelBuilder.Entity<MainLog>().Property(p => p.RECEIVE_TIME).HasColumnType("TIMESTAMP");

        base.OnModelCreating(modelBuilder);
    }
}

[Table("LOG_INFO", Schema = "MAIN")]
public sealed class MainLog : PreparedLog
{
    public DateTime REQUEST_TIME { get; set; }
}

services.AddDbContextFactory<OracleDbContext>(options => { options.UseOracle(configuration.GetConnectionString("OracleDatabase")); });

"ConnectionStrings": {
"OracleDatabase": "Data Source=172.0.0.1:1521/DbName;PERSIST SECURITY INFO=True;User Id=MyUser;Password=MyPass;Pooling=true;Min Pool Size=1;Max Pool Size=50;Incr Pool Size=5;Connection Lifetime=180",
}

public class LogSenderRepository : ILogSenderRepository
{
    private readonly IDbContextFactory<OracleDbContext> _dbContextFactory;
    private readonly ILogger<LogSenderRepository> _logger;

    public LogSenderRepository(IDbContextFactory<OracleDbContext> dbContextFactory)
    {
        _dbContextFactory = dbContextFactory;
    }

    public async Task SendLogAsync(IReadOnlyCollection<MainLog> input)
    {
        using (Tracing.ActivitySource.StartActivity())
        {
            await using var context = await _dbContextFactory.CreateDbContextAsync();
            context.ChangeTracker.AutoDetectChangesEnabled = false;

            await context.MainLogs.AddRangeAsync(input);

            await context.SaveChangesAsync();
        }
    }
}

Oracle error ORA-12571 encountered
 ---> OracleInternal.Network.NetworkException (0x80004005): Oracle error ORA-12571 encountered
 ---> System.Net.Sockets.SocketException (110): Connection timed out

<PackageReference Include="Oracle.ManagedDataAccess.Core" Version="3.21.140" />

private async Task SaveUsingOracleSingleCopyAsync(string destTableName, PreparedLog item, int retry = 3)
{
    await using var connection = new OracleConnection(_connectionString);

    try
    {
        await using var command = connection.CreateCommand();

        await connection.OpenAsync();

        var columnNames = string.Join(',', typeof(PreparedLog).GetProperties().Select(p => $"{p.Name}"));

        var parameterPlaceholders = string.Join(',', typeof(PreparedLog).GetProperties().Select(p => $":{p.Name}"));

        command.CommandText = $"INSERT INTO {BourseSchema}.{destTableName} ({columnNames}) VALUES ({parameterPlaceholders})";

        foreach (var property in typeof(PreparedLog).GetProperties())
        {
            command.Parameters.Add(property.Name, property.GetValue(item));
        }

        await command.ExecuteNonQueryAsync();
    }
    catch (OracleException e)
    {
        _logger.LogWarning(e, "retry on send to bourse");

        if (e.Number is 12570 or 03135 or 12571)
        {
            if (retry == 0)
                throw new AppException("ex on SaveUsingOracleSingleCopy after 3 time retry", e);

            await SaveUsingOracleSingleCopyAsync(destTableName, item, retry - 1);
        }

        throw;
    }
    finally
    {
        await connection.CloseAsync();
    }
}