[This article was contributed by the SQL Azure team.]
Steve Hale, who is on the SQL Server connectivity and protocols team, wrote an excellent article on data access APIs and SQL Azure. I highly recommend everyone check it out here.
Thanks Steve, I owe you yet another one :)
Dave