Goffo.OracleAccess 1.1.0

Oracle Data Access

Data Access Library that contains Load and Save methods for accessing data from Oracle. These methods are using Dapper.

Code Examples

using Microsoft.Extensions.Hosting;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using OracleDataAccess;


App.Start();

//The Connection String Names in appsettings.json
const string oracleConnName = "ORACLEDB";
string sql = string.Empty;
IEnumerable<OracleDataModel> oracleData = new List<OracleDataModel>();

//setup without Dependency Injection
if (App.Configuration is null)
{
    App.Configuration = new ConfigurationBuilder()
        .SetBasePath(Directory.GetCurrentDirectory())
        .AddJsonFile(path: "appsettings.json", optional: false, reloadOnChange: true)
        .Build();
}

if (App.OracleDataAccess is null)
{
    App.OracleDataAccess = new OracleDataAccess.OracleDataAccess(App.Configuration);
}

sql = @"SELECT ORGANIZATION_ID, SEGMENT1, DESCRIPTION
        FROM APPS.MTL_SYSTEM_ITEMS_B
        WHERE ORGANIZATION_ID = 84
            AND ROWNUM <= 100
        GROUP BY ORGANIZATION_ID, SEGMENT1, DESCRIPTION";

oracleData = await App.OracleDataAccess.LoadDataAsync<OracleDataModel, dynamic>(sql: sql,
                                                                                connectionName: oracleConnName,
                                                                                isStoredProcedure: false,
                                                                                sqlParameters: new { },
                                                                                connectionTimeoutSeconds: 0);
//Do something with data....

Console.WriteLine("Total ORACLE Records = {0}", oracleData.Count());



//With parameters
//========================================

sql = @"SELECT ORGANIZATION_ID, SEGMENT1, DESCRIPTION
        FROM APPS.MTL_SYSTEM_ITEMS_B
        WHERE ORGANIZATION_ID = :OrganizationID
            AND ROWNUM <= 100
        GROUP BY ORGANIZATION_ID, SEGMENT1, DESCRIPTION";

oracleData = await App.OracleDataAccess.LoadDataAsync<OracleDataModel, dynamic>(sql: sql,
                                                                                connectionName: oracleConnName,
                                                                                isStoredProcedure: false,
                                                                                sqlParameters: new { OrganizationID = 84 });
//Do something with data....

Console.WriteLine("Total ORACLE Records (with parameter) = {0}", oracleData.Count());

Console.ReadLine();

internal class App
{
    public static Microsoft.Extensions.Configuration.IConfiguration? Configuration { get; set; }
    private static Microsoft.Extensions.Hosting.IHost? _host { get; set; }

    public static IOracleDataAccess? OracleDataAccess { get; set; }

    public static void Start()
    {
        Configuration = new ConfigurationBuilder()
            .SetBasePath(Directory.GetCurrentDirectory())
            .AddJsonFile("appsettings.json", optional: false, reloadOnChange: true)
            .Build();

        _host = Host.CreateDefaultBuilder()
            .ConfigureServices(services =>
            {
                services.AddSingleton<IOracleDataAccess, OracleDataAccess.OracleDataAccess>();
            })
            .Build();

        OracleDataAccess = _host.Services.GetRequiredService<IOracleDataAccess>();
    }
}

internal class OracleDataModel
{
    public double ORGANIZATION_ID { get; set; }
    public string? SEGMENT1 { get; set; }
    public string? DESCRIPTION { get; set; }
}