获取Sql数据库表全部列名

 private IEnumerable<string> GetAllColumns()
        {
            var sql =
                string.Format(@" SELECT c.name AS ColumnName,t.name AS ColumnType,c.max_length,c.is_nullable,c.is_identity ,p.value AS ColumnDescription
FROM sys.columns c LEFT JOIN sys.types t ON c.user_type_id=t.user_type_id
LEFT JOIN sys.extended_properties p ON p.major_id=c.object_id AND p.minor_id=c.column_id AND p.name='MS_Description'
WHERE OBJECT_ID=( SELECT OBJECT_ID FROM sys.tables ts
LEFT JOIN sys.schemas sc ON sc.schema_id=ts.schema_id
 WHERE ts.name='{0}' AND sc.name='{1}')", _tableName, _tableSchemaName);
            var datatable = GetTableBySql(sql);
            return datatable.Rows.OfType<DataRow>().Select(row => row["ColumnName"].ToString());
        }