linq query 'orderby' using multiple fields at SQLite plugin by MvvmCross doesn't work -
the query following:
var query = c in _db.table<contact>() c.firstname.contains("alex") orderby c.priority, c.firstname, c.lastname select c;
is limitation of sqlite, mvvmcross plugin? should go .syntax result?
error cs1936: implementation of `thenby' query expression pattern source type `cirrious.mvvmcross.community.plugins.sqlite.itablequery<contact>' not found (cs1936)
i able handle specifying mutiple orderby methods:
var res = _db.table<contact>() .where(c=> c.....) .orderby(c => c.priority) .orderby(c => c.firstname) .orderby(c => c.lastname) .select(c=> c) .tolist();
translated sqlite query:
select * "contact" ... order "priority", "firstname", "lastname"
hope helped
Comments
Post a Comment