Print Page | Close Window

Linq FirstOrNullEntity Bug?

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2009
Forum Discription: For .NET 3.5
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1260
Printed Date: 04-Apr-2025 at 3:28am


Topic: Linq FirstOrNullEntity Bug?
Posted By: francois
Subject: Linq FirstOrNullEntity Bug?
Date 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


Replies:
Posted By: kimj
Date Posted: 14-May-2009 at 6:59pm

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


Print Page | Close Window