title: Displaying column name of each table in a specific SQL Server database in MVC C#
body: <p>I've been trying everything to solve this problem, but couldn't get to a solution. This is my first time using MVC.
  I have already the query in SQL Server that shows a list of table names and column names of a specific database. This is the query:</p>
  
  <pre><code>SELECT t.name AS table_name,
  c.name AS column_name
  FROM sys.tables AS t
  INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
  ORDER BY table_name
  </code></pre>
  
  <p>Is there a way to execute this query in MVC and show the results in the html table?</p>