Posts Tagged ‘WCF-SQL Adapter’

Here is a great explanation of how to use polling with the WCF-SQL adapter.

Richard Seroter's Architecture Musings

A few years back now (sheesh, that long already??) I wrote a post about debatching messages from the classic BizTalk SQL adapter.  Since that time, we’ve seen the release of the new and improved WCF-based SQL adapter.  You can read about the new adapter in a sample chapter of my book posted on the Packt Publishing website.  A blog reader recently asked me if I had ever demonstrated debatching via this new adapter, and to my surprise, I didn’t found anyone else documenting how to do this.  So, I guess I will.

First off, I created a database table to hold “Donation” records.  It holds donations given to a company, and I want those donations sent to downstream systems.  Because I may get more than one donation during a WCF-SQL adapter polling interval, I need to split the collection of retrieved records into individual records.

After creating a new…

View original post 571 more words

Advertisements

Atin Agarwal has an excellent post regarding ‘Inserting parent child records with Identity column using WCF-SQL Adapter in one transaction’.

via Inserting parent child records with Identity column using WCF-SQL Adapter in one transaction – One Blog for Biztalk Engineers – Site Home – MSDN Blogs.