Skip to content

EFMigration.md

Latest commit

 

History

History
48 lines (27 loc) · 1.18 KB

EFMigration.md

File metadata and controls

48 lines (27 loc) · 1.18 KB

Create the migration of database:

Follow these steps for generating of DB migrations

Using other database engines

PostgreSQL

Install following NuGet package:

Npgsql.EntityFrameworkCore.PostgreSQL
Npgsql.EntityFrameworkCore.PostgreSQL.Design

In Helpers\StartupHelpers.cs - find all usage of UseSqlServer and change to UseNpgsql.

Don't forget to update your connection string in appsettings.json and (re)generate migrations for new database

SQLite

Install following NuGet package:

Microsoft.EntityFrameworkCore.Sqlite
Microsoft.EntityFrameworkCore.Sqlite.Design

In Helpers\StartupHelpers.cs - find all usage of UseSqlServer and change to UseSqlite.

Don't forget to update your connection string in appsettings.json and (re)generate migrations for new database

MySQL and MariaDB

Install the following NuGet package:

Pomelo.EntityFrameworkCore.MySql
Pomelo.EntityFrameworkCore.MySql.Design

In Helpers\StartupHelpers.cs - find all usage of UseSqlServer and change to UseMySql.

Don't forget to update your connection string in appsettings.json and (re)generate migrations for new database