System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: a92e58cfafa0a6f01c4b95b78f5c36b1d6a39741
Title: Sqlite is not shown on Entity Data Model Wizard
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: NuGetPackage Resolution: Need_More_Info
Last Modified: 2015-06-26 03:09:59
Version Found In: 1.0.96
User Comments:
anonymous added on 2015-05-21 00:17:29:
To create ADO.NET entity data model, I used "Generate from database" on "Entity Data Model".

But Data Source list doesn't have Sqlite Database.

In Server Explorer, I tried to connect database, in this time, Data source list has "System.Data.SQLite Database File".

I don't know why.

I'm using VS 2013 and VS 2010 on Windows 8.1 Pro(x64). Both of them have same problem.

My PC is installed "sqlite-netFx451-setup-bundle-x86-2013-1.0.96.0.exe" and "sqlite-netFx40-setup-bundle-x86-2010-1.0.96.0.exe"

mistachkin added on 2015-05-21 16:29:21:
Did you install the System.Data.SQLite.EF6 NuGet package?  It is required for the
Entity Framework 6 integration to work.

anonymous added on 2015-06-01 02:29:28:
I installed nuget package. But nothing has changed.

mistachkin added on 2015-06-01 05:24:57:

Please try the following:

1. Uninstall all instances of System.Data.SQLite from the Control Panel.

2. Reboot.

3. Download and install ONLY the System.Data.SQLite 1.0.97.0 release package
   for Visual Studio 2010, here:
sqlite-netFx40-setup-bundle-x86-2010-1.0.97.0.exe
4. Create a branch new project using Visual Studio 2010, save it, and add the
   NuGet package "System.Data.SQLite".

5. Add a data source in Visual Studio 2010 Server Explorer for SQLite.

6. Run the Entity Data Model Wizard.