LINQ in SQLite for Windows store app does not have 'ThenBy' to order by multiple columns
- by user1131657
I have a Windows 8 store application and I'm using the latest version on SQLite for my database.
So I want to return some records from the database and I want to order them by more that one column. However SQLite doesn't seem to have the ThenBy statement? So my LINQ statement is below:
from i in connection.Table<MyTable>()
where i.Type == type
orderby i.Usage_Counter
// ThenBy i.ID
select i);
So how do I sort by multiple columns in SQLite without doing another LINQ statement?
