SQLite的安装问题，用Visual C＃2010 [英] SQLite installation problem with visual c# 2010

问题描述

我尝试使用SQLite，使数据库在Visual C＃2010，但是当我选择SQLite数据库文件我没有得到机会指向一个数据库文件。我收到询问我连接字符串的对话框。我一直没能拿出，不给我的错误无法加载文件或程序的连接字符串'Microsoft.VisualStudio.Data，版本= 9.0.0.0，公钥= ...'找到的程序集清单定义不匹配的组装参考。

I'm trying to use SQLite to make databases in visual c# 2010 but when I select "SQLite Database File" I don't get the opportunity to point to a database file. I get a dialog that asks me for a connection string. I have not been able to come up with a connection string that doesn't give me the error "Could not load file or assembly 'Microsoft.VisualStudio.Data, version=9.0.0.0, PublicKeyToken=...'The located assembly's manifest definition does not match the assemble reference."

我了解到，这是由于数据工具Visual Studio中没有安装成功，但我已经试过卸载并重新安装无济于事。唯一相关的线程我能找到的是在的http：// www.basarat.com/2010/05/sqlite-for-visual-studio-2010.html

I've learned that this is due to the data tools for Visual Studio were not successfully installing, but I've tried uninstalls and reinstalls to no avail. The only relevant thread I could find was at http://www.basarat.com/2010/05/sqlite-for-visual-studio-2010.html

我使用了最新的SQLite-1.0.66.0-建立。有没有人有什么想法？

I used the latest SQLite-1.0.66.0-setup. Does anyone have any thoughts?

推荐答案

可能会或可能不会解决你的问题。从我的博客文章下面的关于我自己的获取最新的SQLite和2010前几天在Visual Studio中去体验：

May or may not solve your problem. Here's from my blog post on my own experience with getting the latest SQLite up and going in Visual Studio 2010 a few days ago:

这sqllite.org当前的二进制安装的System.Data.SQLite .NET程序集不包括在服务器资源管理器使用SQLite所需的Visual Studio的设计师或ADO.NET驱动程序。因此，这里的最佳组合我已经找到了让我的环境设置正确。

The current binary installers from sqllite.org for the System.Data.SQLite .NET assembly do not include the Visual Studio designers or the ADO.NET driver required for use of SQLite in the Server Explorer. So here’s the winning combination I’ve found for getting my environment set up properly.

1.Download因为当前的二进制安装从sourceforge.net安装版本1.0.66.0 SQLite.org在system.data.sqlite.org不包括Visual Studio设计或ADO.NET驱动程序安装。

1.Download and install version 1.0.66.0 from sourceforge.net because current binary installs on SQLite.org at system.data.sqlite.org do not include the Visual Studio designer or ADO.NET driver install.

2.Download并安装最新版本（86和x64）从system.data.sqlite.org（目前1.0.73.0其中包含的SQLite 3.7.6.3引擎）。
重要提示：如果您有Visual Studio 2008和2010年的时候提示我发现从别人谁了，否则问题的报道一定要选择既

2.Download and install the latest versions (x86 and x64) from system.data.sqlite.org (currently 1.0.73.0 which contains the SQLite 3.7.6.3 engine). Important Note: If you have Visual Studio 2008 and 2010, be sure to choose both when prompted as I found reports from others who had problems otherwise.

3 .Copy的x86二进制进入和覆盖文件位于C：\Program文件（x86）\SQLite.NET\bin（假设你使用的是默认为1.0.66.0版本的安装位置和你正在运行的Windows 64）。如果你是在一个64箱，64位二进制文​​件复制到C：\Program文件（x86）\SQLite.NET\bin\x64目录，覆盖现有文件

3.Copy the x86 binaries into and overwriting file at C:\Program Files (x86)\SQLite.NET\bin (assuming you used the default install location for version 1.0.66.0 and you're running x64 Windows). And if you are on an x64 box, copy the x64 binaries to the C:\Program Files (x86)\SQLite.NET\bin\x64 directory, overwriting existing files.

这篇关于SQLite的安装问题，用Visual C＃2010的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！