When generating a strongly type dataset using the SQLDataAdapter, only
primary key constraints defined in the SQL Server source table seem to
result in unique constraints in the generated datatable. Source table
unique constraints other than the primary key constraint don't appear
to result in unique constraints in the datatable.
So, how can you use the dataset designer to add non-primary key unique
constraints? Can't seem to see how this can be done.
I understand how to add the constraint in code, was just wondering if
it could be done in the designer as well.