How to use C# to get column's description of Sql Server 2005?

Question

I can use " Microsoft.SqlServer.Management.Smo.Table " in C# to get a table columns of a Sql Server 2005 database.

I have got the column.Name, but how can I get the column's Description in C#?

I have saw the link: http://stackoverflow.com/questions/887370/sql-server-extract-table-meta-data-description-fields-and-their-data-types

But how can I use C# "Microsoft.SqlServer.Management.Smo" dll to get a column's Description?

Answer 1

Why don't you use the result from the query described in the link you gave?

Answer 2

Say your Smo.Table object is named t.

This will get the description:

t.Columns["ProductID"].ExtendedProperties["MS_Description"].Value