Is the SQLiteFeatureLayer like the MsSql2008FeatureLayer

ThinkGeo UI for Desktop WPF
1

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.

2016-08-01_13h46_38.png482×283 5.51 KB

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

2

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