ConsoleApp1/MyDbContext.vb

微信扫码关注公众号，代码整理好后第一时间通知你。

Imports Microsoft.EntityFrameworkCore
Public Class MyDbContext
    Inherits DbContext

    Protected Overrides Sub OnConfiguring(optionsBuilder As DbContextOptionsBuilder)
        MyBase.OnConfiguring(optionsBuilder)
        'Dim sb1 As New MySql.Data.MySqlClient.MySqlConnectionStringBuilder() With {
        '    .Database = "demo",
        '    .UserID = "root",
        '    .Password = "123456",
        '    .Server = "localhost"
        '}
        'optionsBuilder.UseMySQL(sb1.ConnectionString)

        'Dim sb2 As New Microsoft.Data.SqlClient.SqlConnectionStringBuilder() With {
        '    .InitialCatalog = "demo",
        '    .UserID = "demo",
        '    .Password = "123456",
        '    .DataSource = "localhost",
        '    .TrustServerCertificate = True
        '}
        'optionsBuilder.UseSqlServer(sb2.ConnectionString)

        optionsBuilder.UseSqlite("data source=C:\Users\coder\Desktop\2023\8\20230831\submit\4\人员信息管理系统案例\WpfApp2\Users.db")

        optionsBuilder.LogTo(AddressOf Console.WriteLine, Microsoft.Extensions.Logging.LogLevel.Information)
    End Sub

    Protected Overrides Sub OnModelCreating(modelBuilder As ModelBuilder)
        MyBase.OnModelCreating(modelBuilder)
        modelBuilder.Entity(Of User).ToTable("users").HasKey(Function(x) x.Id)
    End Sub
End Class