DapperMatic

Appearance

Installation ​

Prerequisites ​

  • .NET 8.0 or later
  • A supported database:
    • SQL Server 2017+, 2019, 2022
    • MySQL 5.7+, 8.4, 9.0 / MariaDB 10.11+, 11.1
    • PostgreSQL 15+, 16+ (with optional PostGIS extension support)
    • SQLite 3.35+

Install via NuGet ​

Add the DapperMatic package to your project:

bash
dotnet add package MJCZone.DapperMatic

# Optional: Add your preferred Dapper version (supports 2.1.35-2.1.66+)
# dotnet add package Dapper --version 2.1.66
xml
<PackageReference Include="MJCZone.DapperMatic" Version="0.1.*" />

<!-- Optional: Add your preferred Dapper version (supports 2.1.35-2.1.66+) -->
<!-- <PackageReference Include="Dapper" Version="2.1.66" /> -->
powershell
Install-Package MJCZone.DapperMatic

# Optional: Add your preferred Dapper version (supports 2.1.35-2.1.66+)
# Install-Package Dapper -Version 2.1.66

Database Provider Packages ​

You'll also need the appropriate database provider package:

bash
# Recommended
dotnet add package Microsoft.Data.SqlClient
# Alternative
dotnet add package System.Data.SqlClient
bash
# Recommended
dotnet add package MySqlConnector
# Alternative
dotnet add package MySql.Data
bash
dotnet add package Npgsql
bash
# Recommended
dotnet add package Microsoft.Data.Sqlite
# Alternative
dotnet add package System.Data.SQLite

Verify Installation ​

Create a simple test to verify everything is working:

csharp
using MJCZone.DapperMatic;
using Microsoft.Data.SqlClient;

var connectionString = "your-connection-string";
using var connection = new SqlConnection(connectionString);

// Get database version
var version = await connection.GetDatabaseVersionAsync();
Console.WriteLine($"Connected to: {version}");

Next Steps ​

Now that you have DapperMatic installed, check out: