title: creating new object in select based on linked table in linq
body: <p>I have a table that has a FK to another table. I'm using a "view model" class that I want to return instead of the actual EF class. I know I can join the 2 tables and filter on the first table and then make a new view model in the select part based on the fields that I want, but can I do this without the join and instead use the linked table (via FK) in the select to create the view model instance?</p>
  
  <p>ie. this works:</p>
  
  <pre><code>return (from a in context.Articles
                      join t in context.Topics on a.TopicID equals t.Id
                      where t.Name == topic
                      select new ArticleViewModel { Title = a.Title, Introduction = a.Introduction, Content = a.Content }).ToList();
  </code></pre>
  
  <p>Can I somehow create my ArticleViewModel with the Topics.Article link in a short and clean fashion:</p>
  
  <pre><code>return (from t in context.Topics
                      where t.Name == topic
                      select /*how can I create ArticleViewModel from t.Articles?*/ t.Articles).ToList();
  </code></pre>