Franz.Common.EntityFramework.Oracle 1.2.64

Franz.Common.EntityFramework.Oracle

A specialized library within the Franz Framework that extends Entity Framework Core support for Oracle Database using the Oracle.EntityFrameworkCore provider. This package simplifies the configuration and integration of Oracle databases in .NET applications, supporting both single-tenant and multi-tenant environments.

Features

• Oracle Database Integration:
  • Leverages Oracle.EntityFrameworkCore for Oracle database support.
• Service Registration:
  • ServiceCollectionExtensions to streamline dependency injection for Oracle database contexts.
• Multi-Tenancy Support:
  • Integrates with Franz.Common.MultiTenancy for multi-tenant Oracle database configurations.
• Compatibility:
  • Fully integrates with Franz.Common.EntityFramework for shared utilities and repository patterns.

Version Information

• Current Version: 1.2.64
• Part of the private Franz Framework ecosystem.

Dependencies

This package relies on:

• Oracle.EntityFrameworkCore (8.21.121): Official EF Core provider for Oracle databases.
• Franz.Common.EntityFramework: Core EF utilities and patterns.
• Franz.Common.MultiTenancy: Multi-tenancy support for database operations.

Installation

From Private Azure Feed

Since this package is hosted privately, configure your NuGet client:

dotnet nuget add source "https://your-private-feed-url" \
  --name "AzurePrivateFeed" \
  --username "YourAzureUsername" \
  --password "YourAzurePassword" \
  --store-password-in-clear-text

Install the package:

dotnet add package Franz.Common.EntityFramework.Oracle --Version 1.2.64

Usage

1. Configuring Oracle Context

Define a DbContext for Oracle integration:

using Microsoft.EntityFrameworkCore;

public class OracleDbContext : DbContext
{
    public OracleDbContext(DbContextOptions<OracleDbContext> options) : base(options) { }

    public DbSet<Order> Orders { get; set; }
}

2. Dependency Injection

Use ServiceCollectionExtensions to register Oracle database contexts:

using Franz.Common.EntityFramework.Oracle.Extensions;

public class Startup
{
    public void ConfigureServices(IServiceCollection services)
    {
        services.AddOracleDbContext<OracleDbContext>(options =>
            options.UseOracle(
                "User Id=myUser;Password=myPassword;Data Source=myDataSource"
            ));
    }
}

3. Multi-Tenancy Support

Integrate with Franz.Common.MultiTenancy to support multiple tenants:

using Franz.Common.MultiTenancy;
using Franz.Common.EntityFramework.Oracle.Extensions;

public class Startup
{
    public void ConfigureServices(IServiceCollection services)
    {
        services.AddMultiTenantOracleDbContext<OracleDbContext>(tenantOptions =>
        {
            tenantOptions.ConnectionStringResolver = tenantId =>
                $"User Id=tenant_{tenantId};Password=tenantPassword;Data Source=myDataSource";
        });
    }
}

Integration with Franz Framework

The Franz.Common.EntityFramework.Oracle package integrates seamlessly with:

• Franz.Common.EntityFramework: Shared repository patterns and EF utilities.
• Franz.Common.MultiTenancy: Simplifies multi-tenant database configurations.

Ensure these dependencies are installed to fully leverage the library's capabilities.

Contributing

This package is part of a private framework. Contributions are limited to the internal development team. If you have access, follow these steps:

1. Clone the repository. @ https://github.com/bestacio89/Franz.Common/
2. Create a feature branch.
3. Submit a pull request for review.

License

This library is licensed under the MIT License. See the LICENSE file for more details.

Changelog

Version 1.2.64

• Upgrade version to .net 9