Optional Entity Framework include

Question

I have a great deal of doubt here about Include of the Entity Framework.

var ocorrencias = db.Ocorrencia
       .Include("Pessoa")
       .Where(c => c.Id > 1000).ToList();

I used the Include, because I need the object Ocorrencias with the property Pessoa completed (if there is person), if there is no person, the business rule will treat.

My query should return 12 records. However, when I use the Include the return of the query are six records, (only the records containing the property Pessoa).

How do I make the Include do the job of filling the property only if it exists while maintaining my correct return?

Follows the model:

public partial class Ocorrencia
{
    [Key]
    public int id { get; set; }
    public Pessoa Pessoa { get; set; }
    public int PessoaId { get; set; }
}



public class Pessoa
    {
        [Key]
        public int id { get; set; }
        [Display(Name = "Nome"), Required(ErrorMessage = "Nome da Pessoa")]
        public string nome { get; set; }
        [Display(Name = "E-mail")]
        public string email { get; set; }
        [Display(Name = "CPF")]
        public string cpf { get; set; }
    }

Answer 1

Actually, it is not an optional Include. It is a null accepting property.

The mistake was in Model, because it did not allow null, so the query was being created with the InnerJoin and not LeftJoin.

In this way, the Include treated correctly, and after changing the Model to allow null, the return was correct.

Follow the model with correction.

public partial class Ocorrencia
{
    [Key]
    public int id { get; set; }
    public Pessoa Pessoa { get; set; }
    public int? PessoaId { get; set; }
}