ef-core

Entity Framework Core migrations evolve your database schema safely. Use `dotnet ef migrations add [MigrationName]` to generate a migration file, then `dotnet ef database update` to apply it to your database. This workflow captures schema changes and makes them version-controllable.

Entity configuration in EF Core defines how your classes map to database tables, including relationships and constraints. Configure entities via the Fluent API or data annotations to enforce cascade delete rules, foreign keys, and constraints that match your project standards.

The repository pattern abstracts data access logic through interfaces and implementations. Define repository interfaces with custom methods, then implement them using EF Core's DbContext to query, insert, update, and delete data while maintaining clean separation between data access and business logic.

Entity Framework Core fully supports SQLite as a database provider. SQLite is ideal for desktop and small-scale applications, offering file-based persistence without a separate server. Configure the EF Core context to use SQLite and run migrations to initialize your schema.

Cascade delete rules determine what happens to related child records when you delete a parent entity. Configure cascade behavior through entity relationships to automatically delete, orphan, or restrict deletion of child records based on your application's data integrity requirements.

To rollback a migration, use `dotnet ef migrations remove` to delete the latest unapplied migration, or `dotnet ef database update [PreviousMigration]` to revert the database to a prior state. Always backup production databases before rollback operations.