Retrieving SQL Server Extended Properties From C#

Question

We document our SQL Server database by creating table and column level Description extended properties. We usually enter these via SSMS.

My question is this. I'm creating a C# application where I'd like to read the extended properties for a particular table and its associated columns.

Can someone show me how I might go about doing this?

Thanks - Randy

Answer 1

You simply ask for them using the built-in fn_listextendedproperty. The result of this function is an ordinary table result set that you read in C# using your data access tool of choice (SqlCommand/SqlDataReader, linq, datasets etc).