WPF 使用 DI EF CORE SQLITE

WPF 使用 DI EF CORE SQLITE

1.安装 nuget包

<PackageReference Include="Microsoft.EntityFrameworkCore.Sqlite" Version="9.0.4" />

2.创建DbContext的实现类，创建有参构造函数

  public XXContext(DbContextOptions<XXXContext> options) : base(options)
  {
  }

不创建有参构造函数会注入会报下面的错误

ArgumentException: 'AddDbContext' was called with configuration, but the context type 'XXContext' only declares a parameterless constructor. This means that the configuration passed to 'AddDbContext' will never be used. If configuration is passed to 'AddDbContext', then 'XXContext' should declare a constructor that accepts a DbContextOptions<XXContext> and must pass it to the base constructor for DbContext.

3.appsettings.json 配置文件中增加配置项

{
  "ConnectionStrings": {
    "XXContextSQLite": "Data Source=XX.db"
  }
 }

4.在主机配置中增加配置

    private static readonly IHost _host = Host.CreateDefaultBuilder()
        //.ConfigureLogging(config => { config.AddConsole(); })
        .ConfigureServices((context, services) =>
        {
            services.AddSingleton<INavigationService, NavigationService>();
            services.AddSingleton<MainWindow>();
            services.AddSingleton<MainWindowViewModel>();
            services.AddDbContext<XXContext>(options =>
            options.UseSqlite(context.Configuration.GetConnectionString("XXContextSQLite")));
        })
        .Build();

5.生成数据库

主机启动后执行 context.Database.EnsureCreated();

会创建配置文件中配置的数据库

 _host.Start();

 using (var scope = _host.Services.CreateScope())
 {
     var services = scope.ServiceProvider;
     var context = services.GetRequiredService<XXContext>();
     context.Database.EnsureCreated();
     // DbInitializer.Initialize(context);
 }
  

6.种子数据

在DbContext 实现类中重写 OnModelCreating 方法

 protected override void OnModelCreating(ModelBuilder modelBuilder)
 {
     modelBuilder.Entity<Channel>().HasData(

     new Channel { ID = 1, ChanelNum = "D1", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 2, ChanelNum = "D2", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 3, ChanelNum = "D3", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 4, ChanelNum = "D4", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 5, ChanelNum = "D5", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 6, ChanelNum = "D6", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 7, ChanelNum = "D7", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 8, ChanelNum = "D8", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 9, ChanelNum = "D9", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 10, ChanelNum = "D10", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 11, ChanelNum = "D11", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 12, ChanelNum = "D12", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 13, ChanelNum = "D13", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 14, ChanelNum = "D14", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 15, ChanelNum = "D15", ChannelName = String.Empty, CreateTime = DateTime.Now },
     new Channel { ID = 16, ChanelNum = "D16", ChannelName = String.Empty, CreateTime = DateTime.Now });
 }

参考

ASP.NET Core 中的 Razor Pages 和 Entity Framework Core - 第 1 个教程（共 8 个） | Microsoft Learn

ASP.NET Core 中的 Razor Pages 和 Entity Framework Core - 第 1 个教程（共 8 个） | Microsoft Learn