DevForce Community Forum : Linq FirstOrNullEntity Bug? http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Linq FirstOrNullEntity Bug? Sat, 11 Apr 2026 20:52:32 -700 Thu, 14 May 2009 18:59:33 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1260 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Linq FirstOrNullEntity Bug? : If the collation defined for the... http://www.ideablade.com/forum/forum_posts.asp?TID=1260&PID=4540#4540 Author: kimj
Subject: 1260
Posted: 14-May-2009 at 6:59pm

If the collation defined for the database specifies case sensitivity then that could be causing this error.

]]> Thu, 14 May 2009 18:59:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1260&PID=4540#4540 Linq FirstOrNullEntity Bug? : Hi, I think there is maybe... http://www.ideablade.com/forum/forum_posts.asp?TID=1260&PID=4537#4537 Author: francois
Subject: 1260
Posted: 14-May-2009 at 1:16pm

Hi,
 
I think there is maybe a bug when I query Guids. I have entities with Guids as primary keys.
When I do a FirstOrNullEntity on data in the cache it works fine. But when I do it with data in the SQL Compact DB it fails.
 
e.g.
EntityManager.Employees.FirstOrNullEntity(e => E.ID == testID).
 
I suspect it has to do with the fact that guids are stored in upper case in SQL and lower case in .Net. Could it be possible that it does not match correctly translating to SQL?
 
Thanks,
Francois
]]> Thu, 14 May 2009 13:16:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1260&PID=4537#4537