topic Re: ArcGIS Pro Add-In: How to load spatial SQL Server table to project's active map using C#? in ArcGIS Pro SDK Questions

ArcGIS Pro Add-In: How to load spatial SQL Server table to project's active map using C#?

JadedEarth — Fri, 14 Jan 2022 12:47:00 GMT

I'm new to ArcGIS Pro SDK. I have an Add-in app that performs queries, joins etc. using SQL Server
databases. There are multiple databases, tables, and joins involved so I use SQL Server environment to perform all the query, search, and join operations.

After all queries are done, I want to display the resulting spatial table on the ArcGIS Pro project map (result is basically a polygon shapefile).

However, although SQL Server table has shape, it doesn't have a spatial reference. I want to use
Albers Equal Area Conic-USGS (I think it has a spatial reference SR_wkid = 6703).

How do I load the spatial SQL Server table (with spatial reference) onto the Active map using C# from my Add-In app? I have created a database connection to the SQL Server database. So my parameters look like this:

srcPath = "E:\WorkingFolder\MyAddIn\GISTMPConnection.sde";
in_features = "APEX_SWAT_COMP_HUC8";
out_layer = "ApexSwatCompare_layer";

Appreciate any help.

Re: ArcGIS Pro Add-In: How to load spatial SQL Server table to project's active map using C#?

GKmieliauskas — Fri, 14 Jan 2022 14:25:36 GMT

Hi,

How to create featurelayer you can find in ArcGIS Pro SDK Snippets

string url = @"E:\WorkingFolder\MyAddIn\GISTMPConnection.sde\ApexSwatCompare_layer"; Uri uri = new Uri(url); await QueuedTask.Run(() => LayerFactory.Instance.CreateLayer(uri, MapView.Active.Map));

Re: ArcGIS Pro Add-In: How to load spatial SQL Server table to project's active map using C#?

JadedEarth — Fri, 14 Jan 2022 17:45:57 GMT

Hi,

Thank you. I encountered "two-step" errors:

1. First, my connections string for the sde was wrong. The correct one was (I renamed the table fearing I was encountering character limit in my name):

string url = @"E:\WorkingFolder\SWATAddIn\MGConnection.sde\MG.dbo.AxSwCompare";

The dot-dbo notation should be specified: "\databaseName.dbo.tableName".

2. Next, the table in sde geodatabase didn't have OBJECTIDs, so ArcGIS Pro was throwing an exception. I have to modify the SQL Server table to add OBJECTIDs as IDENTITY-type.

It was able to load the shapefile after I did the above.

Thanks for the link. It was very helpful. I couldn't have found them on my own.