I use a non version SQLServer geodatabse with geometry type for spatial data storing.To do so,I have registered all layers in SDE repository and geodatabase and ArcMap shows all layers and edit them properly.
But to apply some business rules,I have to catch ArcMap editor control in OnCreate even of Editor Object and I have to query database inside this event,so I encounter concurrency&lock problem according to this ESRI's document:
even after I changed all my codes (which access geodatabase) into ArcObject model(so I use Editor::Workspace object to retrive data using ICursor and IFeatureCursor) I still receive some errors that show me database is locked while ArcMap editing session,although ESRI says isolation level is UNCOMMITTED READ.If isolation level is uncommitted read,I can at least read data from geodatabase during the time after ArcMap creates a feature and before user commits transaction.But event a simple SELECT query is locked by ArcMap.I wonder if I can't understand right meaning of UNCOMMITTED READ isolation level or there is a problem some where else.
Any suggestion or reference to deal with this problem?
I use ArcGIS Desktop 10.2 for working with data and use ArcSDE 9.3 to create and register geodatabase.