search

mattleibow / Mono.Data.Sqlite.Orm

A small and light SQLite ORM for use in any .NET project
31 stars 7 forks source link

Implement FTS/virtual tables #4

Open mattleibow opened 12 years ago

mattleibow commented 12 years ago

started in commit: bce2a885ab1bb34222faf7f1fc3ff29870fda4b4

mattleibow commented 12 years ago

added support for:

var count = db.Table<QueryableTable>().Where(x => x.Name.Matches("sqlite")).Count();

which is equivalent of:

var count = db.ExecuteScalar<int>(
    "SELECT COUNT(*) FROM [QueryableTable] WHERE [Name] MATCH ?", 
    "sqlite");

in commit: 13028286ed55f6d3567aa8adebcc56cdd4f8ba95