MySQL Overview

Weasel.MySql provides schema management and migration support for MySQL databases using the MySqlConnector driver.

Installation

dotnet add package Weasel.MySql

Key Components

• MySqlProvider -- Singleton at MySqlProvider.Instance that handles type mappings and identifier parsing. The default schema is public.
• MySqlMigrator -- Generates DDL scripts and executes schema migrations. Identifiers are quoted with backticks.

Supported Schema Objects

Object	Class	Namespace
Tables	Table	Weasel.MySql.Tables
Sequences	Sequence	Weasel.MySql

Connection String

Weasel.MySql uses standard MySQL connection strings compatible with MySqlConnector:

var connectionString = "Server=localhost;Database=mydb;User=root;Password=YourPassword;";

^{snippet source | anchor}

Type Mappings

.NET Type	MySQL Type
string	VARCHAR(255)
int	INT
long	BIGINT
bool	TINYINT(1)
decimal	DECIMAL(18,2)
double	DOUBLE
DateTime	DATETIME
Guid	CHAR(36)
byte[]	BLOB

Creating a Migrator

var migrator = new MySqlMigrator();

^{snippet source | anchor}

The migrator can ensure the target database exists:

await using var conn = new MySqlConnection(connectionString);
await migrator.EnsureDatabaseExistsAsync(conn);
// Generates: CREATE DATABASE IF NOT EXISTS `mydb`;

^{snippet source | anchor}