ThinkGeo.com    |     Documentation    |     Premium Support

Is the SQLiteFeatureLayer like the MsSql2008FeatureLayer

I’m trying to load the features out of a table in SQLite like I do with a view in SQL Server. To do this I"m using SqliteFeatureLayer(ConnectionString, TableName, FeatureIdColumn, GeometryColumnName). When I load the layer on the map, it starts throwing errors about how it can’t find the column name. I’ve verified that the columns exist, but I am receiving this error when I refresh the map.

Does this not work the same as MsSql2008FeatureLayer(ConnectionString, TableName, FeatureIdColumn)?

Hi Clay,

From your exception screen shot, it looks that’s because your database don’t contains a specified index table, but not columns. So please make sure your database already contains all the index tables.

You can view our sample here: http://wiki.thinkgeo.com/wiki/map_suite_wpf_desktop_edition_all_samples#shapefile_to_sqlite_convertion_tool

Which can create a sqlite database based on your shape files, then you can try to render it by SqliteFeatureLayer.

Regards,

Don