Get column by table name entity framework reflection

Question

I need to get column name and value from a table which I know only the name. I try lot of stuff but without success.

I use this for get my table :

var table = oSession.ctx.GetType()
                       .GetProperty("country")
                       .GetValue(oSession.ctx, null);

I'm lock with that I can't retrieve the informations of my columns .. Perhaps I have already try this :

List<string> columnsNames = table.GetType().GetFields().Select(field => field.Name).ToList();

Thx for your help..

Community · Accepted Answer · 2017-05-23 12:23:53Z

2

Use ((IQueryable)table).ElementType.GetProperties() as a starting point. Also you can get some ideas from Dynamic LINQ query to get Field value from Database

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Sep 3, 2015 at 17:31

Ivan Stoev

208k17 gold badges356 silver badges376 bronze badges

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

Comments

gamepop · Accepted Answer · 2015-09-03 17:12:33Z

0

you can probably try using GetProperties() table.GetType().GetProperties().Where(p => !(p.GetMethod.IsVirtual || p.GetIndexParameters().Length > 0)).ToList()

answered Sep 3, 2015 at 17:12

gamepop

4342 silver badges13 bronze badges

Collectives™ on Stack Overflow

Get column by table name entity framework reflection

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related