System.Data.SQLite: View Ticket

2012-01-28
08:35		• Ticket [fbebb30da9] VS 2010 and ADO ENtity Model error when try togenerate model from database status still Closed with 1 other change artifact: 183b91509c user: mistachkin
07:53		• Ticket [fbebb30da9]: 1 change artifact: 265dde851a user: anonymous
2012-01-27
22:36		• Closed ticket [fbebb30da9]. artifact: cff4569695 user: mistachkin
19:37		• Pending ticket [fbebb30da9]. artifact: 0cde97813f user: mistachkin
19:35		Correct the resource name for the LINQ assembly. Fix for ticket [fbebb30da9]. check-in: b793978ba9 user: mistachkin tags: trunk
16:54		• New ticket [fbebb30da9] VS 2010 and ADO ENtity Model error when try togenerate model from database. artifact: 4be1972200 user: anonymous

Ticket Hash:	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.