Linq. Filter Records

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • shapper

    Linq. Filter Records

    Hello,

    I have the following Linq query:

    viewData.PostsP apers = (from p in
    database.Posts
    select new PostPaper {
    Post = p,
    Tags = string.Join(", ",
    (from pt in database.PostsT ags

    join t in database.Tags on pt.TagID equals t.TagID

    where pt.PostID == p.PostID

    select t.Name).ToArray ())
    }).ToList();

    I need to get only the records that are associated to a Tag, given the
    TagID or Tag Name.

    I would like to know how to do this using TagID or using the Tag Name.

    Could someone help me out?

    Thank You,
    Miguel
Working...