连接iOS应用程序以运行SQL Server存储过程 [英] Connect iOS app to run SQL server stored procedures

问题描述

我需要帮助一个我一无所知的地方。我有一个SQL Server数据库，其业务逻辑包含在存储过程中。我需要将ios应用程序连接到SQL Server数据库（在AWS上托管），以调用这些存储过程。在架构方面，我是否正确地认为需要开发Web服务以允许应用程序连接到数据库并调用程序？你会推荐哪种开发语言？ （优点/缺点？）

我将聘请承包商来完成这项工作，并且非常希望能够清楚地了解需要开发什么。



我尝试了什么：



Google搜索专注于使用JSON进行数据库更新，以及针对ios的少数参考资料/存储过程似乎已过时。

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.

推荐答案

从快速谷歌搜索看起来最常见/可能最好的路线是创建一个API来暴露您的数据库到您的ios应用程序。然后从您的iOS应用程序调用该Web服务以访问您的数据库。



另外，在我的谷歌搜索中，有这个SQLClient：适用于iOS的原生Microsoft SQL Server库目标C＃ [ ^ ]



但是我认为最好的路线是某种类型的API端点。

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.

这篇关于连接iOS应用程序以运行SQL Server存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！