Solved

iOS App - Database connection

Posted on 2014-02-11
1
466 Views
Last Modified: 2014-02-11
I have a hosted database server, and a ASP.net app that connects to it.

How do I connect to the same DB using an IOS app? I need to obtain login credentials and perform a few inserts and updates on a few tables.
0
Comment
Question by:proginc
1 Comment
 
LVL 16

Accepted Solution

by:
Surendra Nath earned 500 total points
Comment Utility
in the iOS end, I suggest you to create a web-api from asp.net and expose it to the iOS, instead of the mobile user trying to connect to SQL directly.

from iOS pass on the credentials to the web-api, and in the web-api (in your server), connect to SQL using the SQL Authenticaiton instead of the windows authentication, once you validated that the user using your api is a valid user.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

What's a UDID? If you're involved in developing, testing, or even reviewing an iOS application that's in beta, then at some point you may need to know the UDID for any iOS devices that you'll be testing on. What's the UDID? It stands for Unique Dev…
     Intro      In this article, I will show you how to parse a JSON in Swift using an open source library called SwiftyJSON (https://github.com/SwiftyJSON/SwiftyJSON). If you haven't heard of a JSON before, it stands for JavaScript Object Notation…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now