LINQ - How to write a query to set a variable bool True or False

Question

I use asp.net 4 linq and EF4.

I have this query where CmsSourcesContents is a navigational property.

At he moment when I run the query the result for queryCheck is a type IQuerable.

I need to valuate the condition express in my Linq query but as a result I would like a Type Bool like:

bool queryCheck

Any idea how to make it? Thanks!

---

  var queryCheck = from cnt in context.CmsContents
                   where cnt.ContentId == myContentIdSelected && cnt.CmsSourcesContents.Any()
                   select cnt;

---

This query should look for a specific cnt and check if it has any association.. and give me the result as bool.

Answer 1

bool queryCheck = (from cnt in context.CmsContents
                  where cnt.ContentId == myContentIdSelected && cnt.CmsSourcesContents.Any()
                  select cnt).Any();

Answer 2

You can use Any() again on the total query to see if there are any matches:

var queryCheck = (from cnt in context.CmsContents
               where cnt.ContentId == myContentIdSelected && cnt.CmsSourcesContents.Any()
               select cnt).Any();