如何将xamarin表单应用程序连接到SQL Server管理工作室 [英] How to connect xamarin forms app to SQL server management studio

问题描述

所以我应该将在xamarin表单跨平台上开发的应用程序连接到SQL SSMS 2017.我不能将azure用于防火墙问题，因为这是我的工作。数据库不是本地的，但它已经创建，我可以作为管理员访问它。我对xamarin表单很新，所以我对如何建立连接感到很失望。我一直在做研究，我需要一个REST API才能连接它。我只是想保持简单，这样才有效，我可以把它呈现给我的团队。谢谢



我尝试过：



REST API，ASP。 NET Web API 2，API + PHP

So I'm supposed to connect an app developed on xamarin forms cross-platforms to SQL SSMS 2017. I can't use azure for firewall issues since it's for my job. The database is not local but it's been created already and I have access to it as administrator. I'm really new to xamarin forms so I'm kind of lost on how to make the connection. I've been doing research and I need a REST API to be able to connect it. I just want to keep it simple so it works and I can present it to my team. Thanks

What I have tried:

REST API, ASP.NET Web API 2, API + PHP

推荐答案

您无法将任何应用程序连接到SSMS。 SSMS是用于管理SQL Server实例的工具。我认为你*真正想做的是将应用程序连接到SQL Server数据库。如果是我，我将开发一个可用于连接数据库的Web服务。任何应用都可以连接到Web服务。

You can't connect ANY app to SSMS. SSMS is a tool used to manage a SQL Server instance. What I think you *really* want to do is to connect the app to a SQL Server database. If it were me, I'd develop a web service that could be used to connect to the database. Any app can connect to a web service.

这篇关于如何将xamarin表单应用程序连接到SQL Server管理工作室的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！