Configuring SQL Server Accent-Insensitivity

using System;

using Microsoft.SqlServer.Management.Sdk.Sfc;

namespace Siphon
{
    /// <summary>
    /// A key concept in using the SMO object library is the Unique Resource Name (URN). The URN uses a syntax similar 
    /// to XPath. The XPath is a hierarchy path used to specify an object in which each level has qualifiers and 
    /// functions. In SMO the URN has two elements: the path and attribute naming that has limited functionality. The 
    /// path is used to specify the location of the object whereas the attribute naming allows for a degree of 
    /// filtering. An example of an URN for a database synonym is:
    /// Server[@Name='SOL']/Database[@Name='ix_nm_extensions']/Synonym[@Name='Lookups_Values' and @Schema='c']
    /// </summary>
    public class UrnHelper
    {
        static public String GetSchema(String urnText)
        {
            Urn urn = new Urn(urnText);
            return urn.GetAttribute("Schema") ?? String.Empty;
        }

        internal static string GetName(Urn urnText)
        {
            Urn urn = new Urn(urnText);
            return urn.GetAttribute("Name");
        }
    }
}