开发者

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")

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜