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.Prox

Solution 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.

Solution 2:

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

Solution 3:

You can create more than one LINQ object per table. I'd create one with the field you need and one without. It makes CRUD operations more difficult though.