ef-migrations

Execute EF Core migrations for Spiderly's database schema using dotnet ef tooling.

61|24|Updated Sep 14, 2024

Search Tags:#database #schema #migration #dotnet #code-first #entity-framework #ef-migrations

Ready to run

npx skills add https://github.com/filiptrivan/spiderly --skill ef-migrations-filiptrivan

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: ef-migrations
Source: https://github.com/filiptrivan/spiderly/tree/main/claude-plugins/skills/ef-migrations
Command: npx skills add https://github.com/filiptrivan/spiderly --skill ef-migrations-filiptrivan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Create and apply EF Core migrations in Spiderly projects. Use when adding, modifying, or removing entity properties, changing column types, renaming columns, or any database schema change that requires a migration.

Core Features & Use Cases

Create migrations for specific EF Core projects and startup projects using the dotnet ef tooling.
Apply migrations to local or development databases with dotnet ef database update.
Support data migrations by inserting SQL in the Up method for data transformation.
Use a dedicated migrations project to avoid DLL locking during development and streamline production deployments.

Quick Start

Execute a new EF Core migration by running dotnet ef migrations add <MigrationName> --project <InfrastructureProject> --startup-project <MigrationsProject>.

Frequently Asked Questions about ef-migrations

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I create and apply EF Core migrations in a multi-project setup?▼

To create EF Core migrations, run dotnet ef migrations add <Name> targeting your infrastructure project and a dedicated startup project, then apply schema changes using dotnet ef database update locally or in production.

Why use a dedicated migrations project for Entity Framework Core schema changes?▼

A dedicated migrations project prevents DLL locking during development and streamlines production deployments by isolating migration execution from the main infrastructure project.

Can I perform data migrations and insert SQL during an EF Core database update?▼

Yes, you can perform data migrations by inserting SQL statements directly into the Up method of your EF Core migration to transform data alongside schema evolution.

When do I need to generate a new EF Core migration?▼

You need to generate a new EF Core migration when adding, modifying, or removing entity properties, changing column types, renaming columns, or making any database schema change.

Does this EF Core migration workflow support applying schema changes to production databases?▼

Yes, the workflow supports applying migrations to both local development and production databases using the dotnet ef database update command across your multi-project setup.