The Windows Server AppFabric Customer Advisory Team recently put together some great guidance on managing connections with SQL Azure and EF.  They outline common connection issues when working with a cloud database, and show how you can implement your own custom retry policy.  You can find the article here.