Retrieve table columns via table names in Entity Framework

Question

How do i retrieve a list of table columns in the database via table name in Entity Framework Database First?

Stefan Taseski · Accepted Answer · 2018-12-07 09:00:25Z

3

If you need to get the names of the columns in C# code, then it would be something like this:

var names = typeof(TableName).GetProperties()
                    .Select(property => property.Name)
                    .ToArray();

If you need the columns names in the database via query then something like this:

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'TableName'

answered Dec 7, 2018 at 9:00

Stefan Taseski

2326 silver badges25 bronze badges

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

1 Comment

I prefer ToList() instead of ToArray(), but that is a totally valid answer anyways.