Sqlite数据库 找不到请求的 .Net Framework Data Provider。可能没有安装

时间：2023-03-08 21:50:37

Sqlite数据库 找不到请求的 .Net Framework Data Provider。可能没有安装

 

解决方法 在web.config里面添加

<system.data>

        <DbProviderFactories>

            <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, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />

        </DbProviderFactories>

    </system.data>

注意:Version后面的 1.0.66.0  要根据你安装的sqlite的版本来写.

 

所有的web.config如下 

<?xml version="1.0" encoding="utf-8"?>

<!--

  有关如何配置 ASP.NET 应用程序的详细信息，请访问

  http://go.microsoft.com/fwlink/?LinkId=152368

  -->

<configuration>

  <appSettings>

    <add key="webpages:Version" value="1.0.0.0" />

    <add key="ConfigHaveEng" value="0" />

    <!--是否有英文版本  0否 1是-->

    <add key="ConfigLevel" value="0" />

    <!--能允许几级分类 如果为0 则表示网站最多有1级分类 |DataDirectory|-->

    <add key="ClientValidationEnabled" value="true" />

    <add key="UnobtrusiveJavaScriptEnabled" value="true" />

  </appSettings>

  <system.web>

    <customErrors mode="Off"/>

    <compilation debug="true" targetFramework="4.0">

      <assemblies>

        <add assembly="System.Web.Abstractions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

        <add assembly="System.Web.Helpers, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

        <add assembly="System.Web.Routing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

        <add assembly="System.Web.Mvc, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

        <add assembly="System.Web.WebPages, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />

        <add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

      </assemblies>

    </compilation>

    <authentication mode="Forms">

      <forms loginUrl="~/Account/LogOn" timeout="2880" />

    </authentication>

    <pages>

      <namespaces>

        <add namespace="System.Web.Helpers" />

        <add namespace="System.Web.Mvc" />

        <add namespace="System.Web.Mvc.Ajax" />

        <add namespace="System.Web.Mvc.Html" />

        <add namespace="System.Web.Routing" />

        <add namespace="System.Web.WebPages" />

      </namespaces>

    </pages>

  </system.web>

  <system.webServer>

    <validation validateIntegratedModeConfiguration="false" />

    <modules runAllManagedModulesForAllRequests="true" />

  </system.webServer>

  <runtime>

    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

      <dependentAssembly>

        <assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" />

        <bindingRedirect oldVersion="1.0.0.0-2.0.0.0" newVersion="3.0.0.0" />

      </dependentAssembly>

    </assemblyBinding>

  </runtime>

    <system.data>

        <DbProviderFactories>

            <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, Version=1.0.66.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />

        </DbProviderFactories>

    </system.data>

  <connectionStrings>

      <add name="SomeDbEntities" connectionString="metadata=res://*/MyModel.csdl|res://*/MyModel.ssdl|res://*/MyModel.msl;provider=System.Data.SQLite;provider connection string=&quot;data source=|DataDirectory|somedb.png&quot;" providerName="System.Data.EntityClient" />

  </connectionStrings>

</configuration>

相关文章