How to select an entity from database based on nested list item match?

Question

I have a DbSet that contains a list of Item, Now I want to search an Item from the database based on its nested list item matching.

Item Model

public int ItemID{ get; set; }
public string Cover { get; set; }
public List<SlideModel> Slides { get; set; }

Slide Model

public int SlideID{ get; set; }
public int ItemID{ get; set; }
public string Slide{ get; set; }

Now I will pass a search string of Slide and it will search for the Item who have the Slide in its List<SlideModel> and return the Item

item = await context.Items
    .Include(i => i.Slides)
    .Where(...todo-maybe...)
    .FirstOrDefaultAsync();

How should I write the Query method to get the item based on the slide

based on its nested list item matching -- Please elaborate. An example of what you want would help. — Gert Arnold
– Gert Arnold, Commented Sep 9, 2018 at 9:20
@Gert Arnold, Please see the edited question, I just want to select an item that contain the slide in its SlideList. — Sabir Hossain
– Sabir Hossain, Commented Sep 9, 2018 at 9:29

Tomato32 · Accepted Answer · 2018-09-09 17:32:35Z

1

That's the thing that you want? Hope to help, my friend :))

string inputSlide = "abc";

item = await context.Items
    .Include(i => i.Slides)
    .Where(i => i.Slides.Any(i => i.Slide.ToLower() == inputSlide.ToLower()))
    .FirstOrDefaultAsync();

edited Sep 9, 2018 at 17:32

answered Sep 9, 2018 at 9:57

Tomato32

2,2531 gold badge12 silver badges11 bronze badges

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

2 Comments

Sabir Hossain Over a year ago

really helped, Thank you.

Tomato32 Over a year ago

@SabirHossain: Well played, my friend :))

Collectives™ on Stack Overflow

How to select an entity from database based on nested list item match?

Item Model

Slide Model

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Item Model

Slide Model

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related