I'm maintaining an ASP.NET WebAPI2 application with Entity framework 6 and MSSQL server database. The IoC container is Castle Windsor. I have a method on my repository that I use to get some details for a user from DB. Since I don't need every column, I thought I'd use projection. The problem is that the generated SQL selects ALL the columns in my table. Here's the DbContextI'm maintaining an ASP.NET WebAPI2 application