This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, im new to LightSpeed and would like to see how to resolve my current issue. I have a table ApplicationUser and a related table ApplicationSession when I retrieve the ApplicationUser entity, is there a way I can return only the ApplicationSessions in the result.ApplicationSessions collection where the LogOutDate is null as part of the same query? currently I fetch the ApplicationUser like this result = (from u in uow.ApplicationUsers
where u.UserName.ToLower() == userName.ToLower()
&& u.Password.ToLower() == password.ToLower() Thank you in advance Mike. |
|
|
Yes it sounds like you want to add a join and filter on the ApplicationSessions and then select back just that entity from the resulting set. e.g. Try something like this:
This should return a list of all ApplicationSession instances where they are associated with a user with the supplied username and password and the logout date is null.
|
|
|
Jeremy, Thankyou for such a quick reply. Did the job, Cheers. Mike |
|