Unable to find the requested .Net Framework Data Provider – SQLite

by

had to add:

 <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" />
     </DbProviderFactories>
  </system.data>

to my app config file. and it now looks like:

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

  <startup useLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntime version="v4.0.30319" sku=".NETFramework,Version=v4.0,Profile=Client" />
  </startup>
  <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" />
      </DbProviderFactories>
    </system.data>
</configuration>

In the location where sqlite was installed I had to copy

enter image description here

to my output directory where my program exe is located

More Related Contents:

  1. SQLite Database Locked exception
  2. Enabling Foreign key constraints in SQLite
  3. What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
  4. Pass table valued parameter using ADO.NET
  5. Entity Framework with NOLOCK
  6. How do I return multiple result sets with SqlCommand?
  7. Create SQLite Database and table
  8. Encrypt password in App.config
  9. How do I get around the “‘” problem in sqlite and c#?
  10. Calling Oracle stored procedure from C#?
  11. Determine assembly version during a post-build event
  12. How to run multiple SQL commands in a single SQL connection?
  13. How to automatically update an application without ClickOnce?
  14. .NET application cannot start and receive XamlParseException
  15. Creating a SQL Server table from a C# datatable
  16. How should I multiple insert multiple records?
  17. SQLite .NET performance, how to speed up things?
  18. What is the best way to connect and use a sqlite database from C#
  19. How to auto create database on first run?
  20. What size do you use for varchar(MAX) in your parameter declaration?
  21. Returning a SqlDataReader
  22. I need a workaround for Excel Guessing Data Types problem
  23. How do I deploy two ClickOnce versions simultaneously?
  24. Merge msi and exe
  25. How to in-code supply the password to a connection string in an ADO.Net Entity Data Model
  26. How to get efficient Sql Server deadlock handling in C# with ADO?
  27. Encrypt SQLite database in C#
  28. How to create a password protected database?
  29. Do we have transactions in MS-Access?
  30. How do you Sort a DataTable given column and direction?

Leave a Comment