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

Optimizing Java Array Copy

java arrays

So for my research group I am attempting to convert some old C++ code to Java and am running into an issue where in the C++ code it does the following:

Android - draw squares in xml

android

I'd like to draw three squares side-by-side in xml, so that they fill the screen horizontally (minus a margin of 12 dp on each side). According to this post it seems possible to do this messily with

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.