MIC.Infrastructure.Data

To configure Entity Framework Core database provider detection, set environment variables or appsettings.json connection strings so the infrastructure automatically selects SQLite or PostgreSQL based on the current environment configuration.

Automating database migrations during startup involves loading dependency injection to establish the correct context, which then handles automatic migrations, database creation, and backup operations before applying updates.

Yes, you can use environment variables for database connection handling, as the configuration system explicitly supports them alongside appsettings.json or explicit connection strings to establish flexible environment-sensitive setups.

Yes, you need Microsoft.Extensions.DependencyInjection to load the database context setup, as it registers the correct context and ensures reliable connection handling during application startup.

To back up a database before running migrations, the infrastructure automatically handles backup creation before updates, ensuring your local SQLite or production PostgreSQL data is protected during schema changes.