Unleasharp.DB.Base 1.5.2

.NET 6.0

dotnet add package Unleasharp.DB.Base --version 1.5.2

NuGet\Install-Package Unleasharp.DB.Base -Version 1.5.2

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="Unleasharp.DB.Base" Version="1.5.2" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="Unleasharp.DB.Base" Version="1.5.2" />
                    

                            Directory.Packages.props

<PackageReference Include="Unleasharp.DB.Base" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add Unleasharp.DB.Base --version 1.5.2

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Unleasharp.DB.Base, 1.5.2"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

#:package Unleasharp.DB.Base@1.5.2

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=Unleasharp.DB.Base&version=1.5.2
                    

                            Install as a Cake Addin

#tool nuget:?package=Unleasharp.DB.Base&version=1.5.2
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Unleasharp.DB.Base

A lightweight, database-agnostic library for .NET that provides connection management, query building, and data serialization capabilities.

🎯 Key Concepts

This library provides a foundation for database operations with the following core features:

🔌 Connection Handling

Automatic connection creation and management
Configurable automatic connection regeneration after specified intervals
Ensures database connections are always open and ready for use

🧵 Threading Support

Thread-safe connection management through ConnectorManager
Each thread receives its own dedicated database connection instance

📝 Query Generation

Query class: Holds SQL query parameters in an engine-agnostic manner
QueryBuilder class: Executes queries against the database and maps results to specified types
Follows fluent interface pattern for intuitive query building

🔄 Serialization

Automatic mapping of database results to C# objects using generic type parameters
Supports both simple class mapping and attribute-based schema definitions

🔧 Query Generation Architecture

The library follows a CRTP (Curiously Recurring Template Pattern) approach where:

The base Query class provides engine-agnostic functionality
Engine-specific implementations handle the actual SQL rendering
Query building follows standard SQL syntax with fluent method chaining

📖 Documentation Resources

📚 GitHub Wiki - Complete documentation
🎯 Getting Started Guide - Quick start guide

🚀 Database Engine Implementations

✅ MySQL - Unleasharp.DB.MySQL
✅ SQLite - Unleasharp.DB.SQLite
✅ PostgreSQL - Unleasharp.DB.PostgreSQL
✅ MSSQL - Unleasharp.DB.MSSQL

📦 Dependencies

Unleasharp - Multipurpose library

📋 Version Compatibility

This library targets .NET 6.0 and later versions. For specific version requirements, please check the package dependencies.

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

Product	Compatible and additional computed target framework versions.
.NET	net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net6.0
- Microsoft.CSharp (>= 4.7.0)
- Unleasharp (>= 1.1.0)
net8.0
- Microsoft.CSharp (>= 4.7.0)
- Unleasharp (>= 1.1.0)

NuGet packages (4)

Showing the top 4 NuGet packages that depend on Unleasharp.DB.Base:

Package	Downloads
Unleasharp.DB.MySQL Lightweight MySQL query-building client for C#.	902
Unleasharp.DB.SQLite Lightweight SQLite query-building client for C#.	670
Unleasharp.DB.PostgreSQL Lightweight PostgreSQL query-building client for C#.	412
Unleasharp.DB.MSSQL Lightweight MSSQL query-building client for C#.	104

GitHub repositories

This package is not used by any popular GitHub repositories.

Version	Downloads	Last Updated
1.5.2	38	8/30/2025
1.5.1	37	8/30/2025
1.5.0	65	8/28/2025
1.4.1	65	8/28/2025
1.4.0	67	8/28/2025
1.3.3	133	8/26/2025
1.3.2	139	8/25/2025
1.3.1	143	8/25/2025
1.3.0	135	8/25/2025
1.2.0	86	8/22/2025
1.1.1	127	8/21/2025
1.1.0	126	8/20/2025
1.0.2	125	8/20/2025
1.0.1	123	8/20/2025
1.0.0	120	8/19/2025