I'm having difficulty accessing Table extended properties in SQL server.
My script is C#.
I'm using the following code snippet I found on a post last year.
- Code: Select all
MyMeta.Single single = MyMeta.Databases.Tables as MyMeta.Single;
KeyValueCollection extendedProperties = single.DatabaseSpecificMetaData(\"ExtendedProperties\") as KeyValueCollection;
The KeyValueCollection is not null but it is always empty.
The connection string is of the form:
Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBName;Data Source=ServerName
The DB Target is SqlClient
The Driver is Microsoft SQL Server
What am I missing? Is there something special in the connection string I need or has the syntax changed for this? I'm running version 184.108.40.206 of the generator MyMeta 220.127.116.11