SqlScriptPublishModel fires ScriptItemsCollected event with duplicate URNs

When using SqlScriptPublishModel.SelectedObjects to provide URNs of objects to script, the application may have constructed the URN manually with user input.
During scripting, the URNs used to populate progress events are generated by SMO based on server and database queries. As a result the Server[@Name='myserver'] component of the output URN may be of a different case than that of the input URN, causing some internal dictionary lookups based on URN keys to fail. Applications will see this in the ScriptItemsCollected event where the ScriptItemsArgs.Urns collection may have multiple instances of the URN, differing only by the case of the server name component.

We found this in a sql tools service test case failure when the server name case in the local settings json file mismatches the server's self-reported name.

Inizia con SqlScriptPublishModel.SelectedObjects e l'evento ScriptItemsCollected, quindi riproduci il problema utilizzando il caso di test SqlScriptPublishModelTests.cs collegato nell'issue. Il lavoro è completato quando la raccolta ScriptItemsArgs.Urns non contiene URN duplicati che differiscono solo per maiuscole e minuscole quando varia la combinazione di maiuscole e minuscole del nome del server.