SQL Server Overview

Weasel.SqlServer provides schema management and migration support for Microsoft SQL Server databases using the Microsoft.Data.SqlClient driver.

Installation

dotnet add package Weasel.SqlServer

Key Components

• SqlServerProvider -- Singleton at SqlServerProvider.Instance that handles type mappings and identifier parsing. The default schema is dbo.
• SqlServerMigrator -- Generates DDL scripts, executes schema migrations, and manages schema creation/deletion for SQL Server.

Supported Schema Objects

Object	Class	Namespace
Tables	Table	Weasel.SqlServer.Tables
Stored Procedures	StoredProcedure	Weasel.SqlServer.Procedures
Functions	Function	Weasel.SqlServer.Functions
Sequences	Sequence	Weasel.SqlServer
Table Types	TableType	Weasel.SqlServer.Tables

Connection String

Weasel.SqlServer uses standard SQL Server connection strings with Microsoft.Data.SqlClient:

var connectionString = "Server=localhost;Database=mydb;User Id=sa;Password=YourPassword;TrustServerCertificate=true;";

^{snippet source | anchor}

Creating a Migrator

var migrator = new SqlServerMigrator();

^{snippet source | anchor}

The migrator can also ensure the target database exists before running migrations:

await using var conn = new SqlConnection(connectionString);
await migrator.EnsureDatabaseExistsAsync(conn);

^{snippet source | anchor}

Schema Management

SQL Server schemas are created automatically when needed during migration. You can also generate schema DDL directly:

var migrator = new SqlServerMigrator();
var writer = new StringWriter();
migrator.WriteSchemaCreationSql(new[] { "myschema" }, writer);
// Generates: IF NOT EXISTS (...) EXEC('CREATE SCHEMA [myschema]');

^{snippet source | anchor}