WCF-SQL Adapter

Question

How to add the wcf-sql adapter to BizTalk application?

Aditi

Answer 1

You need to install LOB Adapter Pack and BizTalk Adapter Pack (both 64 bit and 32 bit)

Then you should be able to use it in both the BizTalk Administration Console and Visual Studio.

Rachit

Answer 2

Hi Aditi,

To add WCF-SQL adapter follow the MSDN link:Adding the SQL Adapter to BizTalk Server Administration Console

To add WCF-SQL adapter  and start working with it, follow the technet article : BizTalk Server: WCF-SQL Adapter Table Operations

__________________________________________________________________

Maheshkumar S Tiwari|User Page|Blog|BizTalk Server: Multiple XML files to Single FlatFile Using File Adapter

Answer 3

You can also.,...

Download and install WCF - SQL Adapter from the link.

After installation, you need to add WCF-SQL into the adapter list. Refer: Adding the SQL Adapter to BizTalk Server Administration Console             

Note: If you will not see WCF-SQL in the drop down list, check machine config .

Rachit

Answer 4

How to add the wcf-sql adapter to BizTalk application?

Aditi

You need to install WCF Adapter SDK and WCF LOB adapter pack (do a full installation on the drive ) . You can find them in BizTalk Setup option .

Thanks

Abhishek

Answer 5

thanks Mahesh and Rachit. :)