使用框架 .NET8
在nuget中，需要安裝包：
SQLitePCLRaw.bundle_e_sqlite3，版本 2.1.10
Microsoft.EntityFrameworkCore.Sqlite.Core，版本 9.0.0
using Microsoft.Data.Sqlite;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Options;
using System.Reflection.Metadata;
using WpfRepairProject.Model;namespace WpfRepairProject.IData_impl
{public class EFContextSQLite : DbContext{protected override void OnConfiguring(DbContextOptionsBuilder options){try{string sqlitefileName = WpfSnqkGasAnalysis.Model.MyConfigReader.GetConfigValue("connctionDb");string filePath = Path.Combine(AppContext.BaseDirectory, "DataBase", sqlitefileName);#if DEBUGfilePath = "G:\\work_my_test\\推薦表單\\linjie_recommend_project\\代碼\\snqk_wpf_qi\\WpfSnqkGasAnalysis\\WpfSnqkGasAnalysis\\DataBase\\ljRepaireProject.sqlite";
#endifoptions.UseSqlite($"Data Source={filePath}");//設置不跟蹤所有查詢 options.UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking);#if DEBUG//啟用敏感數據日志記錄options.EnableSensitiveDataLogging();//記錄日志 options.LogTo(msg =>{//調試-窗口消息System.Diagnostics.Debug.WriteLine(msg);//輸出-窗口消息Console.WriteLine(msg);}, Microsoft.Extensions.Logging.LogLevel.Information);
#endif// options.}catch (Exception ex){ex = ex.InnerException ?? ex;LogHelpter.AddLog("數據庫連接異常，" + ex.Message, "error_DbContext");}}public DbSet<K_department> K_department { get; set; }public DbSet<K_user> K_user { get; set; }public DbSet<K_login_log> K_login_log { get; set; }public DbSet<K_operate_log> K_operate_log { get; set; }public DbSet<K_repair_classify> K_repair_classify { get; set; }public DbSet<K_repair_project> K_repair_project { get; set; }public DbSet<K_repair_recommend_main> K_repair_recommend_main { get; set; }public DbSet<K_repair_recommend_result> K_repair_recommend_result { get; set; }public DbSet<K_service_department> K_service_department { get; set; }}
}
)
