PingBack from http://topsy.com/tb/bit.ly/2Kxv4

Kudos for a great Sql Server article - Trackback from SqlServerKudos

Jonathan, I am in the process of writing an AddIn for SSMS and would be affected by the above changes.  Have you heard if they have any plans to finally support addins within SSMS?  Some of the SSMS PMs approached the group I worked for about 4 years ago and asked if we wanted support for SSMS addins so I had hoped that it would eventually make it in (or at least no breaking changes would occur...)

Jonathan, this is extremely useful info. Thanks for the heavy lifting!

Just to let everyone know that this method isn't 100% reliable.

i've played with this extensively and haven't found a reliable way in R2 to tackle this issue. The object explorer appears to be loading in async mode in R2 and it doesn't have any IsLoaded event you could subscribe to.

The problem is that the Componet Collection doesn't always have a ContextService at the startup.

so for now R2 is a no go for add-ins that use Object Explorer in any way.

as for the official add-in supprot it defintely won't be in R2. and by looking at the API itself i can't see it being realisticaly done in later version too.

on my system the sql08r2 call recommended above to retrieve the ContextService object throws an invalid cast exception.  Anyone else getting this and found a work around for retrieving that object in order to wire up the selection changed event handler?

//IObjectExplorerService objectExplorer = ServiceCache.GetObjectExplorer();

//IObjectExplorerEventProvider provider = (IObjectExplorerEventProvider)objectExplorer.GetService(typeof(IObjectExplorerEventProvider));

//provider.SelectionChanged += new NodesChangedEventHandler(Provider_SelectionChanged);

ObjectExplorerService objectExplorer = (ObjectExplorerService)ServiceCache.ServiceProvider.GetService(typeof(IObjectExplorerService));

ContextService contextService = (ContextService)objectExplorer.Container.Components[0];

INavigationContextProvider provider = contextService.ObjectExplorerContext;

provider.CurrentContextChanged += new NodesChangedEventHandler(Provider_SelectionChanged);

got existing addin working on sql08r2 ctp2 using following OnConnection and Provider_SelectionChanged implementation changes

public void OnConnection(object application, ext_ConnectMode connectMode, object addInInst, ref Array custom)

{

   //_applicationObject = (DTE2)application;

   _addInInstance = (AddIn)addInInst;

   _applicationObject = (DTE2)_addInInstance.DTE;

   // do something with the application, e.g. reference the Commands

   Commands2 commands = (Commands2)_applicationObject.Commands;

   //IObjectExplorerService objectExplorer = ServiceCache.GetObjectExplorer();

   //IObjectExplorerEventProvider provider = (IObjectExplorerEventProvider)objectExplorer.GetService(typeof(IObjectExplorerEventProvider));

   //provider.SelectionChanged += new NodesChangedEventHandler(Provider_SelectionChanged);

   // search ServiceCache.ServiceProvider.GetService ->

   // http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/22/sql-2008-r2-breaks-ssms-addins.aspx

   ObjectExplorerService objectExplorer = (ObjectExplorerService)ServiceCache.ServiceProvider.GetService(typeof(IObjectExplorerService));

   //ContextService contextService = (ContextService)objectExplorer.Container.Components[0];

   //ContextService contextService = (ContextService)ServiceCache.ServiceProvider.GetService(typeof(ContextService));

   // for some reason calling GetSelectedNodes forces to add ContextService to ObjectExplorerService.Container.Components

   int count = objectExplorer.Container.Components.Count;

   int nodeCount; INodeInformation[] nodes;            

   objectExplorer.GetSelectedNodes(out nodeCount, out nodes);

   count = nodeCount; count = nodes.Length;

   count = objectExplorer.Container.Components.Count;

   ContextService contextService = (ContextService)objectExplorer.Container.Components[1];

   // or ContextService contextService = (ContextService)objectExplorer.Site.Container.Components[1];

   INavigationContextProvider provider = contextService.ObjectExplorerContext;

   provider.CurrentContextChanged += new NodesChangedEventHandler(Provider_SelectionChanged);

}

private void Provider_SelectionChanged(object sender, NodesChangedEventArgs args)

{

   INavigationContextProvider provider = (INavigationContextProvider)sender;

   //INodeInformation[] nodes;

   //int nodeCount;

   ////IObjectExplorerService objectExplorer = ServiceCache.GetObjectExplorer();

   //ObjectExplorerService objectExplorer = (ObjectExplorerService)ServiceCache.ServiceProvider.GetService(typeof(IObjectExplorerService));

   //objectExplorer.GetSelectedNodes(out nodeCount, out nodes);

   //INodeInformation node = (nodeCount > 0 ? nodes[0] : null);

   INodeInformation node = (args.ChangedNodes.Count > 0 ? args.ChangedNodes[0] : null);

Hi,

You are geniuses.

I never understood how and what tools  you use to 'discover' the undocumented functionality of SQL Server Management Studio.

You must have smart tools. Can you share some of your working methods with such tools?

Thanks.

Anyone know when the fall ctp will be available?

I've checked at sql2008r2.com but it's still the august ctp.