- Create migration file
$ cd src/EFCore.Ap
$ dotnet ef --project ../EFCore.Dal --startup-project . migrations add InitCreate [--context PgDbContext]
- Update database
$ cd src/EFCore.Ap
$ dotnet ef --project ../EFCore.Dal --startup-project . database update [--context PgDbContext]
$ cd src/EFCore.Ap
$ dotnet ef --project ../EFCore.Dal --startup-project . database update <last_migration_name> [--context PgDbContext]
$ cd "src/EFCore.Ap"
$ dotnet ef --project "../efcore.dal" --startup-project . migrations script --idempotent [--context PgDbContext] --output "../../build/migration.sql"
run sql script file in docker (postgresql container)
- copy file from host
$ docker cp ./migration.sql <container_name>:tmp
- execute sql
$ cd $root/tmp
$ psql -h localhost -p 5432 -U postgres -d Demo -f "migration.sql"
SELECT
"Id",
"Name",
"Password",
my_sym_decrypt("Phone") as Phone,
my_sym_decrypt("CardNo") as CardNo
FROM public."Users"