Connection between SQL SERVER and FLUTTER
811 views
Skip to first unread message
Liyakathali K
Apr 12, 2021, 9:47:30 PM4/12/21
to Flutter Development (flutter-dev)
Can I connect sql server with flutter? Any one help me. I am using C#.Net and SQL SERVER for my current project. But my clients need android desktop or tab App with this SQL SERVER database. Is it possible?
Suzuki Tomohiro
Apr 12, 2021, 9:51:27 PM4/12/21
to Liyakathali K, Flutter Development (flutter-dev)
I don't think it's possible because of authentication.
If you know how to authenticate the connection between your Flutter app and SQL Server, then it's possible.
On Mon, Apr 12, 2021 at 9:47 PM Liyakathali K <liyak...@gmail.com> wrote:
Can I connect sql server with flutter? Any one help me. I am using C#.Net and SQL SERVER for my current project. But my clients need android desktop or tab App with this SQL SERVER database. Is it possible?
--
You received this message because you are subscribed to the Google Groups "Flutter Development (flutter-dev)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to flutter-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/flutter-dev/f93de892-b3c3-4f40-a6e3-590fda52d8ccn%40googlegroups.com.
Guyren Howe
Apr 13, 2021, 12:34:29 AM4/13/21
to Flutter Development (flutter-dev), Liyakathali K
I would not have clients running on platforms you don’t absolutely control connecting directly to your database. Much better to have then connect to your C# app and it connects to SQL Server.
And make sure you lock down your app’s privileges in the database so the attack surface there is minimal.
If this app is controlling anything of significant value, I would engineer in the database that the C# app has to indicate which user it is working on behalf of, and restrict the connection to only showing that user’s data. eg set a session variable indicating the current user and have the application only able to see views that use that session variable to restrict information to what the user can see.
As I say, that depends on how valuable the information the application is manipulating is.
And make sure you lock down your app’s privileges in the database so the attack surface there is minimal.
If this app is controlling anything of significant value, I would engineer in the database that the C# app has to indicate which user it is working on behalf of, and restrict the connection to only showing that user’s data. eg set a session variable indicating the current user and have the application only able to see views that use that session variable to restrict information to what the user can see.
As I say, that depends on how valuable the information the application is manipulating is.
On Apr 12, 2021, 18:47 -0700, Liyakathali K <liyak...@gmail.com>, wrote:
Can I connect sql server with flutter? Any one help me. I am using C#.Net and SQL SERVER for my current project. But my clients need android desktop or tab App with this SQL SERVER database. Is it possible?
--
Suzuki Tomohiro
Apr 13, 2021, 7:23:11 AM4/13/21
to Guyren Howe, Flutter Development (flutter-dev), Liyakathali K
If I read correctly, it’s C# app that connects to SQL server. Now you’ll need to deal with connection between C# and SQL server. Flutter is no longer the challenge. Is this correct?
To view this discussion on the web visit https://groups.google.com/d/msgid/flutter-dev/86c2b9a5-ba7c-4624-8ec1-6ce2a67fba0e%40Spark.
Reply all
Reply to author
Forward
0 new messages