LINQ to SQL Query

Question

I have got a query which returns True or False, depending on the criteria set in the query:

 bool eventVoucherUsed = getAllBookings.Any(r => r.EventID == booking.EventID && r.Voucher != null) ? true : false;

I want to modify the above query by adding one more check:

 booking.VoucherStatus == True

But I can't use the And operator three times. Is there any other alternative to achieve this?

Why can't you use && 3 times? Also, your ? true : false is pointless, any already returns true or false — Wolfwyrd
– Wolfwyrd, Commented Aug 15, 2011 at 13:20
Why can't you use the && operator three times? You might be able to do ".Where().Where().Where().Any()", but the two &&'s would be better. — Narnian
– Narnian, Commented Aug 15, 2011 at 13:21

jrummell · Accepted Answer · 2011-08-15 13:20:23Z

1

I'm not sure what you mean by "cant use And operator three times". All that you need to do is add the condition to your predicate.

bool eventVoucherUsed = 
     getAllBookings.Any(r => r.EventID == booking.EventID 
                   && r.Voucher != null 
                   && booking.VoucherStatus == true);

answered Aug 15, 2011 at 13:20

jrummell

43.2k18 gold badges116 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alun · Accepted Answer · 2011-08-15 13:26:01Z

1

Well if your example is accurate booking is something you already know so I can't see any reason too not just check that before even hitting the database:

bool eventVoucherUsed = 
  booking.VoucherStatus 
  ? getAllBookings.Any(r => r.EventID == booking.EventID && r.Voucher != null)
  : false;

answered Aug 15, 2011 at 13:26

alun

3,46123 silver badges26 bronze badges

Collectives™ on Stack Overflow

LINQ to SQL Query

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related