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 Am getting: This expression type is not supported in lightspeed 3.0 var tagsNotAssignedToAnyEvent = from rfidtag in uow.RfidTags
where !(from competitor in uow.Competitors where competitor.RfidTagUId != null select new { competitor.RfidTagUId }).Contains(new { RfidTagUId = (System.Guid?)rfidtag.Id }) select new { rfidtag.Id };
this linq came from linqer.. the sql I'm trying to run is:
select RFIDTagUID from rfidtag where RFIDTagUID not in (select RFIDTagUID from competitor where RFIDTagUID is not null)
where 1 rfidtag can have many competitors. Regards Dave |
|
|
|
|
Hi Guys.. I found another way of getting my data.. so this question isn't high priority at all :-) |
|
|
|
