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?
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... ;
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.