topic Re: Add Layer from Database or Datatable to Basemap using Esri.ArcGISRuntime in C# in .NET Maps SDK Questions

Add Layer from Database or Datatable to Basemap using Esri.ArcGISRuntime in C#

AnsarTharammal — Mon, 18 Jan 2021 08:06:38 GMT

How can I add/create Layer using Datatable or Database Query in C#.net instead adding through Uri using Esri.ArcGISRuntime sdk for wpf?

Re: Add Layer from Database or Datatable to Basemap using Esri.ArcGISRuntime in C#

MichaelBranscomb — Mon, 18 Jan 2021 22:51:47 GMT

You can use either a GraphicsOverlay or a FeatureCollectionLayer to display a layer from a database/datatable. I've summarized some of the key differences below.

GraphicsOverlay:

Suitable for displaying temporary data, particularly if the data will be updated frequently.
Part of the MapView and will be rendered on top / in front of all other content in the Map.
Will not be saved if you save the Map.
Sample: https://github.com/Esri/arcgis-runtime-samples-dotnet/tree/main/src/WPF/ArcGISRuntime.WPF.Viewer/Samples/GraphicsOverlay/AddGraphicsRenderer

FeatureCollectionLayer:

Suitable for persistent data where you want the behavior to match other feature data in the map.
Part of the OperationalLayers collection in the Map and will be rendered in the order of the layers in the Map.
Will be saved if you save the Map.
Sample: https://github.com/Esri/arcgis-runtime-samples-dotnet/tree/main/src/WPF/ArcGISRuntime.WPF.Viewer/Samples/Layers/FeatureCollectionLayerFromQuery

For more information see:

Tutorials:

For a larger example see: https://github.com/Esri/arcgis-runtime-demos-dotnet/tree/main/src/GeoEventServerSample

Re: Add Layer from Database or Datatable to Basemap using Esri.ArcGISRuntime in C#

AnsarTharammal — Tue, 19 Jan 2021 05:09:02 GMT

But above mentioned links or samples doesn't shows how to create layer with the data from a database. And also I need to select any point/location from the generated layer to show popups with details of that point.

Can you provide me some sample code.?

Re: Add Layer from Database or Datatable to Basemap using Esri.ArcGISRuntime in C#

MichaelBranscomb — Tue, 19 Jan 2021 21:30:56 GMT

In the examples above you will write code to query the database/datatable then create features or graphics with geometry, attributes, and a renderer. These examples assume relatively low volumes of data, e.g. 1000s or 10,000s of features/graphics because you will retrieve all the records in one query and add them to the map view.

For larger volumes of data where you want to retrieve data from the database based on a spatial queries. for example as the user pans or zooms the map view, a spatially enabled database and a feature service are recommended. For more information see https://pro.arcgis.com/en/pro-app/latest/help/sharing/overview/introduction-to-sharing-web-layers.htm.