APF.Core.Clean.Database 1.0.0-Beta-09

Core.Clean.Database

Core.Clean.Database is an infrastructure-level package that provides MySQL-specific configurations, helpers, and service implementations. It centralizes database connection handling, extensions, and feature-level services that interact directly with the database. This package depends on Core.Clean.Common for its abstractions and shared contracts.

Projects

src/Aurionpro.PaymentFramework.Core.Clean.Database

• Aurionpro.PaymentFramework.Core.Clean.Database

tests/Aurionpro.PaymentFramework.Core.Clean.Database.Tests

• Aurionpro.PaymentFramework.Core.Clean.Database.Tests

Purpose

• Centralizes all MySQL-specific boilerplate code such as connection factories and settings.
• Provides extension helpers to simplify database access and data retrieval.
• Implements data access services (e.g., API key validation, feature access, system info) defined as abstractions in Core.Clean.Common.
• Enables clean separation between abstractions (in Common) and implementations (in Database) for improved maintainability.
• Supports infrastructure setup for microservices using MySQL as their persistence layer.

Features

• Database Settings: Provides DatabaseSettings and connection string builders for MySQL configuration.
• Connection Factory: Includes IDbConnectionFactory and MySqlConnectionFactory for creating and managing database connections.
• Extensions:MySqlDataReaderExtensions for safer field retrieval and null-handling.
• Service Implementations:Implements abstractions like IApiCredentialValidatorService, IAccessRightsService, and ISystemInfoHelper.Provides data access logic for microservice-level authentication and feature control.
• Structured Organization: Common folder contains boilerplate code and reusable components. Implementations folder contains implementations of feature-level services.

Getting Started

1. Clone the repo
2. Navigate to the root directory
3. Run:

dotnet build
dotnet test

register database dependencies in a microservice

using Aurionpro.PaymentFramework.Core.Clean.Database.Common.Extensions;
using Aurionpro.PaymentFramework.Core.Clean.Database.Implementations.Extensions;

var builder = WebApplication.CreateBuilder(args);

// Register common database dependencies
builder.Services.AddDatabaseSettings(builder.Configuration);

// Register Implementations-specific services
builder.Services.AddCoreCleanDatabase(builder.Configuration);