ASP.NET Core Code First数据库初始化第一步咨询（Update-Database无效）

Hey there! Let's work through this together since you're hitting issues with Update-Database not working and want to get your database initialized from code.

This is the foundational first step—EF Core can't interact with your database if it doesn't know how to connect to it or which entity model to use.

• First, confirm your DbContext class is set up correctly:
  You need a class that inherits from DbContext and defines your database entities via DbSet properties. For example:

  public class RestaurantDbContext : DbContext
  {
      // Constructor that accepts DbContext options (required for dependency injection)
      public RestaurantDbContext(DbContextOptions<RestaurantDbContext> options) : base(options)
      {
      }
  
      // Add DbSet properties for each entity in your database
      public DbSet<MenuItem> MenuItems { get; set; }
      public DbSet<Customer> Customers { get; set; }
      // Add other entities here as needed
  }
  

• Next, register the DbContext in your dependency injection container:
  In ASP.NET Core 6+, this goes in Program.cs. You'll bind it to your DefaultConnection string from appsettings.json:

  var builder = WebApplication.CreateBuilder(args);
  
  // Register DbContext with SQL Server provider
  builder.Services.AddDbContext<RestaurantDbContext>(options =>
      options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));
  
  // Rest of your service registrations...
  
  var app = builder.Build();
  
  // Middleware setup...
  
  app.Run();
  

  If you're using an older version (pre-6), this logic would live in Startup.cs's ConfigureServices method instead.

Before running this command, make sure you've got the necessary tools and packages in place:

1. Install EF Core CLI tools (if you haven't already):
   Run this in your terminal (not Package Manager Console):

   dotnet tool install --global dotnet-ef
   

2. Install required NuGet packages in your project:
   You need Microsoft.EntityFrameworkCore.SqlServer (for SQL Server support) and Microsoft.EntityFrameworkCore.Design (required for migration tools). You can install these via the NuGet Package Manager or terminal:

   dotnet add package Microsoft.EntityFrameworkCore.SqlServer
   dotnet add package Microsoft.EntityFrameworkCore.Design
   

Once those are set up, head to the Package Manager Console (PM), select the project that contains your RestaurantDbContext from the "Default project" dropdown, then run:

PM> dotnet ef migrations add Initial

This command scans your DbContext, generates a set of migration files (stored in a Migrations folder) that represent the initial database schema based on your entities. If it runs successfully, you'll see the new migration files appear in your project.

A quick note on why Update-Database might have failed: #

Common culprits include:

• Incorrect connection string (e.g., SQL Server isn't running locally, or the RestaurantDatabase doesn't exist yet—EF Core can create the database for you if it has permissions)
• The DbContext wasn't registered correctly in DI
• You ran the command from the wrong project
• Missing EF Core tools/packages

If you want to automate migration application (so you don't need to run Update-Database manually), you can add this code to Program.cs after building the app but before running it:

using (var scope = app.Services.CreateScope())
{
    var dbContext = scope.ServiceProvider.GetRequiredService<RestaurantDbContext>();
    // Applies all pending migrations to the database
    dbContext.Database.Migrate();
}

Just keep in mind: this is great for development, but in production, you might want to handle migrations more intentionally (like running them as part of your deployment pipeline).

内容的提问来源于stack exchange，提问作者Jalle