DevForce Community Forum : Case-Sensitivity problem with GetEntities http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Case-Sensitivity problem with GetEntities Mon, 13 Apr 2026 10:51:51 -700 Mon, 16 Jul 2007 15:44:17 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=306 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Case-Sensitivity problem with GetEntities : For the moment we are considering... http://www.ideablade.com/forum/forum_posts.asp?TID=306&PID=693#693 Author: IdeaBlade
Subject: 306
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.
]]> Mon, 16 Jul 2007 15:44:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=306&PID=693#693 Case-Sensitivity problem with GetEntities : Our database is case-sensitive.... http://www.ideablade.com/forum/forum_posts.asp?TID=306&PID=692#692 Author: Customer
Subject: 306
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?

]]> Mon, 16 Jul 2007 15:43:25 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=306&PID=692#692