I need to develop a UWP application in C # / XAML for use in the industry for data collection via Lumia 640 XL mobile phone with Windows 10 Mobile. All persistence (CRUD) will be in SQL Server 2012 on the internal corporate network. The app will then be extended to other devices (Tables + PC and up to IoT). That is, everything will be based on Windows 10.
Now with .Net Standard 2.0 supporting System.Data, I would like to know if anyone has already successfully tested this + CRUD connection directly on the device's external SQL Server 2012 without the use of WebServices.
If yes, what was the final verdict?