Case-Sensitivity problem with GetEntities

Our database is case-sensitive. We get the error shown below when a primary key varchar field contains data with the same value, differing only by text. For example, use this table:

create table CaseTest (col1 varchar(10))

go

insert CaseTest values ('a')

insert CaseTest values ('A')

Set col1 as primary key in the object mapper. Then call GetEntities(Of CaseTest) (see screenshot) to reproduce it. I tried setting

pm.DataSet.CaseSensitive = True

but it didn’t help (same error).

What can I do to make DevForce understand that ‘a’ and ‘A’ are different entities?