🛠️ 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 Pages Documentation - Complete documentation
• 🎯 Getting Started Guide - Quick start guide
• 📝 Changelog - New features and improvements

🚀 Database Engine Implementations

Database Engine	Unleasharp.DB Implementation
MySQL 🐬	Unleasharp.DB.MySQL
SQLite 💾	Unleasharp.DB.SQLite
PostgreSQL 🐘	Unleasharp.DB.PostgreSQL
MSSQL 📊	Unleasharp.DB.MSSQL
DuckDB 🦆	Unleasharp.DB.DuckDB

📦 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.