Adding features to SDE using SQL

orsela — Thu, 24 May 2012 06:42:56 GMT

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

Re: Adding features to SDE using SQL

JenniferNery — Thu, 24 May 2012 17:08:26 GMT

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-using-wcf/

topic Re: Adding features to SDE using SQL in ArcGIS API for Silverlight Questions

Adding features to SDE using SQL

Re: Adding features to SDE using SQL