aspnet-api-development

What problem does it solve?

Provides targeted operational patterns and remediation steps for ASP.NET Core APIs in Cambium to prevent and recover from authentication failures, EF Core schema drift, startup migration breakages, and connection string/configuration misparsing that cause widespread endpoint outages.

Core Features & Use Cases

• Smart PolicyScheme (Dual Auth): Guidance to implement a selector that chooses JWT or cookie authentication based on the Authorization header to avoid SPA redirects and ensure correct 401 handling.
• EF Core Column-Drift Detection & Recovery: Practices to detect PostgreSQL 42703 column-missing failures, a per-ALTER self-healing pattern that isolates failures, and a post-heal verification step to assert expected columns exist.
• Safe Startup & Migration Policy: Instructions to run non-destructive ALTER statements with individual try/catch, avoid MigrateAsync to prevent destructive Railway behavior, and manage migrations via scripts or manual application.
• Railway DATABASE_URL Parsing & DataProtection Persistence: Exact parsing approach for Railway's DATABASE_URL and the requirement to persist DataProtection keys to the database to avoid silent cookie invalidation after restarts.
• Use Case Examples: Recover from a 42703 error that crashes logins, stop SPA clients receiving 302 redirects on API calls, and rehydrate DataProtection keys after a fresh Railway deploy.

Quick Start

Use the aspnet-api-development skill to analyze a Cambium API issue (401, 42703, or missing DataProtection keys) and produce a prioritized remediation plan with self-heal ALTER statements and verification queries.