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 ?
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
Local SQL If it is just 1 computer I would suggest, installed a DB on your local machine and using that.
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
- Use Entity Framework. Quick walkthrough here: http://www.datasprings.com/resources/articles-information/a-quick-guide-to-using-entity-framework