I pre-ordered this book by Richard Seroter and eagerly awaited its delivery, but due to work commitments I have not really been able to give it the time it needed. Things are a bit quieter now so I thought I’d bite the bullet and work my way through it. I have to say I rather like the book; it is a good mixture of BizTalk Server 101 and BizTalk Server arcana. For me the book is split in to 3 distinct parts, with Part 1 covering Chapters 1 – 4 and what I would call “Introduction and Background”, Part ......
Having posted on the SQL Adapter to select data from a SQL Server database, I realised (too late as it happens!) that I had missed one approach. This approach is to use the Strongly-Typed Procedures option from the Adapter UI. You can see you get to choose from the same list of stored procedures, but this time you get additional schemas generated. The approach I took was the same as used for the untyped stored procedure, so taking a file in, transforming using a String Concatenate functoid, calling ......
I started having a think about how you could make BizTalk Server 2009 RESTful as I had been asked to give it some thought. Whilst thinking about it and wondering how I could let any subscription know the message it was subscribing to was supposed to be GET, DELETE, PUT or whatever I started creating some basic plumbing to give me something to test. To this end I started taking a look at the new WCF SQL Adapter in the BizTalk Adapter Pack 2.0. This new adapter is built using the WCF LOB Adapter SDK ......