|Title:||Visual Studio 2015 Entity Data Model Wizard halts with SQLiteException|
|Last Modified:||2016-06-21 20:21:09|
|Version Found In:||22.214.171.124|
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: (text/x-fossil-plain)
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: (text/x-fossil-plain)
This will not block the 126.96.36.199 release.
anonymous added on 2016-04-01 12:41:30: (text/x-fossil-plain)
Added logfiles and create scripts for database tables
mistachkin added on 2016-04-01 14:07:26: (text/x-fossil-plain)
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: (text/x-fossil-plain)
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.