Query Entity Framework object and child object with single query

Question

I have two Entity Framework objects with a one-to-many relationship:

widget(parent) and widgetNail(child)

Widget has a text column: Title WidgetNail has a text column: Description

I would like to build a query that will return a list of Widgets that match one of two criteria:

A text string is found in the Widget title, or
The same text string is found in any WidgetNail description.

So far I have this, which doesn't work...

from widget in entities.Widgets
from widgetNail in entities.WidgetNails
where widget.Title.Contains(searchText)
|| widgetNail.Description.Contains(searchText)
select widget).ToList();

Yakimych · Accepted Answer · 2010-10-06 20:00:05Z

2

Regarding

2.The same text string is found in any WidgetNail description.

You mean among the current Widget's children?

(from widget in entities.Widgets
where widget.Title.Contains(searchText) || widget.WidgetNails.Any(wn => wn.Description.Contains(searchText))
select widget).ToList();

or fluent syntax:

entities.Widgets.
         Where(w => w.Title.Contains(searchText) ||
                    w.WidgetNails.Any(wn => wn.Description.Contains(searchText))).
         ToList();

answered Oct 6, 2010 at 20:00

Yakimych

17.8k7 gold badges55 silver badges70 bronze badges

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

Collectives™ on Stack Overflow

Query Entity Framework object and child object with single query

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