title: Error: The entity or complex type cannot be constructed in a LINQ to Entities query
body: <p>I have a problem with join query with MVC and i dont know why.</p>
  
  <blockquote>
    <p>The entity or complex type 'Tusofona_Website.Models.site_noticias' cannot be constructed in a LINQ to Entities query.</p>
  </blockquote>
  
  <p>My Controller:        </p>
  
  <pre><code>    private TusofonaDBs db = new TusofonaDBs();
  
      //
      // GET: /DestaquesMain/
  
      public ActionResult Index()
      {
          var query = (from sd in db.site_desquesnoticias
                      join sn in db.site_noticias on sd.IDNoticia equals sn.IDNoticia
                      where sn.Destaque == 1
                      select new site_noticias {
                          CorpoNoticia = sn.CorpoNoticia,
                          TituloNoticia = sn.TituloNoticia
                      }).ToList();
  
          //return View(db.site_desquesnoticias.ToList());
            return View(query);
  
      }
  </code></pre>
  
  <p>My Model:</p>
  
  <pre><code>public class site_destaquesnoticias
  {
      [Key]
      public Int32 IDDestaque { get; set; }
      public Int32 IDNoticia { get; set; }
      public string Foto { get; set; }
  
  
  }
  
  public class site_noticias
  {
      [Key]
      public Int32 IDNoticia { get; set; }
      public string CorpoNoticia { get; set; }
      public string TituloNoticia { get; set; }
      public string Foto { get; set; }
      public Int32 Destaque { get; set; }
  }
  
  public class TusofonaDBs : DbContext
  {
      public DbSet&lt;site_destaquesnoticias&gt; site_desquesnoticias { get; set; }
      public DbSet&lt;site_noticias&gt; site_noticias { get; set; }
  }
  </code></pre>
  
  <p>Anyone can help me?</p>