guid primary key issues with EF

johnselkirk · Post by **johnselkirk** » Thu 07 Oct 2010 00:16

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.

AndreyR · Post by **AndreyR** » Fri 08 Oct 2010 12:32

Thank you for the report, I have reproduced the error.
I will notify about the results of our investigation.

johnselkirk · Post by **johnselkirk** » Fri 08 Oct 2010 13:19

Great!

Let me know if you need anything from me.

AndreyR · Post by **AndreyR** » Tue 05 Apr 2011 11:33

We have fixed the error. The fixed build will be available in a week or so.

AndreyR · Post by **AndreyR** » Thu 07 Apr 2011 12:39

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.