Page 1 of 1

EntityCommandExecutionException when creating entity model

Posted: Mon 21 Mar 2011 20:03
by dmcgloin
In Visual Studio 2010 using the latest devart release (downloaded today), when creating an Entity model from an existing sqlite database, I get the following error in a Visual Studio dialog box. Any ideas?

---------------------------
Microsoft Visual Studio
---------------------------
An error occurred while connecting to the database. The database might be unavailable. An exception of type 'System.Data.EntityCommandExecutionException' occurred. The error message is: 'An error occurred while executing the command definition. See the inner exception for details.

The inner exception caught was of type 'Devart.Data.SQLite.SQLiteException', with this error message: 'SQLite error

near ")": syntax error'.'.
---------------------------
OK
---------------------------

Posted: Tue 22 Mar 2011 10:56
by AndreyR
We are unable to provide EDM Designer support in SQLite.
Add Devart Entity Model to your project instead, it has almost the same functionality, but a more convenient designer.

Re: EntityCommandExecutionException when creating entity model

Posted: Thu 19 Jul 2012 11:15
by Shalex
New version of dotConnect for SQLite 4.1 is released!
It can be downloaded from http://www.devart.com/dotconnect/sqlite/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=29&t=24526 .

This version includes the support of Visual Studio LightSwitch 2011 (v1) and LightSwitch in Visual Studio 11 Beta/2012 RC (v2).