I was trying to help a newbie developer with the WCF adapter today and got stumped for awhile by the above problem. They were using BizTalk 2006R2 and were trying to consume a stored procedure and create WCF-SQL schemas using the WCF-SQL adapter but on selecting “add Generated items” from the menu in visual studio they got a screen like this that was missing the Consume Adapter;My first thought was that they have not installed the WCF LOB Adapter SDK and The Microsoft BizTalk adapter for SQL server but when I checked both items had been installed. I suggested that they try reinstall both components but this did not solve the problem (see http://www.microsoft.com/downloads/en/details.aspx?FamilyID=CEB0BB34-F9D2-4D14-8BBE-0311D227B091#Instructions for how to install the WCF-SQL adapter).
I next got them to check all the pre-requisites for the two installed components. On checking the version of BizTalk in the registry they reported that they had version 3.5.1602.0. “Ah ha!” i said, “you are using BizTalk 2006, the WCF SQL adapter can’t be used with that version” (see http://biztalkmessages.vansplunteren.net/2010/03/04/biztalk-2006-r2-version-number-not-updated-after-applying-sp-1/ for BizTalk version numbers). No they said I am using BizTalk 2006R2 because I can see that I have AS2 and the WCF-HTTP adapters. Those components only exist in BizTalk 2006R2 not BizTalk2006.
Now I was interested so I tried to reinstall the WCF LOB Adapter SDK myself. On reinstalling the following screen came up and now I smelt a rat. The option to install the BizTalk plugin was missing. The only item that you could install was the run time components.
I opened the BizTalk administration console and right-clicked on to show that version 3.6.1404.0 of BizTalk was installed in direct contradiction to that reported in the registry. This is the correct version number for BizTalk2006R2.
As a longshot I decided to changed the version number in the registry to 3.6.1404.0. On reinstalling the WCF LOB Adapter SDK the option to the install the BizTalk plugin is now available and if you select it the consume adapter it is runnable in the “Add generated items” from the visual studio menu. How on earth the version number got set to the wrong version in the registry is beyond me but now the newbie was on his way.