This article demonstrated how to create a database in the cloud and then how to use Visual Studio 2010 to create a cloud application that communicates with that database.  As you saw in this article, even if your database is in the cloud, creating an application is not any different than if the database were local.  There are obvious financial benefits for having your database hosted in the cloud but there are security issues that go along with it.  It is up to you to decide what makes sense to put in the cloud and what not to put in the cloud.  At least you have the option to do so and Microsoft has made it pretty easy to get yourself up and running quickly.  Good luck on your project and happy coding.