May 28
Creating BizTalk WCF-SQL Adapter schemas
Make sure you create WCF-SQL adapters against the target database Do not use stubs A stub generates metadata that may be different The Microsoft BizTalk
Aug 19
Can I use a BizTalk WCF-SQL send adapter with a SQL 2012 Always on Database?
I think the answer is no unless you are prepared to accept the risk of duplicates and/or lost messages Let me explain why below This is a summary of
Apr 18
WCF SQL adapter error: System.Data.SqlClient.SqlException: Maximum stored procedure, function, tr...
Last week I started to get this error in one of the solutions that I had developed The solution had been working fine and all of a sudden in UAT this error
Apr 12
Query notification and the BizTalk WCF SQL Adapter: Comments and unresolved questions
I work with a architect who has an obsession about not allowing BizTalk to poll SQL servers We have tried many times to cure their disorder One of the
Apr 6
WCF SQL Adapter times-out with Composite Operation
Recently one of my colleagues came to me with this problem and I pointed him in the direction of Thiago’s article on the WCF SQL adapter A little while later
Mar 22
Should the WCF-SQL adapter be used in low latency scenarios?
I recently outlined a low latency solution using BizTalk 2010 where the response had to return in less than 1 second 99% of the time The solution was tested
Mar 4
I can't see the BizTalk plug-in for WCF Lob Adapter SDK or I can't see the Consume Adap...
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
Dec 23
Mapping an XML data type from a SQL stored procedure to a BizTalk schema
If you use the the WCF adapter wizard to generate the schema from the stored procedure then the XML data type is now of string type in the result set schema
May 5
The SQL Adapter and Apostrophes
I got an amusing call from a DBA the other day saying that the BizTalk SQL adapter was failing whenever he sent through a message that had an apostrophe in
