RetailSolutions.Shared.Database 1.3.1382

RetailSolutions.Shared.Database

A shared .NET library providing a unified abstraction layer for Oracle and SQL Server database access, built on top of Dapper with connection factory logic and Oracle-specific performance tuning.

Features

• Connection Factory — auto-detects Oracle or SQL Server from the connection string and returns a DbConnection
• Oracle Performance Tuning — statement cache, bind-by-name, fetch size, and network buffer settings applied at startup
• SQL Statement Expansion — expands parameterized commands into readable SQL for logging and debugging
• Dapper Integration — works with DynamicParameters via GetDapperSqlStatement
• Parameter Binding — replaces @param / :param placeholders with typed literal values

Installation

dotnet add package RetailSolutions.Shared.Database

Available on NuGet.org.

Requirements

• .NET 10.0 or later

Dependencies

Usage

DatabaseConnectionFactory

Automatically creates the appropriate connection based on the connection string:

using RetailSolutions.Shared.Database;

// Oracle — detected via "Data Source=" prefix
var oracleConn = DatabaseConnectionFactory.CreateDbConnection(
    "Data Source=localhost:1521/XE;User Id=user;Password=pass;"
);

// SQL Server — detected via "Server=" prefix
var sqlConn = DatabaseConnectionFactory.CreateDbConnection(
    "Server=localhost;Database=MyDb;User Id=user;Password=pass;"
);

Both return DbConnection, keeping the calling code database-agnostic.

Oracle Extensions

Startup Configuration

Call once at application startup to apply Oracle-wide performance settings:

using RetailSolutions.Shared.Database.Extensions;

OracleExtension.ConfigureOracleStartup();

Applied settings:

SQL Statement Expansion

Expands an OracleCommand into a human-readable SQL string with parameters inlined — useful for logging:

using Oracle.ManagedDataAccess.Client;

var cmd = new OracleCommand("SELECT * FROM users WHERE id = :id");
cmd.Parameters.Add(":id", OracleDbType.Int32).Value = 1;

string sql = cmd.GetSqlStatement();
// SELECT * FROM users WHERE id = 1

Dapper Integration

using Dapper;
using RetailSolutions.Shared.Database.Extensions;

var parameters = new DynamicParameters();
parameters.Add(":id", 1);

string sql = parameters.GetDapperSqlStatement("SELECT * FROM users WHERE id = :id");
// SELECT * FROM users WHERE id = 1

Query Extensions

Replaces @param / :param placeholders with typed literal values:

using RetailSolutions.Shared.Database.Extensions;

var query = "SELECT * FROM users WHERE id = @id AND name = :name";
var parameters = new { id = 1, name = "John" };

string bound = query.BindParameters(parameters);
// SELECT * FROM users WHERE id = 1 AND name = 'John'

Type handling:

Build

dotnet build
dotnet publish   # produces NuGet package

Contributing

1. Fork the repository
2. Create a feature branch (git checkout -b feature/my-feature)
3. Commit your changes (git commit -m 'Add my feature')
4. Push to the branch (git push origin feature/my-feature)
5. Open a Pull Request

License

Copyright © Retail Solutions. All rights reserved.