EF Core Operations

Manage Entity Framework Core migrations and database updates.

Operations

Operation	Description
`Ef.DbContextFrom`	Create a reference to a DbContext in a project.
`Ef.DatabaseUpdate`	Apply pending EF Core migrations to the database. Can accept a connection string or an `OutputRef` from a Bicep deployment.
`Ef.AddMigration`	Create a new EF Core migration.
`Ef.Script`	Generate an idempotent SQL migration script.
`Ef.RemoveMigration`	Remove the last migration.

Operation Details

`Ef.DbContextFrom`

Create a reference to a DbContext in a project.

var db = Ef.DbContextFrom(DataProject);
var db = Ef.DbContextFrom(DataProject, "AppDbContext");

`Ef.DatabaseUpdate`

Apply pending EF Core migrations to the database. Can accept a connection string or an OutputRef from a Bicep deployment.

Ef.DatabaseUpdate(db);
Ef.DatabaseUpdate(db, connectionString: "Server=...");
Ef.DatabaseUpdate(db, deployment.Output("sqlConnectionString"));

`Ef.AddMigration`

Create a new EF Core migration.

Ef.AddMigration(db, "InitialCreate");
Ef.AddMigration(db, "AddUsers", outputDir: "Migrations");

`Ef.Script`

Generate an idempotent SQL migration script.

Ef.Script(db, Root / "migration.sql");
Ef.Script(db, Root / "migration.sql", fromMigration: "Init");

`Ef.RemoveMigration`

Remove the last migration.

Ef.RemoveMigration(db);
Ef.RemoveMigration(db, force: true);

Setup

EF Core operations require the dotnet-ef tool. ANDO can install it automatically.

 build.csando // Define the EF tool (installs if needed)
var EfTool = Dotnet.Tool("dotnet-ef", "9.0.0");

Example

Run migrations and generate SQL scripts.

 build.csando // Define the DbContext reference
var DataProject = Dotnet.Project("./src/Data/Data.csproj");
var db = Ef.DbContextFrom(DataProject, "AppDbContext");

// Apply migrations to the database
Ef.DatabaseUpdate(db);

// Or generate an idempotent SQL script
Ef.Script(db, Root / "artifacts" / "migration.sql");