Page 1 of 1

guid primary key issues with EF

Posted: Thu 07 Oct 2010 00:16
by johnselkirk
When I use Entity Framework and SQLite provider with a PK column that is of type guid I get an error even with a simple table.

I get an error stating that the Primary Key and the Property do not match. Full error message including below and I have included a link to the source code and database that is causing the issue.

I can see nothing wrong with what I have done and it looks like an issue.

Any help would be appreciated

http://dl.dropbox.com/u/2292728/TCT/Dev ... KIssue.zip

Error:

The value of a property that is part of an object's key does not match the corresponding property value stored in the ObjectContext. This can occur if properties that are part of the key return inconsistent or incorrect values or if DetectChanges is not called after changes are made to a property that is part of the key.

Posted: Fri 08 Oct 2010 12:32
by AndreyR
Thank you for the report, I have reproduced the error.
I will notify about the results of our investigation.

Posted: Fri 08 Oct 2010 13:19
by johnselkirk
Great!

Let me know if you need anything from me.

Posted: Tue 05 Apr 2011 11:33
by AndreyR
We have fixed the error. The fixed build will be available in a week or so.

Posted: Thu 07 Apr 2011 12:39
by AndreyR
The new build of dotConnect for SQLite 3.10.135 is available for download now. This build fixes the problem.
It can be downloaded from Download Page (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to this announcement.