Carrotware.CMS.DBUpdater.DatabaseUpdate.GetTableColumns C# (CSharp) Method

        public List<string> GetTableColumns(string testTableName)
        {
            List<string> lst = new List<string>();

            string testQuery = "select * from [INFORMATION_SCHEMA].[COLUMNS] where table_name = @TableName ";

            List<SqlParameter> parms = new List<SqlParameter>();

            SqlParameter parmKey = new SqlParameter();
            parmKey.ParameterName = "@TableName";
            parmKey.SqlDbType = SqlDbType.VarChar;
            parmKey.Size = 2000;
            parmKey.Direction = ParameterDirection.Input;
            parmKey.Value = testTableName;

            parms.Add(parmKey);

            DataTable table1 = GetTestData(testQuery, parms);

            if (table1.Rows.Count > 1) {
                lst = (from d in table1.AsEnumerable()
                       select d.Field<string>("column_name")).ToList();
            }

            return lst;
        }