Cloud Zone is brought to you in partnership with:

My name is Bruno Terkaly and I am a Developer Evangelist in Northern California. Over the past few months I have been presenting a wide variety of demos and slides highlighting the wealth of new features in Visual Studio 2008. Bruno is a DZone MVB and is not an employee of DZone and has posted 49 posts at DZone. You can read more from them at their website. View Full User Profile

Consuming Azure Mobile Services from Android: Part 2

12.21.2012
| 3387 views |
  • submit to reddit

 Next steps
001

  1. The next post will cover the following:
    • Adding data to a relational database
    • Understanding the application key
    • Creating a database and a table
    • Managing the database through the portal
    • Modifying table structures (adding columns)
    • Inserting data into the table (TodoItem table)
Previous Posts
Part 1 of 4: Introduction to Consuming Azure Mobile Services from Android http://blogs.msdn.com/b/brunoterkaly/archive/2012/10/03/part-1-of-5-introduction-to-consuming-azure-mobile-services-from-android.aspx
Part 2 of 4: Introduction to Consuming Azure Mobile Services from Android http://blogs.msdn.com/b/brunoterkaly/archive/2012/10/03/part-2-of-5-introduction-to-consuming-azure-mobile-services-from-android.aspx
Part 3 of 4: Introduction to Consuming Azure Mobile Services from Android http://blogs.msdn.com/b/brunoterkaly/archive/2012/10/03/part-3-of-4-introduction-to-consuming-azure-mobile-services-from-android.aspx
Part 4 of 4: Introduction to Consuming Azure Mobile Services from Android http://blogs.msdn.com/b/brunoterkaly/archive/2012/10/03/part-4-of-4-introduction-to-consuming-azure-mobile-services-from-android.aspx
Download Android Source Code https://skydrive.live.com/embed?cid=98B7747CD2E738FB&resid=98B7747CD2E738FB%213151&authkey=AN1ukGyTBgIY76Q
No obligation free trial for Azure Mobile Services http://www.microsoft.com/click/services/Redirect2.ashx?CR_CC=200114759
You will need a trial account for Windows Azure
003_thumb1
  1. Please sign up for it here:
    • http://www.microsoft.com/click/services/Redirect2.ashx?CR_CC=200114759
Note the name of our created service
002
  1. Service Name
    • BrunoToDoService
  2. URL
    • https://brunotodoservice.azure-mobile.net/
  3. Next Steps
    • Click on BrunoToDoService to prepare to have client applications connect to it.
Managing Our Service (brunotodoservice)
003
  1. Do the following:
    • Click on CREATE A NEW WINDOWS STORE APP
      • This will be just a way to see how data can be added
      • It isn't the only way, but it will be the way for this post
  2. A future release will provide direct support for iOS and Android
Getting the APPLICATION KEY
004
  1. You will need the application key and place it in your application.
  2. Perform the following:
    • Click on MANAGE KEYS
    • Copy the APPLICATION KEY somewhere safe
      • Your application key will be different
      • You will use it inside of Fiddler (Debugging tool) and inside your Android application.
Application Creation Wizard (will create a table in the previously created SQL Database)
005
  1. The screen presents 3 steps
    • Step 1
      • For Windows Devs (get the developer tools and SDK)
        • Since we are writing code in Java for Android, this step isn't needed
    • Step 2
      • This step creates a ToDoItem table in our previously created database
      • This is the only step we will run
    • Step 3
      • This step creates a sample project for Visual Studio and Windows 8.
        • Since we are writing code in Java for Android, this step isn't needed
  2. Do the following:
    • Click on CREATE A TODOITEM TABLE
  3. The next step
    • We should add some data to our TODOITEM table
Adding Data (the table and database already exist)
006
  1. On the left side of the screen you should see a database icon
  2. This will allow us to add some data
  3. Step 1
    • Click on the DB icon
  4. Step 2
    • Click on our recently created database and server
Preparing to add data to our TodoItem table
007
  1. You could use SQL Server Management Studio to manage the database
    • But we will use the built in tools
  2. Perform the following:
Looking at our table structure
008
  1. We are going to add a column
  2. There is just one column here now
    • That column is the ID column
    • We will add a TEXT column.
  3. Perform the following:
    • Click on DESIGN
    • Click on EDIT
Looking at our table structure
009
  1. We are going to add a column
  2. Perform the following:
    • Click on ADD COLUMN
    • Add a column called text
    • Click SAVE at the top
  3. Next we will add some data.
Two rows have been added
010
  1. There will only be two rows for now
  2. But you can add as many as you like
  3. We added:
    • Eat Lunch
    • Finish Blog Post
Next Steps
011
  1. The next post will cover these topics:
    • Interacting with Azure Mobile Services using a web proxy client
    • This can give you an in-depth knowledge of REST and HTTP
    • Downloading and configuring Fiddler
    • Using Fiddler to issue GET requests
Thanks..
I appreciate that you took the time to read this post. I look forward to your comments.
Published at DZone with permission of Bruno Terkaly, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)