How to Order By Descending with SQLite.NET? OrderByDescending() gives me error: "Order By does not support: xx => Convert(xx).ID"
No answers?
Ok, well this is what I'm doing as a work around:
public static IEnumerable<PanelLog> GetPanelLogsDescendingSql(params object[] args){ return me.db.Query<PanelLog>("select * from PanelLog ORDER BY ID DESC"); }
return Table<T>().Select(i => i).OrderByDescending(xx => xx.ID).ToList();
or
return me.db.Query<PanelLog>("select * from PanelLog ORDER BY ID DESC");
Works for me.