Query to get all coumn names from database using entityframewok in ASP.NET mvc5

See more:

ASP.NET

SQL

C#5.0

MVC5

, +

i want to get all column names in listbox from database based on table name selection in dropdownlist using asp.net mvc5

What I have tried:

public List<string> GetTableNames()
     {
         using (var Context = new MCPEntities())
         {
             FieldInfo[] mytables = Context.GetType().GetFields(BindingFlags.Public | BindingFlags.NonPublic | BindingFlags.Instance);
             List<string> tbllistname = new List<string>();
             foreach (var item in mytables)
             {
                 tbllistname.Add(item.Name.Split('<', '>')[1]);
             }
             return tbllistname;
           }
      }