如何使用c#在SSMS(SQL Server Management Studio) 17的标题栏中设置自定义文本

using System;
using System.Reflection;
using EnvDTE80;
using Microsoft.SqlServer.Management.UI.VSIntegration;
using Microsoft.VisualStudio.Shell.Interop;

public class CustomTitleBar
{
    public void SetCustomText(string text)
    {
        // 获取当前的DTE对象
        var dte = (DTE2)Package.GetGlobalService(typeof(SDTE));

        // 获取SSMS主窗口对象
        var mainWindow = (IVsWindowFrame)dte.MainWindow;

        // 获取主窗口的属性
        object propertyValue;
        mainWindow.GetProperty((int)__VSFPROPID.VSFPROPID_Caption, out propertyValue);

        // 设置自定义文本
        var caption = propertyValue.ToString();
        var assemblyName = Assembly.GetExecutingAssembly().GetName().Name;
        var customCaption = $"{text} - {assemblyName}";
        mainWindow.SetProperty((int)__VSFPROPID.VSFPROPID_Caption, customCaption);
    }
}