thanks for your reply.
as a new user, i am a little confused.
I am doing the following to get a list of type category:
public AssetCategory GetAllParentCategories()
return m_store.Select<AssetCategory>(c => c.ParentID.Equals(0)).ToArray();
and it is working nicely as is. But one of the fields is CategoryName, and I would like my list to be in sort order by Category Name.
Where wouuld i specify the linq command to do that? Your select command does not seem to have a field to order by in your class definition.
I am doing this using SQLite, and there are about 100 records to retrieve.
I want to do this efficiently.