Page 1 of 1

Can't create SQLite entity data model

Posted: Sat 18 Jul 2009 03:42
by Productys
Hi, I'm already using ADO.NET connector for Postgres and Oracle (pro version) and I'm evaluating the SQLite Trial connector.
When I try to create a new entity data model using the VS wizard I get an error "System.Data.ProviderIncompatibleException' : DbConnection "Devart.Data.SQLite.SQLiteConnection" does not contain ProviderFactory.

The connection test succeeds so I think that the connectionstring is ok.

Any idea ? I really need to know quickly if I can rely on this connector.

Thanks by advance.

SQLite version 3.6.16

Posted: Mon 20 Jul 2009 09:00
by AndreyR
Thank you for the report, we have reproduced the problem.
I will let you know as soon as it is fixed.

Still doesn't work...

Posted: Tue 15 Sep 2009 16:14
by Productys
I've downloaded the last version of DotConnect for SQLite (version 2.30.42)
but when I try creating an entity framework connection I got a new error message "SQLite error near ")" : syntax error".

Can you help us ? We really need to see this working before buying it.

Thanks by advance for your quick reply :wink:

Posted: Wed 16 Sep 2009 08:14
by AndreyR
There is a technical problem preventing us from supporting the Microsoft EDM Wizard.
I recommend you to add the Devart Entity Model to your project and edit the model using Devart Entity Developer.