在VS 2015& EF7

本文介绍了在VS 2015& EF7的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试使用Windows Presentation Foundation应用程序，利用Entity Framework 7& SQLite数据库文件我做了* .edmx模型，但是当试图生成模型时，我不能使SQLite Connection。尝试从 - 但几个月前。有什么改变？有没有办法将VS2015上的EF7连接到SQLite？

解决方案

您需要从SQLite下载安装包。 我唯一使用的是 您可能还需要获取Visual Studio的SQL Server Compact / SQLite Toolbox扩展（工具/扩展和更新..）。有了它，您可以从MS Sql（beta）导出表格等。它适用于大多数表，但对于具有多个主键的表（复合键）来说，遇到困难。

I'm trying to make Windows Presentation Foundation application, utilizing Entity Framework 7 & SQLite Database File. I've made *.edmx model, but when trying to generate model i can't make SQLite Connection. Tried everything from system.data.sqlite/index.html/doc/trunk/www/downloads.wiki but nothing helped, still no option for creating proper connection.

There was already similar question - VS 2015 SQLite data provider - but it was few months ago. Have anything changed? Is there any way to connect EF7 on VS2015 to SQLite?

解决方案

You need to download a setup package from the SQLite. The only one I got it working with was sqlite-netFx46-setup-bundle-x86-2015-1.0.98.0.exe (The 64x version didn't do it).

You might also want to get the "SQL Server Compact/SQLite Toolbox" extension for Visual Studio (Tools/Extensions and Updates..). With it you can export tables from MS Sql (beta) among other things. It does work for most tables, had difficulties for tables with multiple primary keys in them (composite keys) though.