best practice connecting directly to sqlserver

Question

hello together,
i want to connect from multiple android devices to a ms sqlserver database in an internal environment only using wlan and no internet connection. are there any best practices for doing that?
with our old devices (win6.5) we use system.data.SqlClient and SqlConnection. Reading data via SqlCommand and Execute.. (Reader, Scalar, NonQuery e.g.).
all I get for online services is to use a webservice, but i want to try it directly and to be always up to date.
Thanks in advance!

Answer 1

hello,
tried two solutions:

• first: according to stackoverflow article from 2016 with interface and use service from pcl to xamarin android function. works :)
• second: only in pcl, use NETStandard.Library (2.0.3) and add NuGet package System.Data.SqlClient(4.8.2)
  now you get simple access to mssqlserver ;)

and yes, I know, that this is not a secure way to get access to a sql server database on an internet connection, but i think it works for my purpose using it only on internal devices without access to public internet.

Regards