How to get column names by passing table name in MVC

Question

1.00/5 (2 votes)

See more:

Hi all,
I want to display column names by passing table name in mvc using entity framework.
and by using below query getting column names for single table(Administrator) only.
How to pass tablename dynamically in entity framework.
please give me solution regarding this.

What I have tried:

public List<string> GetColumnNames(string tablename)
        {
            using (var Context = new MCPEntities())
            {
                var names = typeof(Administrator).GetProperties().Select(property => property.Name).ToArray();
                return names.ToList();              
            }

Posted 1-Jun-17 20:51pm

VenkataSeshu B

Updated 9-Jun-17 19:54pm

v5

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Answer 1 · 2017-06-01T22:17:00

Use a raw SQL query to get the column names

Entity Framework Raw SQL Queries[^]

How can I get column names from a table in SQL Server? - Stack Overflow[^]

In Entity Frame there doesn't have to be a one to one mapping between EF entities and table names so querying the names of entities doesn't necessarily get you the table names, nor will it get the raw ones.

cjmakwana · Answer 2 · 2017-06-09T19:48:00

I agree with F-ES Sitecore, that there can be impedance between table entity properties and actual table fields. It is up to you on what you exactly want to display. If you want to display the actual database table fields, then use the solution what is suggested by F-ES Sitecore. But in general, table field name conventions follow a typical pattern based on the organization's policies, and typically are not supposed to display in UI as is, but with more descriptive text. In that way, your approach can be sufficient.

How to get column names by passing table name in MVC

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0