Select to view content in your preferred language

Adding features to SDE using SQL

615
1
05-23-2012 11:42 PM
orsela
by
Emerging Contributor
I have a graphic on my map (let's assume its a polygon), that I want to insert to a featureclass table in my SDE using native SQL.
How do I do that?
Do I need to manually convert the Geometry class of the Silverlight/WPF API to the string I need in order to build my SQL insert statement?
Or is there another simpler way?

I'm aware of the option of using a FeatureService that does all that automatically, but I need to do it using SQL.
I'm using SQL Server 2008 R2 and ArcGIS Server 10.

Thanks
0 Kudos
1 Reply
JenniferNery
Esri Regular Contributor
I think you can use WCF service to send features directly to SQL. There is a blog post on sending geometry: http://blogs.esri.com/esri/arcgis/2010/03/11/sending-geometry-between-silverlight-and-the-server-usi...
0 Kudos