External connection to sql server by android application, C # xamarim [closed]

-1

Well I'm looking for information about what procedure to access a sql server database by android.

    
asked by anonymous 28.07.2018 / 15:44

1 answer

0

In the case of mobile applications, the connection to the database is slightly different from that of desktop applications.

For you to "talk" to the database through an application, you need to create a server, which will mediate between the bank and the application. In case the server would have to stay next to the database.

Through the application you will make requests to the server that will perform the requested action, for example:

• If you want to fetch data (SELECT) you would have to create a routine (GET) on the server that will connect to the database, perform the search and then return the data of your search, I advise to return the data in JSON form, and then in the application you treat this JSON.

• If you want to insert data (INSERT) you would have to create a POST routine on the server that will receive the data from the application and then connect to the database, perform the insert and then return to your application if everything is OK or not, I again advise sending the data to the server using JSON.

Note: I recommend using JSON because it is a light way of passing data and because all the language accepts.

You can create a service in windows that will work as a server, using C #, Pascal (Delphi), PHP, among others ... Look for something like Web Service RESTFULL with JSON in the language you understand best. >     

28.07.2018 / 16:37