Ticket Hash: | b86ebd5bbd37d253fffb8e40992c6f8dd5328c3d | ||
Title: | EF6 Designer Support in Visual Studio Community 2015 | ||
Status: | Closed | Type: | Incident |
Severity: | Important | Priority: | Medium |
Subsystem: | VsDesignerInstaller | Resolution: | Not_A_Bug |
Last Modified: |
2016-08-25 00:50:20 8.76 years ago |
Created: |
2016-04-26 14:31:47 9.09 years ago |
Version Found In: | 1.0.101 |
User Comments: | ||||
anonymous added on 2016-04-26 14:31:47:
I am trying to get ‘EF Designer from Database’ to work in Visual Studio Community 2015 with a SQLite database. But I'm not able to see the SQLite Provider or my existing SQLite database when trying to choose a new connection. My VS project properties target .Net Framework 4.5.1 and Any CPU | Prefer 32-bit. I’m on Windows 8.1 on a 64-bit computer if any of that matters. I used NuGet Package Manager to install Entity Framework 6.1.3 and SQLite 1.0.101 (which installed System.Data.SQLite, System.Data.SQLite.Core, System.Data.SQLite.EF6, and System.Data.SQLite.Linq) in a new WinForms app. The only Data Sources and Data Provider I’m seeing in the Choose Data Source dialog box are MS SQL Server. My app.config file seems to me to look OK (below), though I've seen numerous posts about previous versions of SQLite and VS that suggested different settings, many of which I've tried without success: <entityFramework> <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework"> <parameters> <parameter value="mssqllocaldb"/> </parameters> </defaultConnectionFactory> <providers> <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/> <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6"/> </providers> </entityFramework> <system.data> <DbProviderFactories> <remove invariant="System.Data.SQLite.EF6"/> <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6"/> <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.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6"/> </DbProviderFactories> </system.data> mistachkin added on 2016-05-01 23:01:10: Did you install the design-time setup package for Visual Studio 2015 first? It's available here: sqlite-netFx46-setup-bundle-x86-2015-1.0.101.0.exe anonymous added on 2016-05-02 18:57:49: As part of the alternative approaches I've tried, I did install sqlite-netFx451... since my target .Net platform was 4.5.1. Do I need to use netFx46? mistachkin added on 2016-05-04 13:26:31: Yes, you would need the specific setup package for VS 2015. |