<#@ assembly name="System.Core" #>
<#@ assembly name="System.Data" #>
<#@ import namespace="System.Data.SqlClient" #>
<#+
string constr = "Data Source=127.0.0.1;Initial Catalog=Workers;User ID=sa;Password=li123";
string getTableSummery(string tablename)
        {
            using (SqlConnection conn = new SqlConnection(constr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = @"SELECT   value
FROM   ::fn_listextendedproperty (NULL, ‘user‘, ‘dbo‘, ‘table‘, ‘"+ tablename+"‘, default, default)";
                    var res = cmd.ExecuteScalar();
                    if (res == null)
                    {
                        return string.Empty;
                    }
                    else
                    {
                        return res.ToString();
                    }
                }
            }
        }
        string getColumnSummery(string tablename, string columnname)
        {
            using (SqlConnection conn = new SqlConnection(constr))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = @"SELECT   value
FROM   ::fn_listextendedproperty (NULL, ‘user‘, ‘dbo‘, ‘table‘, ‘" + tablename + "‘, ‘column‘, default)  where objname=‘"+ columnname + "‘ ";
                    var res = cmd.ExecuteScalar();
                    if (res == null)
                    {
                        return string.Empty;
                    }
                    else
                    {
                        return res.ToString();
                    }
                }
            }
        }
#>