We have the latest version of dotConnect for Oracle (6.30.196 28-Jul-11) and are using it with EF 4.1 (and code configuration, not edmx).
We got an entity with a field of type GUID mapped to a VARCHAR2(32) column.
When the data is saved into the database, the format is upper case without any dash (ex.: A0D8F7E720DDBF4296C932F7A730A635).
We later try to query thie entity with a where clause on this GUID field but cannot get any result. Our where clause looks like this (VB.NET)
Code: Select all
Where(Function(x) x.GuidField = anotherGuid)
Our model configuration of this field does not specified any database type because we want our configuration to be database agnostic.
We've tried RAW(16) and VARCHAR2(36) as column's type but got the same (no) result.
We've profiled the application with EfProf but the guid always appears as lower case with dash in both insert and select (where) clause. So we're not sure how to get help out of this.
Anyone has an idea about this problem. Is there any tips for us or workaround?
Any help is greatly appreciated