Connect iOS app to run SQL server stored procedures

Question

0.00/5 (No votes)

See more:

Hi, I need help with an area I know nothing about. I have a SQL Server database, the business logic of which is contained in stored procedures. I need to connect an ios app to the SQL Server database (to be hosted on AWS), to call these stored procedures. In terms of architecture, am I right in believing a web service needs to be developed to allow the app to connect to the db and call the procedures? Which development language would you recommend ? (advantages/disadvantages?)
I will be engaging a contractor to do this work and would really like to have a clear understanding of what needs to be developed.

What I have tried:

Google searches concentrate on using JSON for db updates, and the few references for ios/stored procedures seem to be outdated.

Posted 21-Sep-16 20:15pm

antm8

Updated 22-Sep-16 3:51am

OriginalGriff

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

David_Wimbley · Answer 1 · 2016-09-22T03:51:00

From a quick google search it looks as though the most common/possibly best route to go is to create an API to expose your database through to your ios app. Then make calls to that web service from your iOS app to access your database.

Also, in my google search, There is this SQLClient: A Native Microsoft SQL Server Library for iOS | Objective C#[^]

However I think the best route to go is an API endpoint of some sort.