ef 4.1 LINQ filter an element into a collection

Question

I am using entity framework code first. I have a collection let's say:

 IDbSet<A> As {get;set;}

A is an object like this:

 public class A
 {
    public int Id {get;set;}
    public string name {get;set};
    ....
    public IList<B> Bs {get;set;}
 }

and B is:

 public clas B
 {
    public int Id {get;set;}
    public string name {get;set;}
 }

Using linq I want to filter the As which contains B.name == "something" in its IList so how to achieve this? I am trying to do something like:

context.As.Where(a => a.Bs.contains(....));

Answer 1

You can use Any()

context.As.Where(a => a.Bs.Any(b => b.name == "something").ToList();

It takes a predicate and returns upon a match making it efficient.

Answer 2

I would use the Any() method.

var result = context.As.Where(a => a.Bs.Any(b => b.Name == "something"));