How to add data to SQL Azure through GSM Modem?

I recently worked with Hyper Terminal on windows 7 in which i access SMS received through a GSM SIM card on my laptop port and using GSM Modem Device connected to my PC. Demo Application here : http://www.codeproject.com/Articles/38705/Send-and-Read-SMS-through-a-GSM-Modem-using-AT-Com

Now i have an account on windows azure and i do have a sql azure database named PersonInfo in which i want to add some data from my SIM sms. The data is like '253 Mobulite NetTimeet' and i want to send this SMS using my SIM and want it to store at Azure Databse table.

Please suggest what options do i have ? How can i achieve this ?

Thanks

Answers


Not sure why all the down votes but lets go through this.

You have an application that needs to store data, from data it receives or sends via SMS.

GSM Model communication

From your tags I can see you want to develop and app in c#. You will need to communicate to the GSM modem most likely via COM/Serial ports. Just looking at the link you provided, I assume that is how you are doing things. The hyperterminal comment threw me, I'm not sure why you mentioned it.

Data Storage Options

  1. Local SQL If it is just 1 computer I would suggest, installed a DB on your local machine and using that.

  2. SQL Azure I would only recommend this if you had multiple locations that all needed to read off the same database. Otherwise if it is all on just 1 pc and the data doesn't need to be available online then use a local DB.

C# To Database

  1. Use Entity Framework. Quick walkthrough here: http://www.datasprings.com/resources/articles-information/a-quick-guide-to-using-entity-framework

Need Your Help

How to call a method through both a button and another method

java android methods

protected void onCreate(Bundle savedInstanceState) {