System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 6ccf988ff30568f404ca8f53d442d7b1f7bb3235
Title: Visual Studio 2015 Entity Data Model Wizard halts with SQLiteException
Status: Closed Type: Incident
Severity: Important Priority: Low
Subsystem: VsDesigner Resolution: Need_More_Info
Last Modified: 2016-06-21 20:21:09
Version Found In: 1.0.99.0
User Comments:
anonymous added on 2016-03-21 16:50:20:
After installing the bundle containing the design time components for VS2015 I tried to create an EDMX model from an existing SQLite database using the ADO.NET Entity Model wizard.

The first step (Choose your data connection) presents a dropdown containing the SQLite connection that I created in the Server Explorer.

The next step (Choose your database objects and settings) fails. A Visual Studio error (red cross) dialog is presented as follows:
**********
Title: Microsoft Visual Studio
Content: An error occurred while connecting to the database. The database might be unavailable. An exception of type 'System.Data.Entity.Core.EntityCommandExcecutionException' occurred. The error message is: 'An error occorred while executing the command definition. See the inner exception for details. The inner exception caught was of type 'System.Data.SQLite.SQLiteException', with this error message: 'SQL logic error or missing database no such column: second'.'.
***********
(Note the weird quoted '.' in the inner exception message)

Thanks for your reply!

Regards
Sjors.

mistachkin added on 2016-04-01 03:07:41:
In order to investigate this issue, I would need the schema of the database
table(s) involved.

Also, having the setup logs would be useful.  The log files should be located
in the %TEMP% directory on the machine.  They will have names similar to
"Setup Log 2016-03-30 #001.txt" and "Installer.exe.trace.tmp29.log".

mistachkin added on 2016-04-01 03:07:58:
This will not block the 1.0.100.0 release.

anonymous added on 2016-04-01 12:41:30:
Added logfiles and create scripts for database tables

mistachkin added on 2016-04-01 14:07:26:
Judging from the log files, it seems that more than one instance of the
design-time components has been installed?  Currently, that configuration
is not supported as it is not known to work right.

Can you try uninstalling all the System.Data.SQLite instances from the
Control Panel, reboot, and then *only* install the one for Visual Studio
2015?

anonymous added on 2016-04-04 09:33:12:
Thanks for your reply.

Before submitting this request I did just that. Currently I only have one entry for SQLite in my Control Panel. See attached screenshot.