Q:

Exclude a column from a select using LINQ

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?

A:

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.

A:

Specify each column that you do want in your select statement:
var users = from u in context.Users

        where u.UserId == userId

        select u.UserId, u.Watever, etc... ;

