# Is the SQLiteFeatureLayer like the MsSql2008FeatureLayer

**URL:** <https://community.thinkgeo.com/t/is-the-sqlitefeaturelayer-like-the-mssql2008featurelayer/8145>\
**Category:** WPF\
**Created:** [August 1, 2016, 5:44pm UTC](https://community.thinkgeo.com/t/is-the-sqlitefeaturelayer-like-the-mssql2008featurelayer/8145 "2016-08-01T17:44:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Clay](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/c/65b543/32.png) [@Clay](https://community.thinkgeo.com/u/Clay)\
**Post date:** [August 1, 2016, 5:44pm UTC](https://community.thinkgeo.com/t/is-the-sqlitefeaturelayer-like-the-mssql2008featurelayer/8145/1 "2016-08-01T17:44:33Z")

</div>

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.

 ![](https://community.thinkgeo.com/uploads/default/original/3X/8/e/8e8fc703716f04dd5f5db85c3abc04efea28a1af.png)

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

---

<div class="post-metadata">

**Author:** ![Ethan](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/ethan/32/19964_2.png) [@Ethan](https://community.thinkgeo.com/u/Ethan)\
**Post date:** [August 2, 2016, 2:28am UTC](https://community.thinkgeo.com/t/is-the-sqlitefeaturelayer-like-the-mssql2008featurelayer/8145/2 "2016-08-02T02:28:42Z")

</div>

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](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