Entity Framework Search On Entity Property and Entity ICollection

Question

I'm using entity framework 6 with C#.

My tables are like;

public class Product
{
    public Product()
    {
        ProductInfos = new List<ProductInfo>();
    }

    ...

    public string Name { get; set; }

    public virtual ICollection<ProductInfo> ProductInfos { get; set; }
}

public class ProductInfo
{
    ...

    public long ProductId { get; set; }

    public string Name { get; set; }
}

I want to search text in Product.Name and Product.ProductInfos -> Name.
Like;


                    queryable = queryable.Where(x => x.Name.Contains(searchtext))
                                         .Where(p => p.ProductInfos.Where(p => p.Name.Contains(searchtext)));

However as you can see my brain has been stopped :)
How can query a class's property and child classes properties ?

P.s. This is not big tables, don't worry about performance errors. I have only 50 products.

What is the error? What is the result? Did you test your query? — CodeNotFound
– CodeNotFound, Commented Feb 23, 2017 at 6:14

Teppic · Accepted Answer · 2017-02-23 06:25:00Z

1

queryable = queryable.Where(x => x.Name.Contains(searchtext) || 
                                 x.ProductInfos.Any(y => y.Name.Contains(Seachtext));

answered Feb 23, 2017 at 6:25

Teppic

2,55620 silver badges26 bronze badges

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

1 Comment

Nahuel Ianni Over a year ago

While this code snippet may solve the question, including an explanation really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion.

Collectives™ on Stack Overflow

Entity Framework Search On Entity Property and Entity ICollection

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related