Getting advanced SQL Server properties from C #

Question

We document our SQL Server database by creating a table and column level. Description of advanced properties. Usually we enter them through SSMS.

My question is that. I am creating a C # application where I would like to read advanced properties for a specific table and its associated columns.

Can someone show me how I can do this?

Thanks - Randy

Answer 1

Read the following: Retrieve advanced SQL column properties from LINQ in C # and see what you can do in your situation.

Answer 2

fn_listextendedproperty. , #, (SqlCommand/SqlDataReader, linq, ..).