System.Data.SQLite: View Ticket

Ticket Hash:	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 9.85 years ago	Created:	2015-05-21 00:17:29 9.94 years ago
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.