4

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."

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

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

Improve this question

4 Answers 4

Reset to default
4

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:

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 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 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 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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

3

Try add these lines

<dependentAssembly>   
  <assemblyIdentity name="Microsoft.VisualStudio.Data" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />   
  <bindingRedirect oldVersion="0.0.0.0-9.0.0.0" newVersion="10.0.0.0" />   
</dependentAssembly>

to the file C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\.config

Then restart Visual Studio.

Improve this answer

Comments

0

See this sqlite forum article. The connection string basically includes the filename and some options. Eg:

"Data Source=mydb.db;Version=3;New=True;"

This would use mydb.db as your sqlite database and use the version 3.0 runtime library (best) and would create a New db file if it did not exist.

Improve this answer

1 Comment

The sqlite "Tutorial Video" (sqlite.phxsoftware.com/sqlite.wmv) brings up a completely different dialog when creating the database. That dialog let you brows and configure setting as well, not just the data source. Maybe this is only in 2008 and not 2010?
0

Download SQLite binaries , extract zip, navigate to "bin/Designer" folder and run install.exe. Maybe this will help.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.