VivaVictoria.Chaos.DapperMigrator
1.1.1
dotnet add package VivaVictoria.Chaos.DapperMigrator --version 1.1.1
NuGet\Install-Package VivaVictoria.Chaos.DapperMigrator -Version 1.1.1
<PackageReference Include="VivaVictoria.Chaos.DapperMigrator" Version="1.1.1" />
paket add VivaVictoria.Chaos.DapperMigrator --version 1.1.1
#r "nuget: VivaVictoria.Chaos.DapperMigrator, 1.1.1"
// Install VivaVictoria.Chaos.DapperMigrator as a Cake Addin #addin nuget:?package=VivaVictoria.Chaos.DapperMigrator&version=1.1.1 // Install VivaVictoria.Chaos.DapperMigrator as a Cake Tool #tool nuget:?package=VivaVictoria.Chaos.DapperMigrator&version=1.1.1
Chaos.Dapper
IMigrator implementation for Data Mapper Dapper library. Supports all databases supported by Dapper.
Communication
This library provider IDatabaseDriver
interface. This interface should be implemented to provide Dapper valid
IDbConnection
and create/insert/select statements for migration metadata table.
Install
Install via nuget.
Usage
var services = new ServiceCollection();
services.AddChaosDapper<MyMetadata>();
It defines DapperMigrator and specified MyMetadata
class for Chaos. Insteadof MyMetadata
you should use your IMetadata
class, supported by IDatabaseDriver
.
Extension
- Create new IDatabaseDriver implementation. Your implementation can require specified Metadata implementation:
public class MyMetadata : IMetadata
{
public string TableName { get; }
public string IdColumnName { get; }
public string IdColumnType { get; }
public string StateColumnName { get; }
public string StateColumnType { get; }
public string VersionColumnName { get; }
public string VersionColumnType { get; }
public string DateColumnName { get; }
public string DateColumnType { get; }
}
public class MyDriver : IDatabaseDriver<MyMetadata>
{
/*
* Use connection string and metadata model to create connection. You can store
* in metadata runtime-dependent connection parameters and use it for providing
* correct connection. For example, Postgres uses Schema from metadata to specify
* NpgsqlConnection SearchPath.
*/
public IDbConnection Connect(string connectionString, MyMetadata metadata) =>
new MyDbConnection(connectionString);
/*
* Not all RDBMS supports transactions or supports their functional not fully or in custom format.
* For example, Clickhouse does not support transactions and always returns false from this method.
*/
public bool IsTransactionSupported();
/*
* Create raw sql script for creating metadata table and other infrastructure.
* For example, SqlServer and Postgres creates requested Schema before creating table.
* Use provided metadata instance to determine table and column parameters like name, type or constraints
*/
public string CreateStatement(MyMetadata metadata);
/*
* Returns raw dapper-style sql script for inserting metadata info into table.
* You can use any params via @Param keys, but you need to define all required params
* in InsertParameters method.
* Default params dateTime, version and state. They are required and should be used always.
*/
public string InsertStatement(MyMetadata metadata);
/*
* Returns params for InsertStatement script in any supported by Dapper format: POCOs, dynamic, etc
*/
public object InsertParameters(DateTime dateTime, long version, MigrationState state);
/*
* Returns sql script for receiving latest metadata info. Should returns from DB two values:
* Version as int64 number,
* State as any Enum-convertible value, recommended int or int8/int16/int32/int64
*/
public string SelectStatement(MyMetadata metadata);
}
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp3.1 is compatible. |
-
.NETCoreApp 3.1
- Dapper (>= 2.0.90)
- VivaVictoria.Chaos (>= 1.1.1)
- VivaVictoria.Chaos.Logging (>= 1.1.1)
- VivaVictoria.Chaos.Sql (>= 1.1.1)
NuGet packages (2)
Showing the top 2 NuGet packages that depend on VivaVictoria.Chaos.DapperMigrator:
Package | Downloads |
---|---|
VivaVictoria.Chaos.SqlServer
MS SqlServer Migrator for Chaos tool. Based on Chaos.Dapper and System.Data.SqlClient. |
|
VivaVictoria.Chaos.Postgres
PostgreSQL Migrator for Chaos tool. Based on Chaos.Dapper and Npgsql. |
GitHub repositories
This package is not used by any popular GitHub repositories.
Version | Downloads | Last updated |
---|---|---|
1.1.1 | 1,230 | 10/17/2021 |
1.1.1-preview | 851 | 10/7/2021 |
1.1.0 | 1,108 | 10/7/2021 |