C# EF 操作Sqlite 出现问题，有经验的大佬进来指点下，感谢！！！

[手在键盘敲很轻]

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <configSections>
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <!--<connectionStrings>
    <add name="MainDb" connectionString="Data Source=|DataDirectory|\Db.sdf" providerName="System.Data.SqlServerCe.4.0" />
  </connectionStrings>-->
  <system.data>

    <DbProviderFactories>
      <remove invariant="System.Data.SQLite.EF6" />
      <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
      <remove invariant="System.Data.SQLite" />
      <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" />
    </DbProviderFactories>

  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlCeConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="System.Data.SqlServerCe.4.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="System.Data.SQLite" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
    </providers>
  </entityFramework>
</configuration>

如图，每次执行到圈起来那里就报错

System.TypeInitializationException
HResult=0x80131534
Message=The type initializer for 'System.Data.Entity.Internal.AppConfig' threw an exception.
Source=EntityFramework
StackTrace:
at System.Data.Entity.Internal.AppConfig.get_DefaultInstance()
at System.Data.Entity.Internal.LazyInternalConnection..ctor(DbContext context, String nameOrConnectionString)
at System.Data.Entity.DbContext..ctor()
at CSTK.Library.SqliteData.Model.EFDBContext..ctor() in D:\CSTK.Library\CSTK.Library.SqliteData\Model\EFDBContext.cs:line 17
at CSTK.Library.SqliteData.DBOperator..ctor()
at CSTK.CodeTesting.Program.Main(String[] args) in D:\CSTK.Library\CSTK.CodeTesting\Program.cs:line 24

此异常最初是在此调用堆栈中引发的:
[外部代码]

内部异常 1:
ConfigurationErrorsException: Configuration system failed to initialize

内部异常 2:
ConfigurationErrorsException: Unrecognized configuration section system.data. (D:\CSTK.Library\CSTK.CodeTesting\bin\Debug\netcoreapp3.1\CSTK.CodeTesting.dll.config line 9)
第九行是 <system.data>这个节点

[正怒月神]

ConfigurationErrorsException: Configuration system failed to initialize 很明显，就是配置初始化失败。 估计是默认调用了构造函数的关系。 你的无参构造函数改成这样

    
        public EFDBContext()
            : base(dbpath)
        {
        

    }

[正怒月神]

这里在给你2个方案。

public class EFDBContext: DbContext
    {
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            //注入Sql链接字符串
            optionsBuilder.UseSqlServer(dbpath);
        }

    }

或者 如果你没有把配置文件的 MainDb 注释掉 那么可以直接 public EFDBContext():base("name=MainDb")

[shawn_yang]

构造函数没做初始化？

[晨易夕]

sqlite的连接路径呢？

[手在键盘敲很轻]

引用 1 楼 shawn_yang 的回复:

构造函数没做初始化？

你看下面报的错，这不像是你说的问题

[strife013]

为啥用private 的构造函数，直接用public