Entity framework - select nullable join property

Question

My table structure looks like :

Account
 AccountId
 LoginName
 EmployeeId - nullable
Employee
  FirstName,
  SecondName,
  etc..

I have query :

   var data = from o in _accountRepository.AsQueryableWithIncludes(x => x.Employee, x => x.Permissions)
               select new AccountGridVM
               {
                   AccountId = o.AccountId,
                   EmployeeFirstName = o.EmployeeId == null ? String.Empty: o.Employee.FirstName,
                   LoginName = o.LoginName,
                   Permissions = o.Permissions.Select(s => s.NameCZ)
               };
    return View(new GridModel { Data = data });

My problem is in tenar operator in EmployeeFirstName, entity framework always fetch only accounts, which has employeeId assign, but i need fetch all accounts.

If i remove EmployeeFirstName propeprty, ef fetch all rows.

Where is problem?

Thanks

Did you try `o.Employee == null` instead of `o.EmployeeId == null`? — Markus Jarderot, Mar 28 '12 at 10:21
Yes, try o.EmployeeId.HasValue, o.Employee == null, o.EmployeeId = null — Mennion, Mar 28 '12 at 10:22

score 1 · Accepted Answer · answered Mar 28 '12 at 11:47

1

Problem solved. I had mistake in mapping.

  //bad
  HasRequired(x => x.Employee).WithMany().HasForeignKey(x => x.EmployeeId); // inner join

  //good
  HasOptional(x => x.Employee).WithMany().HasForeignKey(x => x.EmployeeId); // left join

answered Mar 28 '12 at 11:47

Mennion

2,873
3
20
34

Entity framework - select nullable join property

1 Answers1