I had done a non-spatial application for editing, adding, and deleting information out of SQL. I used this tutorial as a base for my application. The tutorial is pretty comprehensive in showing how to create a webservice and then consuming the webservice in an application.
But I needed to do web app using ESRI technology because of the built-in security and domain and subtypes capabilities. I ended up finding a way using an attribute table whose dataprovider is a feature service of a standalone table cast as a feature layer.