I have seen few customers running into this issue. This forced me to write this blog. Background : On a development environment, my customer had a BizTalk application. Application has few WCF bindings. They created MSI file that can be used to install...

There would be scenarios where you are inserting into a Parent table which have got an auto incrementing or an Identity field and you need to get this identity value back and use it to insert into child table records. And that too all, in a single transaction...