Entity Framework Database First only use certain columns

Question

We are currently working on a application which uses entity framework 6, database first approach. There are a few tables we need to pull in, joining them, but they have many columns which we do not want to pull in. I can delete the columns in the edmx but then they regenerate whenever we update the edmx, is there anyway to avoid this?

Another link you might find helpful in your situation is table splitting as explained here: msdn.microsoft.com/en-us/data/jj715645.aspx and also in this video: youtube.com/watch?v=hVxvrjoIPRk — Sunil
– Sunil, Commented Jan 21, 2016 at 20:59

Rahul · Accepted Answer · 2016-01-21 20:34:54Z

2

Well, let it pull all the columns. Still you can select only few columns or the columns you need while displaying or passing as model using a LINQ query Select() method and project to a anonymous type.

Other than that, DB First model UI also gives you facility to import Views and stored procedure. That means, whichever customized data you want you can pull the required SQL to a create view ... statement or create procedure... statement and have it imported using Entity Framework.

edited Jan 21, 2016 at 20:34

answered Jan 21, 2016 at 20:29

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sam Over a year ago

I agree. Either create a static typed model to project onto, or project onto an anonymous type using the Select method

Collectives™ on Stack Overflow

Entity Framework Database First only use certain columns

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related