question

Aaronsoggi-6095 avatar image
0 Votes"
Aaronsoggi-6095 asked JackJJun-MSFT commented

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

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


sql-server-generaldotnet-csharp
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Aaronsoggi-6095, is any update? Please check if the following answer works for you.

0 Votes 0 ·

1 Answer

Viorel-1 avatar image
1 Vote"
Viorel-1 answered

Try this:

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.