System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: fbebb30da9cbe8b98896df86225703849123f2dd
Title: VS 2010 and ADO ENtity Model error when try togenerate model from database
Status: Closed Type: Code_Defect
Severity: Severe Priority: NextRelease
Subsystem: LINQ Resolution: Fixed
Last Modified: 2012-01-28 08:35:44
Version Found In: 1.0.78.0
Description:
I have windows XP 32 bits, visual studio 2010 and I install sqlite-netFx40-setup-bundle-x86-2010-1.0.78.0.

First, I create a new connection, I select System.Data.SQLite database file as data source. I test the connection and it is ok.

Then, I add a new element, ADO.NET Entity Data Model and I try to create a new model from database. When I select the database, a s3db database, I get the following error, it's in spanish, in english is like that:

Error when trying to connect with database. Perhaps the database is not available. Exception System.Data.EntityCommandExecutionException. See the inner exception.

The inner exception says: the type of the exception is System.Resources.MissingManifiestResourceException, it's not found resources for the cultural reference. Check if System.Data.SQLite.Properties.Resources.resources has been linked correctly in the assembly System.Data.SQLite.Linq in the compilation.

I am trying to add in the config xml the following:

<system.data> <DbProviderFactories> <remove invariant="System.Data.SQLite" /> <add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".Net Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.78.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" /> </DbProviderFactories> </system.data>

But this does not solve the problem.

Before, I have used the version 1.0.66.0, the legacy version, and it works fine, I can create the model from database.

am I doing something wrong?

Thanks very much. Daimroc.


mistachkin added on 2012-01-27 19:37:06 UTC:
Fixed by check-in [b793978ba9].


anonymous added on 2012-01-28 07:53:32 UTC:
In the news, I see that there is a 1.9.79.0 release and the status is "not pending", with date 2012-01-28, but if I go to download section, I only see the 1.0.78.0.

Is it available the new version?


mistachkin added on 2012-01-28 08:35:44 UTC:
The release is pending and will be out sometime today.