EntityCommandExecutionException when creating entity model

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
Post Reply
dmcgloin
Posts: 3
Joined: Mon 21 Mar 2011 18:10

EntityCommandExecutionException when creating entity model

Post by dmcgloin » Mon 21 Mar 2011 20:03

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
---------------------------

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 22 Mar 2011 10:56

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: EntityCommandExecutionException when creating entity model

Post by Shalex » Thu 19 Jul 2012 11:15

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).

Post Reply