CODEWITHSUNDEEP
c#sqlitelinq-to-sqllinq-to-entitieswindows-store-apps
Evox
Evox

Reputation: 112

How to use Methods in SqLite Linq Query?

I want use the Tolower string function in linq query, but when the app is running, the lnq search the function in sqlite.

Error:

Additional information: no such function: tolower

Code:

 var data = conn.Table<_table>().Where(x=> x.name.ToLower() == param).ToList();

How can i use non sqlite functions in linq query ?

Thx for any help !

Upvotes: 3

Views: 318

Answers (1)

Khan
Khan

Reputation: 18152

An option would be to make the column you're doing the comparison on case insensitive. Then you would no longer need to use ToLower to compare your strings since it is ultimately translating your linq to a sql statement.

CREATE TABLE MyTable 
(
    name text collate nocase
);

Upvotes: 2

Related Questions