Creating LINQ query with two parameters

Question

I am new to LINQ and I feel some difficulties to write that LINQ query.

I need to write LINQ TO ENTITY to check if table named Reviews where all rows with siteId=5 has at least one row with column named isValid that equal false if there is, I need to return false if not return true.

Give it a try at-least. Hint: Use Any.

Rahul Singh
– Rahul Singh

2015-11-02 10:56:31 +00:00
Commented Nov 2, 2015 at 10:56 — Rahul Singh
– Rahul Singh, Commented Nov 2, 2015 at 10:56

Mrinal Kamboj · Accepted Answer · 2015-11-02 11:13:20Z

1

Create a Filter with SiteId

IEnumerable<Review> FilteredReviews = Reviews.Where(x=>x.SiteId == 5)

Check whether any value of IsValid is False, return accordingly

return FilteredReviews.Any(y=>!y.IsValid) ? false : true

edited Nov 2, 2015 at 11:13

answered Nov 2, 2015 at 11:06

Mrinal Kamboj

11.6k5 gold badges45 silver badges82 bronze badges

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

Collectives™ on Stack Overflow

Creating LINQ query with two parameters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related