Eager loading with case insensitive

Hi,

I am using lightspeed (v. 5.0.2302.0) with sql server.

In my DB, I have a user table with varchar primary key called loginId. And another table called userinfo with varchar column loginId. There are no foreign key relationship.

Using C#, I am eager-loading UserInfo collection from User class

[EagerLoad(AggregateName = "UserInfos")] [ReverseAssociation("UserInfo")] private readonly EntityCollection _userInfos= new EntityCollection();

public EntityCollection Logins { get { return Get(_userInfos); } }

When I call User.Logins, it works sometime when the loginIDs are exactly the same. However, due to no foreign key constraints, the loginID in two table might be same value but not case-wise (ie, CORP\John.Doe vs CORP\john.doe)

My question is does lightspeed has a way to link these tables without foreign key forced that resolves this case-sensitve issue?

Thanks in advance.

Does your database collation support case sensitive comparison? LightSpeed will see these as two seperate identity values but it will also rely on your database comparisons being case sensitive for fetching related entities based on the identity value.

Jeremy