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

[AnsarTharammal]

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

[MichaelBranscomb]

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/Sam... 

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/Sam...

For more information see:

• https://developers.arcgis.com/net/latest/wpf/guide/layer-types-described.htm
• https://developers.arcgis.com/net/latest/wpf/guide/features-and-graphics.htm

Tutorials:

• https://developers.arcgis.com/labs/net/display-point-line-and-polygon-graphics/
• https://developers.arcgis.com/labs/net/style-feature-layers/ 

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

[AnsarTharammal]

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.?

[MichaelBranscomb]

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.ht....