/EF.Core.Sample

Entity Framework Core samples

Primary LanguageC#BSD 3-Clause "New" or "Revised" LicenseBSD-3-Clause

EF Core Samples

DB Migration

  1. Create migration file
$ cd src/EFCore.Ap
$ dotnet ef  --project ../EFCore.Dal --startup-project . migrations add InitCreate [--context PgDbContext]
  1. Update database
$ cd src/EFCore.Ap
$ dotnet ef  --project ../EFCore.Dal --startup-project . database update [--context PgDbContext]

Revert migration

$ cd src/EFCore.Ap
$ dotnet ef  --project ../EFCore.Dal --startup-project . database update <last_migration_name> [--context PgDbContext]

Migrate DB container

$ 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)

  1. copy file from host
$ docker cp ./migration.sql <container_name>:tmp
  1. execute sql
$ cd $root/tmp
$ psql -h localhost -p 5432 -U postgres -d Demo -f "migration.sql"

DB query

SELECT
"Id",
"Name",
"Password",
my_sym_decrypt("Phone") as Phone,
my_sym_decrypt("CardNo") as CardNo 
FROM public."Users"