I have installed the ADO.Net provider for SQLite and I checked the options to install design support for the express editions installed on my machine. When I go to the Database Explorer to add a connection to a SQLite database I have created, I choose SQLite database as the data source, but the resulting dialog doesn't give me the option to choose a database file. It just displays "Connection String" in bold, which can't be edited or in any way impacted.
When I click on the Test Connection button, VWD tells me that the connection tested successfully, but when I click on OK I get the following error message:
Could not load file
or assembly,Microsoft,VisualStudio.Data,
- Versions8.0.0.0,
culture neutral, PublicKeyToken= bo3f5flflldSOa3a or
one of its
dependencies. The located assemblys manifest definition
does not match the
assembly reference. (Exception from HRESULT:
0x8o131040)
and I cannot save the database connection.
I must be missing something. Do I understand correctly that I should be able to register my SQLite database in the database explorer and drag and drop tables to an entity model?