linq-to-entities

Problem returning Entity models: "the entity or complex type ... cannot be constructed in a LINQ to Entities query"

I am trying to return a list of the objects generated by Entity Framework DataBase first but I get this error: The entit ... ength(100)] public string nome { get; set; } public virtual ICollection<TB_LEMBRETES> TB_LEMBRETES { get; set; } }

Are there any differences between first and Single? [duplicate]

this question already has an answer here : ... two queries equal? And in terms of performance between the two is the same? Which of the two expressions is better to use?

Left Join with LINQ

I have two tables that comes from different repositories. One comes from an API and I have one that comes from the BD. I al ... from m in tmpMapp.DefaultIfEmpty() select a; In SQL would be SELECT a LEFT JOIN b on a.Codigo = b.Codigo