user5766354
user5766354

Reputation:

Flutter with Azure API connecting to SQL SERVER DB

I am developing a mobile app with Flutter, however my data sits in a sql sever database. Would I still be able to perform CRUD operations on that DB from a Flutter mobile app?

And are there any magical plugins for Flutter to achieve this ?

Thanks Luke

Upvotes: 2

Views: 4737

Answers (2)

Leon Yue
Leon Yue

Reputation: 16431

You can reference this blob: How to connect Flutter App to sql server .

NTMS did that successfully with SQLServerSocket.

First: you need a SQLServerSocket: https://github.com/nippur72/SqlServerSocket is free and works!

Second: you need a client https://github.com/nippur72/SqlServerSocket (look in DartClient folder).

He tested it with his remote sql and is working on CRUD.

I think you can get more useful infromations from that blob.

Hope this helps.

Upvotes: 2

Sami Kanafani
Sami Kanafani

Reputation: 15751

the best way from my point of view is to do that is through http Requests, this means you need to

  1. create a rest application on your azure API
  2. the application will perform http requests(post-patch-delete-get)
  3. each request of these will map to an operation on the database(get = read, post=create, patch=update, delete=delete)

Upvotes: 2

Related Questions