title: Invalid column name in EF
body: <p>I have a situation where EF is trying to get a field value from the table "VideoClip" that I didn't ask it to get.</p>
  
  <p><img src="https://i.stack.imgur.com/sB4pm.jpg" alt="Database schema showing the tables NewsItemVideoClip, NewsItem, VideoClip and Video"></p>
  
  <p>The complete generated query looks like this:</p>
  
  <pre><code>SELECT 
  [Project1].[Id] AS [Id], 
  [Project1].[NewsItemId] AS [NewsItemId], 
  [Project1].[VideoClipId] AS [VideoClipId], 
  [Project1].[DisplayOrder] AS [DisplayOrder], 
  [Project1].[Video_Id] AS [Video_Id]
  FROM ( SELECT 
      [Extent1].[Id] AS [Id], 
      [Extent1].[NewsItemId] AS [NewsItemId], 
      [Extent1].[VideoClipId] AS [VideoClipId], 
      [Extent1].[DisplayOrder] AS [DisplayOrder], 
      [Extent1].[Video_Id] AS [Video_Id]
      FROM [dbo].[NewsItemVideoClip] AS [Extent1]
      WHERE [Extent1].[NewsItemId] = @p__linq__0
  )  AS [Project1]
  ORDER BY [Project1].[DisplayOrder] DESC
  </code></pre>
  
  <p>However, my <code>NewsItemVideoClip</code> entity class looks like this:</p>
  
  <pre><code>public class NewsItemVideoClip : Entity
  {
      public virtual int NewsItemId { get; set; }
      public virtual int VideoClipId { get; set; }
      public virtual int DisplayOrder { get; set; }
      public virtual NewsItem NewsItem { get; set; }
      public virtual VideoClip VideoClip { get; set; }
  }
  </code></pre>
  
  <p>The mapping:</p>
  
  <pre><code>public class NewsItemVideoClipEntityMapping
      : EntityTypeConfiguration&lt;NewsItemVideoClip&gt;
  {
      public NewsItemVideoClipEntityMapping()
      {
          //configure key and properties
          HasKey(c =&gt; c.Id);
  
          this.HasRequired(x =&gt; x.NewsItem)
              .WithMany(x =&gt; x.NewsItemVideoClips)
              .HasForeignKey(x =&gt; x.NewsItemId);
  
          this.HasRequired(x =&gt; x.VideoClip)
              .WithMany(x =&gt; x.NewsItemVideos)
              .HasForeignKey(x =&gt; x.VideoClipId);
  
          //configure table map
          ToTable("NewsItemVideoClip");
      }
  }
  </code></pre>
  
  <p>The LINQ query:</p>
  
  <pre><code>public IList&lt;NewsItemVideoClip&gt; GetVideoClips(int newsItemId)
  {
      var query = from nvc in _newsItemVideoClipRepository.GetAll()
                  where nvc.NewsItemId == newsItemId
                  orderby nvc.DisplayOrder descending
                  select nvc;
  
      var newsItemVideoClips = query.ToList();
      return newsItemVideoClips;
  }
  </code></pre>
  
  <p>Howcome EF gives me: <code>Invalid column name 'Video_Id'</code>?</p>