Can't create SQLite entity data model

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
Post Reply
Productys
Posts: 2
Joined: Sat 18 Jul 2009 03:24

Can't create SQLite entity data model

Post by Productys » Sat 18 Jul 2009 03:42

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
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Mon 20 Jul 2009 09:00

Thank you for the report, we have reproduced the problem.
I will let you know as soon as it is fixed.
Top
Productys
Posts: 2
Joined: Sat 18 Jul 2009 03:24

Still doesn't work...

Post by Productys » Tue 15 Sep 2009 16:14

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:
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 16 Sep 2009 08:14

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.
Top
Post Reply

Return to “dotConnect for SQLite”