Can someone tell me how i would check if the current value is less than the stored value in this where claus?

Question

code:

var stats = context.StatQueue.Where(x => x.QueueId == queueId && x.StartDateTime == startDateTime).ToList();

what I need to do is check if the current value of "MinLoggedIn" (x.MinLoggedIn) is less than stored value.

Can anyone help with this?

Thanks

Answer 1

Try this:

var stats = context.StatQueue.Where(x => x.QueueId == queueId && x.StartDateTime == startDateTime && x.MinLoggedIn < storedValue).ToList();