Customized Column Names in SQL for C#

See more:

C#

SQL-Server

SQL-Server-2008

have two tables, where I've abstracted the SQL column names. The first table has an "original" column name and a "header" name. The second table uses the "original" column name.

--Columns table
ColumnName HeaderName
StandardColumn_1 balance
StandardColumn_2 FName
StandardColumn_3 LName
StandardColumn_4 Age

--Records table
StandardColumn_1 StandardColumn_2 StandardColumn_3
Value1 Value2 Value3
Now, I have to write a query using the "header" name in C#. How can I query the records table using the "header" name?

e.g. string balance = "StandardColumn_1";, but I need to get the values dynamically from the columns table.