我有一个非常基本的迁移文件。我正在执行dotnet ef database update --verbose
在包管理器控制台窗口中,SQL Server 中没有生成任何内容。
包管理器控制台窗口中的最后几行输出如下所示:
Finding design-time services for provider Microsoft.EntityFrameworkCore.SqlServer...
Using design-time services from provider Microsoft.EntityFrameworkCore.SqlServer.
Finding design-time services referenced by assembly BM.Server.
No referenced design-time services were found.
Finding IDesignTimeServices implementations in assembly BM.Server...
No design-time services were found.
Done.
这是我的代码的样子,添加和删除迁移工作。只是尝试更新我遇到此问题的数据库。
public class Program
{
public static void Main(string[] args)
{
CreateHostBuilder(args).Build().Run();
}
public static IHostBuilder CreateHostBuilder(string[] args) =>
Host.CreateDefaultBuilder(args)
.ConfigureWebHostDefaults(webBuilder =>
{
webBuilder.UseStartup<Startup>();
});
}
public class Startup
{
public void ConfigureServices(IServiceCollection services)
{
services.AddDbContext<BMDbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("BMDbConnectionString")));
}
}
public class BMDbContext : DbContext
{
public BMDbContext(DbContextOptions<BMDbContext> options) : base(options) { }
}
我还为该项目安装了以下 nuget 软件包,并且两个 dll 都在我的 bin 目录中:
Microsoft.EntityFrameworkCore.SqlServer
Microsoft.EntityFrameworkCore.Design
正如中所引用的本文 https://learn.microsoft.com/en-us/ef/core/miscellaneous/cli/dbcontext-creation您应该添加设计时 DbContext。将以下类添加到您的项目中:
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Design;
namespace WebApplication8
{
public class DesignTimeBMDbContext : IDesignTimeDbContextFactory<BMDbContext>
{
public BMDbContext CreateDbContext(string[] args)
{
var optionsBuilder = new DbContextOptionsBuilder<BMDbContext>();
// pass your design time connection string here
optionsBuilder.UseSqlServer("<connection_string>");
return new BMDbContext(optionsBuilder.Options);
}
}
}
添加此类后,EF CLI 将使用它进行设计时数据库创建和更新
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)