I have a SDE geodatabase in MS SQL Server, where geometries are stored in MS SQL's native geometry types, rather than the ArcSDE Binary.
It seems like it would be relatively easy to create new features in C#, without the use of ArcObjects. I could use one of my favorite Micro-ORMS (Dapper or PetaPoco) in conjunction with the Microsoft.SqlServer.Types
namespace and load features directly into the database without ArcObjects.
I am a novice ArcSDE user, but am quite aware of the rat's nest of stored procedures and other db logic that comes along with ArcSDE, so I am sure its not as easy as I am thinking. I am sure I am not the first person who ever thought about this - so the lack of success stories in this area discourage me a bit.
Has anyone ever done this? Are than any compelling reasons why I shouldn't do this?