Accessing an external SQL database in iOS

Question

I am writing an iOS application that needs to access data from an external SQL Server 2005 database. I already have a website that accesses the same data.

I usually access the SQL server database using .NET along with stored procedures for security reasons. I need to populate an array that will itself populate another TableViewController. As I'm fairly new to the whole iOS thing, kindly let me know how I can do this. If it's possible, please suggest the syntax or Google keywords for this.

evanmcdonnal · Accepted Answer · 2012-06-02 00:49:29Z

2

I'd recommend making a simple WCF .NET REST Service that queries your database and returns what you need.

I'm pretty sure your iOS app will not be able to connect to it directly.

Check out the following; http://msdn.microsoft.com/en-us/library/bb412178.aspx

http://www.codeproject.com/Articles/105273/Create-RESTful-WCF-Service-API-Step-By-Step-Guide

The code project tutorial is very easy to follow. And you can download the project code.

answered Jun 2, 2012 at 0:49

evanmcdonnal

48.5k17 gold badges111 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rooster117 · Accepted Answer · 2012-06-02 00:48:51Z

1

It sounds like you will want to make an API to access your database and you can access it through web requests. Essentially you will be performing web requests and respond from your site in json or xml where within your iOS client side code you can parse that and do what you need with it.

answered Jun 2, 2012 at 0:48

rooster117

5,5321 gold badge23 silver badges21 bronze badges

Collectives™ on Stack Overflow

Accessing an external SQL database in iOS

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related