I was wondering if there are any samples for interacting with SQLite/spatialite with c#. I understand how to use the filegdbworkspacefactory that allows me to specify a file to create a workspace, and then from there I can get to the feature classes. I do not see any workspace factories that seem to support SQLite and Spatialite. In this case, I need to manipulate several feature classes and geoprocessing functions. I know how to create the database both in c# ado.net code and arcpy createsqlitedatabase. But no such luck on accessing the feature classes. In the past, it was simple with the workspace factories, but I need to know how to do it with the SQLite database engine. Any help or suggestions or links to a code snippet would be appreciated.
here's some code that I use in Delphi which might help. There are limitations with using SQLITE in ArcMap.
SqliteSource is the full file path.
pWrkspcFact : IWorkspaceFactory ;
pFtrWrkspc : IFeatureWorkspace ;
pDataset : IDataset ;
pWrkspcFact := CoSqlWorkspaceFactory.Create as IWorkspacefactory ;
pFtrWrkspc := pWrkspcFact.OpenFromFile ( SqliteSource , 0 ) as IFeatureWorkspace ;
pDataset := pFtrWrkspc.OpenTable ( 'Location' ) as IDataset ;