Sharp.MySQL.Migrations
0.10.4
.NET Core 3.1
dotnet add package Sharp.MySQL.Migrations --version 0.10.4
NuGet\Install-Package Sharp.MySQL.Migrations -Version 0.10.4
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Sharp.MySQL.Migrations" Version="0.10.4" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Sharp.MySQL.Migrations --version 0.10.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Sharp.MySQL.Migrations, 0.10.4"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Sharp.MySQL.Migrations as a Cake Addin
#addin nuget:?package=Sharp.MySQL.Migrations&version=0.10.4
// Install Sharp.MySQL.Migrations as a Cake Tool
#tool nuget:?package=Sharp.MySQL.Migrations&version=0.10.4
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Migration - MySQL
Biblioteca simplificada para Migration em bancos de dados MySql/MariaDB
[Documentação em Progresso]
Objetivo: Criar tabelas e colunas à partir de uma Model
- Crie uma model para representar a tabela
public class Pessoas
{
[PrimaryKey]
[AutoIncrement]
[TypeFieldBD(TypeField.INT, NotNull = true)]
public int Codigo { get; set; } //INT AI PK NN
[TypeFieldBD(TypeField.NVARCHAR, 100, NotNull = true)]
public string Nome { get; set; } //NVARCHAR(100) NN
}
- Inicialize nossa Factory com sua connection String
var mySQLFactory = new Sharp.MySQL.ConnectionFactory(connstring);
- Crie um Migration com a Factory, adicione models e execute a migração
var migration = new Sharp.MySQL.Migration(mySQLFactory);
// Add or change tables
var result = migration.Add<Pessoas>()
.Migrate();
- A tabela será criada no banco
- Caso faltem colunas, as novas colunas são criadas
- Utlize o Result para verificar se houveram modificações no banco
Veja o projeto de exemplo em: MigrationMySQL/RunStuff
Product | Versions |
---|---|
.NET | net5.0 net5.0-windows net6.0 net6.0-android net6.0-ios net6.0-maccatalyst net6.0-macos net6.0-tvos net6.0-windows net7.0 net7.0-android net7.0-ios net7.0-maccatalyst net7.0-macos net7.0-tvos net7.0-windows |
.NET Core | netcoreapp3.1 |
Compatible target framework(s)
Additional computed target framework(s)
Learn more about Target Frameworks and .NET Standard.
-
.NETCoreApp 3.1
- Dapper (>= 2.0.123)
- MySql.Data (>= 8.0.30)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
Pareado com o commit e89c900