MonoTouch + SQLite + SQLite.Net ORM: Full Text Indexing MonoTouch + SQLite + SQLite.Net ORM: Full Text Indexing sqlite sqlite

MonoTouch + SQLite + SQLite.Net ORM: Full Text Indexing


I believe that SQLite.NET does not supports creating full text indexes, but supports creating ordinary indexes.

Anyway, you could try to execute any custom SQL-code via:

<YOUR_SUBCLASS_OF_SQLiteConnection>.Execute(<YOUR_SQL_CODE>);

Example:

public class LocalDatabase: SQLiteConnection{    ...    public LocalDatabase (string path) : base(path)    {        ...        Execute("CREATE VIRTUAL TABLE \"MyTable\" USING FTS3 ...");        ...    }           ...}