System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: d39291b55416ec0854292fef5e9eff6eb71efce6
Title: SQLite with EF6 in Visual Studio 2010 not available
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: VsDesignerInstaller Resolution: External
Last Modified: 2016-03-28 22:14:52
Version Found In: sqlite-netFx40-setup-bundle-x86-2010-1.0.99.0
User Comments:
anonymous added on 2016-01-30 07:49:31:
Created a Windows project in Visual Studio 2010, Framework 4.0.

Installed NuGet Packages for below:

1. EntityFramework (Version: 6.0.0.0)
2. EntityFramework.SqlServer (Version: 6.0.0.0)
3. System.Data.SQLite (Version: 1.0.99.0)
4. System.Data.SQLite.EF6 (Version: 1.0.99.0)
5. System.Data.SQLite.Linq (Version: 1.0.99.0)

Trying to add ADO.Net Entity Data Model for SQLite but options available only for:
1. Microsoft SQL Server
2. Microsoft SQL Server Compact 3.5
3. Microsoft SQL Server Database File
4. <Other>

I can connect SQLite database file from Server Explorer but there is no option  for System.Data.SQLite Database File.

Then I installed "sqliteodbc" drivers from "http://www.ch-werner.de/sqliteodbc/"

still not getting option for SQLite for Entity Framawork!!!

Please help!

mistachkin added on 2016-02-01 18:31:24:
According to the following article, the design-time tools for EF6 are not supported on Visual Studio 2010:

https://stackoverflow.com/questions/20993794/can-i-use-entity-framework-6-with-visual-studio-2010