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

Popular posts from this blog

jquery - How do you format the date used in the popover widget title of FullCalendar? -

asp.net mvc - SSO between MVCForum and Umbraco7 -

Python Tkinter keyboard using bind -