db-build-scaffold

Build and deploy SQL Server DACPACs, then scaffold Entity Framework Core entities.

6|1|Updated Dec 13, 2017
One-click install
npx skills add https://github.com/esassoc/neptune --skill db-build-scaffold
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-build-scaffold
Source: https://github.com/esassoc/neptune/tree/main/.claude/skills/db-build-scaffold
Command: npx skills add https://github.com/esassoc/neptune --skill db-build-scaffold

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill ensures that your C# Entity Framework Core models accurately reflect the latest changes made to your SQL Server database schema, preventing synchronization issues and reducing manual refactoring.

Core Features & Use Cases

  • Database Schema Deployment: Builds and deploys SQL Server DACPACs to update the database.
  • EF Core Entity Scaffolding: Regenerates C# entity classes based on the updated database schema.
  • Change Tracking: Reports the differences in generated entity files after scaffolding.
  • Use Case: After making several changes to your database tables and columns in Neptune.Database/, run this Skill to update the live database and automatically update the corresponding C# model code.

Quick Start

Run the db-build-scaffold skill to deploy database schema changes and scaffold EF Core entities.

Frequently Asked Questions about db-build-scaffold

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

FAQPage Schema
How do I sync EF Core entities with SQL Server schema changes?

To sync EF Core entities with SQL Server schema changes, build and deploy a SQL Server DACPAC and scaffold Entity Framework Core entities. This regenerates C# model files to accurately reflect the updated database schema and reports file differences.

What is SQL Server DACPAC deployment for EF Core scaffolding?

SQL Server DACPAC deployment for EF Core scaffolding is a process that builds and deploys database schema updates, then regenerates C# entity classes based on the updated schema to ensure model consistency and reduce manual refactoring.

How do I scaffold EF Core models after finalizing SQL schema edits?

To scaffold EF Core models after finalizing SQL schema edits, run the scaffolding process against the updated Neptune.Database directory. This deploys the schema changes and regenerates entity files in the Neptune.EFModels/Entities/Generated/ directory.

Does EF Core scaffolding report changes made to generated entity files?

Yes, EF Core scaffolding reports changes made to generated entity files. After regenerating C# entity classes based on the updated SQL Server database schema, the process tracks and reports the differences found in the generated files.

When do I need to regenerate C# entity classes from a SQL Server database?

You need to regenerate C# entity classes from a SQL Server database when you have finalized multiple changes to database tables and columns. This prevents synchronization issues by ensuring the C# Entity Framework Core model layer accurately reflects the latest schema.