What is considered the correct approach to plot Geo data from a Local SQL server onto the Map. I was expecting rather more advanced techniques that simply trawling through datasets and hand plotting/reprojecting points/lines onto Graphics layers... Since we are going to have many dynamic layers, changing often we were hoping/expecting there to be something a little more integrated with the SQL Server API. Can anyone give me the approach which is designed for this scenario?
You can publish a map service on ArcGIS Server and consume it from your client application. This service will reference data from an enterprise geodatabase which is stored on SQL Server.
Supported geodatabase formats for .NET
Supported geodatabase formats—ArcGIS Runtime SDK for .NET | ArcGIS for Developers
ArcGISDynamicMapServiceLayer Class (Dynamic ArcGIS REST map service layer)
ArcGIS Runtime SDK for .NET - Windows Desktop API Reference | ArcGIS for Developers