Sqlite: How to enable "PRAGMA case_sensitive_like" on WP7
I'm using Sqlite database on Windows Phone 7 platform and want to enable case sensitive searching, to do this I need to call "PRAGMA case_sensitive_like=ON;".
I'm using the Vici CoolSt开发者_如何转开发orage assemblies to execute the queries and I want to execute this statement before the call to RunQuery
.
CSConfig.SetDB(dirDatabaseFile, SqliteOption.None);
results = CSDatabase.RunQuery<PageIndex>(sql).ToList();
How can I do this?
CSDatabase.ExecuteNonQuery("PRAGMA case_sensitive_like=ON")
精彩评论