DataColumn .Unique property not being set
I am creating a dataset from a SQL Server database. The underlying table has a unique constraint on one of the columns, but this is not being reflected in the .Unique property of the appropriate DataColumn. Is there any way I can get this property to update automatically.
For example, the Field Length and Allow Nulls properties do net get written to the dataset unless you set da.MissingSchemaAction = MissingSchemaAction.AddWithKey
Is there something else I can set to add the .Unique property? I know this can be set manually but I need a generic solution as I will not always know which database fields have unique constraints.
Thanks for your help