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.

Beginnen Sie mit SqlScriptPublishModel.SelectedObjects und dem ScriptItemsCollected-Ereignis. Reproduzieren Sie anschließend den Fehler mithilfe des im Issue verknüpften Testfalls SqlScriptPublishModelTests.cs. Erledigt ist die Aufgabe, wenn die Sammlung ScriptItemsArgs.Urns keine URNs enthält, die sich nur durch die Groß-/Kleinschreibung unterscheiden, wenn sich die Groß-/Kleinschreibung des Servernamens unterscheidet.