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.