Print Page | Close Window

Case-Sensitivity problem with GetEntities

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=306
Printed Date: 30-Mar-2025 at 7:45pm


Topic: Case-Sensitivity problem with GetEntities
Posted By: Customer
Subject: Case-Sensitivity problem with GetEntities
Date Posted: 16-Jul-2007 at 3:43pm

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?



Replies:
Posted By: IdeaBlade
Date Posted: 16-Jul-2007 at 3:44pm
For the moment we are considering the problem you reported to us (Uniqueness constraint violation exception for characters of different case as primary keys when case-sensitivity set to true in DevForce) to be a bug.
 
We expect it will be fixed in our next release.


Print Page | Close Window