title: Select specific properties from include ones in entity framework core
body: <p>I use Entity Framework Core 2.0 and have this 2 classes:</p>
  
  <p>News</p>
  
  
  
  <pre class="lang-cs prettyprint-override"><code>public class News
  {
      public int Id { get; set; }
      public string Title{ get; set; }
      public string Text { get; set; }
      public DateTime ReleaseDate{ get; set; }
      public int AuthorID{ get; set; }
      public Author Author{ get; set; }
  }
  </code></pre>
  
  <p>Author</p>
  
  <pre class="lang-cs prettyprint-override"><code>public class Author 
  {
      public Author ()
      {
       News = new List&lt;News&gt;();
      }
  
      public int Id { get; set; }
      public string Username{ get; set; }
      public string Firstname{ get; set; }
      public string Lastname{ get; set; }
      public ICollection&lt;News&gt; News {get;set;}
  }
  </code></pre>
  
  <p>I want to load the news with the author's username only because I don't need the other information like author's first and lastname.</p>
  
  <p>If I execute this:</p>
  
  <pre class="lang-cs prettyprint-override"><code>static void Main(string[] args)
  {
    using (var ctx = new DbContext())
    {
     var result= ctx.News.Include(x =&gt; x.Author).Select(news =&gt; new
     {
       news= news ,
       Username= pr.Author.Username
     }).ToList();
    }
  }
  </code></pre>
  
  <p>Entity Framework Core 2.0 generates a database query like:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT [x].[ID], [x].[Text], [x].[Title], [x].[AuthorId], [x].[ReleaseDate], [x.Author].[ID], [x.Verfasser].[Username] AS [Username], [x.Verfasser].[Firstname], [x.Verfasser].[Lastname]
  FROM [News] AS [x]
  INNER JOIN [Author] AS [x.Author] ON [x].[AuthorId] = [x.Author].[ID]
  </code></pre>
  
  <p>Is there a way to achieve my expected behaviour?</p>