I am an iPhone developer. For one of my clients I am supposed to access their database stored in SQL Azure.
I know that there is an Objective C SDK. I have downloaded it and ran the NetFilx example successfully. But of course my client's account is password protected. Also as of now the Objective C SDK seems to provide only read support. But I will need to write to the database too. So I guess that I will have to use REST based calls to update the database.
My problem is that I cannot figure out what will be the URL of the REST services for the SQL Azure Database and how the authentication will work. I tried searching the net but all the examples seems to show how to connect through .Net, Java or PHP (and other supported languages). Nobody seems to talk about pure REST calls.
I can successfully connect to the database using following command:
sqlcmd -UUsername@Server -PPassword -Stcp:server.database.windows.net -dDBName
If such is the connection command, can any of the Gurus out there help me figure out, what should be the URLs to access this DB through pure REST calls and how the authentication will take place.
Any help is greatly appreciated. Thanks in advance.
Pritam.