Entity Framework Core - Knowledge Base (KB)

OUTER JOIN not returning expected results in EF Core

In my ASP.NET MVC Core app the ...POST... action method ...Test... is not returning the expected results. The web app was created using ...this official ASP.NET Core site... and was modified slightly. The real app can be ...downloaded from here... and is ...

How to force outer join with .Include query Entity Framework 6

My data model is below. ...UserPhone... is required but navigation property is optional as long as ...User...'s table could be empty:...public class Request { [Key] public int Id {get;set;} [Required] public string UserPhone {get;set;} ...