Linq to sql -get data from table related to another

Question

Im using linq for sql

I have a table of documents

and FavoriteDocuments table

The FavoriteDocuments table has documentID fk and ProjectID fk.

given ProjectID, how can I get all the documents (from the document table) that are FavoriteDocument for this particular project.

thank

Answer 1

Try the following:

public static Document[] GetFavouriteDocumentsForProject(int projectId)
{
    using (var db = new MyContext())
    {
        return
            (from favourite in db.FavouriteDocuments
            where favourite.ProjectID == projectId
            select favourite.Document).ToArray();
    }
}

Hope this helps.