I have posted a new sample on Code Gallery: BizTalk Server 2010 Adapter Pack: Call SQL Azure View.This is one of samples I have used in my talks on BizTalk Adapter Pack 2010 Integration (A Lap Around BizTalk Adapter Pack 2010) I held in Stockholm for Swedish BizTalk User Group and in Nieuwegein for BizTalk User Group The Netherlands. Hopefully you experiment with it yourself. If you want to work with SQL Azure and want to create a database, see How to Create a SQL Azure Database wiki on TechNet.

Cheers.