Thursday, May 6, 2010

SQLite for Visual Studio 2010

I just downloaded SQLite version "SQLite-1.0.66.0-setup". The EF designer works as expected on Visual Studio 2010. Well Done TEAM! you guys Rule!

Thanks and I will try to give as much back as I can. Amazing product. Best there is for a startup by FAR!

Enjoy!

Update June 19 2011 : As mentioned in the comment below SQLite for .NET now has a home sqlite.org !  : http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki

You can download the latest version from here : http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

Update June 28 2011 : As mentioned by John below the Designer support with the latest version is not available as of yet. You are free to use the old version of system.data.sqlite that comes with designer support for VS2010.

Posted by Unknown at 11:53 PM
Labels: , ,

17 comments:

  1. AnonymousJune 3, 2010 at 4:29 PM

    I just downloaded it and I am unable to make it work. There is no option to select a Sqlite data file as in VS2008. Could you post a little more information?

    ReplyDelete
  2. UnknownJune 3, 2010 at 9:40 PM

    I just went to server explorer -> (right click) Add connection -> Selected "SQLite Database File" -> Click Ok -> Click "Browse" and select the database file.

    Are you sure you have the latest version of SQLite for .NET ?
    Mine was : "SQLite-1.0.66.0-setup.exe"

    ReplyDelete
  3. AnonymousJune 9, 2010 at 12:19 PM

    Yes, I am using 1.0.66. 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."

    ReplyDelete
  4. UnknownJune 9, 2010 at 12:29 PM

    When you get the option of connection string "only" this points to the data tools for Visual Studio were not successfully installed.
    (Same as pointed out in Errors Section here : http://basaratali.blogspot.com/2010/02/setting-up-firebird-development-with-vs.html)

    Did you use the MSI Installer? (SQLite-1.0.66.0-setup.exe)

    ReplyDelete
  5. AnonymousNovember 17, 2010 at 8:35 PM

    Issue: Unable to Create a SQLite Data Connection with VS 2010

    At some point while installing "SQLite-1.0.66.0-setup.exe", I was given the option to install for VS 2010 and/or VS 2008. I chose VS 2010 only. I finally decided to uninstall and reinstall, selecting both VS 2008 & VS 2010. That fixed it.

    ReplyDelete
  6. UnknownNovember 17, 2010 at 10:12 PM

    Thanks for posting the solution. Appreciated :)

    ReplyDelete
  7. RaghunandanFebruary 10, 2011 at 3:18 AM

    Awesome guys nice info

    @Basarath thank you for the info

    i would appreciate if you can tell me how to handle Foriegn Keys

    ReplyDelete
  8. UnknownFebruary 12, 2011 at 3:26 AM

    If I make a sample i'll post it. A bit busy with work and learning new stuff right now. Sorry.

    ReplyDelete
  9. Kevin LehtiniittyApril 5, 2011 at 9:03 PM

    I'm having the same problem as anonymous (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.) in Visual C# 2010 but a reinstall didn't fix it. Do you guys have any ideas?

    ReplyDelete
  10. UnknownApril 5, 2011 at 9:42 PM

    @The L : Have you tried uninstalling and reinstalling ... this time selecting design time support for *both* VS2008 and VS2010. This might solve it be cause this will install the driver for .NET4 machine.config as well as .NET2-3.5 machine.config

    ReplyDelete
    Replies
    1. FlaburganApril 5, 2012 at 2:54 AM

      I have the same issue, only a connection string available, and uninstall / reinstall checking all visualstudio version doesn't fix it.

      I'm using Express version

      Delete
  11. AnonymousApril 15, 2011 at 4:47 PM

    Hello!! The version of sqlite in this installer is 3.6.23.1 right? in the sqlite page the amalgamation pack is 3.7.6.1, so how can I update it if I allready have the MSI installed??
    http://www.sqlite.org/sqlite-amalgamation-3070601.zip
    Thanks for your help :)

    ReplyDelete
  12. UnknownApril 16, 2011 at 1:01 AM

    @anonymous you will to recompile code at http://sourceforge.net/projects/sqlite-dotnet2/

    ReplyDelete
  13. AnonymousJune 18, 2011 at 10:14 PM

    Thanks Basarat for your help, and just for the record I found this:
    http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki
    and the download page:
    http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki
    So you can install the last version (3.7.6.3 now) to your proyects, I think this is great!

    ReplyDelete
  14. AnonymousJune 26, 2011 at 1:59 PM

    I just downloaded the latest version, which is http://system.data.sqlite.org/sqlite-dotnet-x86-1007300.exe, and there is no choice where you can select VS2010 support. It doesn't work with VS2010 either.

    ReplyDelete
  15. John ReynoldsJune 28, 2011 at 9:29 AM

    It doesn't work for me in version 10.0.73.0 either, and the reason is explained in the readme.htm, where the section about VS2010 support says "Currently not included. We are still updating the Design-Time support installer."

    ReplyDelete
  16. UnknownJune 28, 2011 at 9:57 AM

    @John I tried it on my computer which already had the old version installed .... my bad.

    ReplyDelete

Subscribe to: Post Comments (Atom)