load partial entityset ef4

Question

Can I load only a few properties from an Entity?

As an example I have an entity with the following properties:

ID
DESCRIPTION
HEADER
PICTURE

I only want to load the IDs and not the other properties.

How can I do this?

Please never post in ALL CAPS. It's like shouting. – Mat Mar 15 '11 at 12:30 — Mat, Mar 15 '11 at 12:30
sorry, didnt notice the caps lock was on – maggie Mar 15 '11 at 13:35 — maggie, Mar 15 '11 at 13:35

score 4 · Accepted Answer · answered Mar 15 '11 at 13:01

In your case if you just need the IDs, you can use the following query:

var ids = context.YourEntities.Select(e => e.ID).ToList();

You can also use projection (useful if you need to load more than one property):

var entitiesWithIdsAndHeaders = context.
                                YourEntities.
                                Select(e => new
                                            {
                                                Id = e.ID,
                                                Description = e.Description
                                            }).
                                ToList();

Or load it to a POCO class instead of an anonymous. – Shimmy Weitzhandler May 16 '11 at 01:33 — Shimmy Weitzhandler, May 16 '11 at 01:33

load partial entityset ef4

1 Answers1

Linked