asp net core Entity Framework inefficient query

ASP.NET MVC, ASP.NET Web API, and ASP.NET Web Pages have merged into a unified MVC 6. The ASP.NET …