Dreamine.Database.FullKit 1.0.2

Dreamine.Database.FullKit

Dapper-based Dreamine DB access with every supported provider — MySQL, Oracle, SQL Server, SQLite — in one install.

➡️ 한국어 문서 보기

Dreamine.Database.FullKit bundles the Dreamine database abstraction and every provider it ships with. Same repository / same IDatabaseProvider API against whichever engine is behind it — pick the connection string, the rest of your code doesn't change.

Why this bundle exists

Tools that need to work against more than one database engine usually do one of two things:

• write against IDbConnection directly and reinvent parameter quoting per engine
• bring a heavyweight ORM whose migration story doesn't match how the team ships

Dreamine picks a middle path: a thin IDatabaseProvider on top of Dapper, with per-engine implementations that already know how to quote identifiers, map types, and issue CREATE DATABASE IF NOT EXISTS / CREATE TABLE IF NOT EXISTS.

Dreamine.Database.FullKit bundles all four providers so you can start on SQLite in dev, swap to SQL Server in staging, and ship on MySQL in prod — same code, different connection string.

What you get by installing this

• ✅ Uniform IDatabaseProvider API — one Insert<T> / Query<T> / CreateTable<T> surface across four engines
• ✅ Dapper under the hood — micro-ORM performance, no reflection surprises
• ✅ Engine-aware quoting — backticks for MySQL, brackets for SQL Server, double-quotes for Oracle, etc., handled for you
• ✅ Bootstrap helpers — EnsureDatabaseExists() + CreateTable<T>() for straightforward first-run setup
• ✅ Version pinning — abstractions, core, and all four providers pinned together

Who this is for

Use Dreamine.Database.FullKit if you are:

• writing a WPF / desktop tool that has to work against whichever DB the customer has
• prototyping and want SQLite locally with a clear path to MySQL / SQL Server later
• shipping an internal tool where "same code, different connection string" saves real time

Prefer individual packages if you are:

• committed to a single engine — install only that provider (e.g. Dreamine.Database.MySql)
• writing a library and only need the contracts (Dreamine.Database.Abstractions)

Included packages

Installation

dotnet add package Dreamine.Database.FullKit

Or:

<ItemGroup>
  <PackageReference Include="Dreamine.Database.FullKit" />
</ItemGroup>

Quick start

using Dreamine.Database.MySql;

var provider = new MySqlDatabaseProvider(
    "Server=localhost;Port=3306;Database=dreamine_sample;User ID=root;Password=1234;");

provider.EnsureDatabaseExists();
provider.CreateTable<Customer>();

provider.Insert(new Customer { Name = "Dreamine" });
var all = provider.Query<Customer>("SELECT * FROM Customer");

Swap MySqlDatabaseProvider for SqlServerDatabaseProvider / OracleDatabaseProvider / SqliteDatabaseProvider — the rest of the code is identical.

Related Dreamine FullKits

Links

• Website: https://dreamine.kr
• GitHub: https://github.com/CodeMaru-Dreamine

License

MIT