开发者

Sqlite: How to enable "PRAGMA case_sensitive_like" on WP7

开发者 https://www.devze.com 2023-03-09 14:28 出处:网络
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 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

精彩评论

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