using MS SQL in my iphone app iOS
Posted on 2012-12-27
I am completely new to this field. Currently going through a couple books now on Ios development. I have a question just so I know where to focus my attention.
I currently have this winform project that accesses a MS SQL database where the SQL database does all the heavy lifting calculations with Stored Procedures.
I'm thinking adding a iPhone app to display this data in charts, graphs, grids, and so on.
Before I get into any actual project, can I access MS SQL in iOS?
I've been googling it and I don't see a clearcut way... like a few lines of code from my c# to connect and call querys.
I see something about writing a webservice... but people are saying it is difficult and shouldn't go this route.
Other searches are saying use SQLite... but then I'll have to re-do ALLLLL my stored procedure and learn a new SQL database code, while I have a hard enough time with MS SQL.
What is the norm for apps to communication to a DB? And can I just connect to my MS SQL?
thanks for the info!!!