mardi 27 octobre 2015

SQ-Lite doesnt show as data provider in Visual Studio 2015

I currently reinstalled Windows 7 and in the process decided to upgrade from Visual Studio 2010 to VS 2015. I was working on a project (in C# / WPF ) using SQ-Lite and now I can't get SQ-Lite to run with VS 2015, specifically VS2015 doesnt recognize SQ-Lite as a data provider.

I have taken the following steps:

  1. Installed sqlite-netFx46-setup-bundle-x64-2015-1.0.98.0.exe from the website http://ift.tt/1bjYMJ4
  2. In VS (successfully) installed the NuGet-Packages System.Data.SQLite.EF6 and System.Data.SQLite via the Package-Console
  3. In my app.config I have added this line in DBProviderFactories:

    <add name="SQLite Data Provider (Entity Framework invariant="System.Data.SQLite.EF6"description=".NET Framework Data Provider for SQLite (Entity Framework type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
    
    
  4. I have removed and re-added the references, built/rebuilt the project, restarted VS2015, restarted Windows etc.

  5. I checked if the respective .dll files are allowed to be copied locally. ( The .dll for System.Data.SQLite.EF6 isnt in the project directory, but is referenced, I dont know if that is relevant)

Additionally, i have no admin rights on the system I'm working with, but the installations of VS 2015 and SQ-Lite (see step 1) were done by an admin, the NuGet packages I installed myself.

Obviously I am missing something and I'd appreciate any input. How can I get VS 2015 to identify SQ-Lite as a data provider?

1 commentaire:

  1. Same problem for me with a Windows 10 Pro 64 Bits
    As recommended I have installed sqlite-netFx46-setup-bundle-x32-2015-1.0.98.0.exe but without success.
    Someone has a solution?

    RépondreSupprimer