Searching in side an object's list of objects using lambda expressions?

Question

I have 2 tables; they have a many-to-many relationship. One is called Blog the other is Tag.

A Blog can contain a List of Tag objects. How can I go about getting all blogs that have a passed in tag name using lambda expressions?

Thanks!

Answer 1

Assuming the Tag table has a Name property, it might be something like this (roughly):

string tagName = "tag-to-search-for";
var query = Blog.Where(blog => blog.Tag.Any(tag => tag.Name == tagName));