Minimal API Development with ASP.NET Core - Create Database Migration

What is a key advantage of using the code-first approach over the database-first approach?

• It provides better performance.

• It is more compatible with older systems.

• It requires less initial setup.

• It allows for easier tracking of database changes.

Which tool is used to manage packages in Visual Studio for setting up migrations?

• Package Manager Console

• Command Prompt

• SQL Server Management Studio

• Entity Framework Designer

Which command is used to install the Entity Framework Core Design package?

• dotnet install EF Core Design

• dotnet package add EF Core Design

• dotnet add package Microsoft.EntityFrameworkCore.Design

• dotnet EF install Design

What command is used to add a migration in the .NET CLI?

• dotnet create migration

• dotnet EF add migration

• dotnet EF migrations add

• dotnet add migration

What is the role of the DB context in a data project?

• To store application settings

• To handle user authentication

• To define the database schema

• To manage database connections

What does the 'update-database' command do?

• It updates the database schema to the latest migration.

• It creates a new database.

• It generates a new migration file.

• It deletes the existing database.

What might cause a warning during the migration process?

• Adding a new table

• Removing a column

• Using a string data type

• Changing a decimal data type

What does the 'net EF database update' command do in the .NET CLI?

• It installs the Entity Framework tools.

• It deletes the existing database.

• It creates a new migration file.

• It updates the database to match the latest migration.

How can you verify if your database has been created in Visual Studio?

• By using the Entity Framework Designer

• By opening the Command Prompt

• By running a SQL query

• By checking the Server Explorer

What is the purpose of the EF migrations history table?

• To store user data

• To manage database connections

• To track applied migrations

• To log errors