SQLite连接未出现在实体数据模型向导(vs2015)中 [英] SQLite connection not appearing in Entity Data Model Wizard (vs2015)

问题描述

我所做的是

1)在vs2015中创建了一个项目(.Net Framework 4.6) 2)从Nuget安装了System.Data.SQLite.实际上是System.Data.SQLite(1.0.105.1)，System.Data.SQLite.Core(1.0.105.1)，System.Data.SQLite.EF6(1.0.105.1)，System.Data.SQLite.Linq(1.0.105.1) ，EntityFramework(6.0.0)已安装 3)在Nuget中将EntityFramework更新为6.1.3 4)尝试从本地Sqlite数据库创建实体数据模型 5)重建整个解决方案

1) Created a project in vs2015 (.Net Framework 4.6) 2) Installed System.Data.SQLite from Nuget. Actually System.Data.SQLite(1.0.105.1),System.Data.SQLite.Core(1.0.105.1),System.Data.SQLite.EF6(1.0.105.1),System.Data.SQLite.Linq(1.0.105.1),EntityFramework(6.0.0) were installed 3) Updated EntityFramework to 6.1.3 in Nuget 4) Tried to create Entity Data Model from a local Sqlite database 5) Rebuilded the whole solution

但是当我尝试创建新的数据库连接时，SQLite连接没有出现在数据源中.

But when I tried to create a new database connection, SQLite connection was not appearing in the data source.

有人能找出这个问题吗?

Can anyone figure out this issue?

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configsections>

<!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->

<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6" />

<entityframework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
<providers>
<provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />


<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.SQLiteFactory, System.Data.SQLite" />

推荐答案

AFAIK，SQLite的nuget软件包中不包含设计器支持:您将需要安装所指示的Visual Studio版本的软件包.使用.

AFAIK the designer support is not included in the nuget packages of SQLite: you will need to install the package that is indicated for the version of Visual Studio that you are using.

根据 System.Data.SQLite下载页面当前是VS 2015中唯一提供设计器支持的软件包是 32位Windows(.NET Framework 4.6)的安装程序sqlite-netFx46-setup-bundle-x86-2015- 1.0.105.1.exe(16.93 MiB)，其说明中包含以下句子:

According to the System.Data.SQLite downloads page currently the only package providing designer support in VS 2015 are the Setups for 32-bit Windows (.NET Framework 4.6) sqlite-netFx46-setup-bundle-x86-2015-1.0.105.1.exe (16.93 MiB), which contains the following sentence in its description:

这是唯一能够安装Visual Studio 2015设计时组件的安装程序包.

这篇关于SQLite连接未出现在实体数据模型向导(vs2015)中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！