Unleasharp.DB Modern Query Building for C#

Powerful, thread-safe database access library with fluent methods for building SQL queries in C#. Supports MySQL, SQLite, PostgreSQL, MSSQL and DuckDB.

Install Now Learn More

                            Example Usage
                        
                            // Using SQLite connector

                            using Unleasharp.DB.SQLite;

                            var db = new ConnectorManager("Data Source=unleasharp.db;Version=3;");

                            var row = db.QueryBuilder().Build(query => query

                              .From<ExampleTable>()

                              .OrderBy<ExampleTable>(row => row.Id, OrderDirection.DESC)

                              .Limit(1)

                              .Select()

                            ).FirstOrDefault<ExampleTable>();

Key Features

Unleasharp.DB provides everything you need for modern database operations in C#

Connection Handling

Automatic connection creation, management, and regeneration after specified intervals to ensure 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 for safe parallel operations.

Query Generation

Fluent methods pattern for intuitive query building with Query class for parameters and QueryBuilder for execution and result mapping.

Serialization

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

Performance Optimized

Built with performance in mind, delivering fast execution times with minimal overhead.

Database Agnostic

Consistent API across multiple database systems with specialized implementations for MySQL, SQLite, PostgreSQL, and MSSQL.

Install Unleasharp.DB

Select your preferred database provider to get started with Unleasharp.DB. All packages are available on NuGet.

Select Database Provider:

Install via Package Manager

Open your Package Manager Console and run:

Install-Package Unleasharp.DB.MySQL

Install via .NET CLI

Run the following command in your project directory:

dotnet add package Unleasharp.DB.MySQL

Package Reference (Manual)

Add to your .csproj file:

<PackageReference Include="Unleasharp.DB.MySQL" Version="1.0.0" />

                            Package Manager
                        
                            // Install via Package Manager Console

                            PM> Install-Package Unleasharp.DB.MySQL

                            // Or via .NET CLI

                            CLI> dotnet add package Unleasharp.DB.MySQL

                            // Or add to your .csproj

                            <PackageReference Include="Unleasharp.DB.MySQL" Version="1.0.0" />

Usage Examples

See how easy it is to work with Unleasharp.DB in your C# projects

Query Building

                            Query Builder
                        
                            var users = db.QueryBuilder().Build(query => query

                              .From<User>()

                              .Where<User>(u => u.Name, "John Doe")

                              .OrderBy<User>(u => u.Age)

                              .Select()

                            ).ToList<User>();

Data Insertion

                            Insert Data
                        
                            var user = new User {

                              Name = "John Doe",

                              Email = "john@example.com",

                              Age = 30

                            };

                            var id = db.QueryBuilder().Build(query => query

                              .Insert<User>(user)

                              .Execute<long>()

                            );