Hello everyone i have 5 tables in my database three are spacial tables and two are data tables i want something like user will draw polygon and then center point will create and then user will insert some location information so that all information will save in location table and then it will take location id from location table and then that polygon will save in polygon table with location id point will save in point table everything is working fine but i am just curious to know the method i am using is correct or there is better way to implement this?
to insert data in location table which is data table not spacial table i am using wcf service.so i was thinking if i create feature service of location table and then i add it as feature?but i am gettting error I tried this
FeatureLayer fl = new FeatureLayer();
fl = MyMap.Layers["lfl"] as FeatureLayer;
if (fl.IsInitialized == true)
{
fl.EndSaveEdits += new EventHandler<ESRI.ArcGIS.Client.Tasks.EndEditEventArgs>(fl_EndSaveEdits);
fl.SaveEditsFailed += new EventHandler<ESRI.ArcGIS.Client.Tasks.TaskFailedEventArgs>(fl_SaveEditsFailed);
Graphic g = new Graphic();
g.Attributes.Add("OWNER_ID", 1);
g.Attributes.Add("PROJ_TYPE ", "PUB");
g.Attributes.Add("LOC_NAME", "just testingggg");
fl.Graphics.Add(g);
fl.SaveEdits();
}
here feature layer is i have set it as location feature.so this graphic contains only data information not geometry or anything?also i haven't pass location_id as it is auto increment field in my sql table.
Please let me know to insert , update , delete in data table which is better way to write wcf service or create feature service and then insert ,update ,delete?
also if it is possible to insert update delete data as feature then any way to upload the documents?