I have a following tables/classes structure in Linq to entities.
Books
{
bookId,
Title
}
Tags
{
TagId
Tag
}
BooksTags
{
BookId
TagId
}
Now I need to write a query which gives me result like this
Class Result
{
bookId,
Title,
Tags
}
Tags should be comma separated text from the tags table by joining all three tables. How to get it done.
Thanks
Parminder