System.Data.SQLite

Hello, 

 I have a problem when using entity framework with linq : 

I tried following these steps : http://kubasik.net/blog/2009/02/09/using-linq-to-sqlite-providers-updated/

And I can create a connection in server explorer, 

but when I add an entity data model and choose from database I cannot select that connection, 

also when trying to create a new connection in this window I cannot select the sqlite dataprovider.

When I installed the provider I selected install designtime support. 

Can anyone help? 

Thanks in advance!

Sven

 i had this same problem!

 If you had this problem, were you able to solve it?

 Thanks.

 (My Visual Studio 2008 is in french so there could be some inconsistencies, sorry.)

- Start your project

- Select the project in solution explorer

- Add a new element

- select "ADO.NET Entity Data Model" and name it

- Generate from Database

- New connection -> Modify the datasource -> "SQLite Database file" should be there with ".Net Framework Data Provider for SQLite" as the provider

Select the database and whatever you want and it should work without any problems.

Hope this helps. (I'm probably a bit late though as I just joined today.)

 Thank you for your reply,

I tried that, but when i try to add a new connection there is no sqlite database or sqlite provider there. 

I have tried reïnstalling the provider but no result.

 I had the same problem with 1.0.66 and then I eventually found a solution. There's something wrong with the bundled installer. So my fix was done on Windows 7, but should apply to all systems...

 Essentially you have to uninstall the provider by double clicking on the original installer and choosing "Remove product".

 Once you have done this, change the compatibility settings to run the installer using "Windows XP Service Pack 2" and installing it for "Me Only" and not "Everyone". I think the problem comes in with the registration for everyone as this does not seem to register the provider properly (Windows complained about the installer not using proper settings and showed the "Reinstall product using recommended settings" dialog box). After doing this, I can now successfully generate the Entity model using my SQLite data sources.

 Hope this works for someone else as well! I can't live without my LINQ queries :)