c# - Exclude a column from a select using LINQ

Question

I'm developing a WCF RESTful web service with Entity Framework Code First.

I have a table Users with a lot of columns. I do this to get an specific user:

context.Configuration.ProxyCreationEnabled = false;
var users = from u in context.Users
            where u.UserId == userId
            select u;

On this table, there is a password column, and I don't want return this column.

How can I exclude password column from that select?

Answer 1

Its sad to say but NO

You do not have option to directly exclude any particular column. You may go with lazy loading of columns.

The easiest and non-liking method would be to include columns which you want.