search

fmwviormv / sqlite-net

Automatically exported from code.google.com/p/sqlite-net
0 stars 0 forks source link

LINQ Support for ToLower #49

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
            var query = await db.Table<Patient>()
                .Where(p => (p.Name.ToLower()
                .Contains(queryText)))
                .OrderBy(p => p.Name).ToListAsync();

p.Name is a string property.

What is the expected output? What do you see instead?
The application crashes with an SQLiteException: no such function: tolower

What version of the product are you using? On what operating system?
SQLite for Windows Runtime version 3.7.16.1
sqlite-net version 1.0.7
Windows 8

Please provide any additional information below.

Original issue reported on code.google.com by SerhiyPo...@gmail.com on 4 Apr 2013 at 9:38

GoogleCodeExporter commented 9 years ago 
hi, did you find resolution to this issue?

Original comment by wmerifi...@gmail.com on 24 Jun 2013 at 6:58