Exclude a column from a select using LINQ

c# entity-framework linq sql

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?

1
11
10/19/2013 6:23:33 AM

Accepted Answer

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... ;
2
4/18/2015 6:00:29 PM

Popular Answer

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.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow