LiteDB multiple queries in C#

Question

I am new to LiteDB and would like to execute two or more queries in one go.

I want to be able to search for a certain customer in my DataBase and since there will be multiple customers with a similar name I want return all of them and sort them in Descending (Id or Date) Order. I have both functions improvised but separated, so I'm looking for a way to combine Search and Sort into one Query.

Here is the main search function:

private void search_btn_Click(object sender, RoutedEventArgs e)
    {
        using (var dataBase = new LiteDatabase(dbConnectionString))
        {
            // Stranka = Customer
            var collection = dataBase.GetCollection<Stranka>("stranka");
            // Search for a customer name whom I enter in the searchName_tb
            var query = collection.Find(Query.Where("Ime_Priimek", 
            x => x.AsString.Contains(searchName_tb.Text)));

            // Currently I'm doing everything with ListView, so I clear it
            // to make room for resulting data to be shown
            lvStranke.Items.Clear();

            foreach (var customer in query)
            {                 
                lvStranke.Items.Add(customer);
            }
        }
    }

Here is my version of sorting in descending order when they get loaded/refreshed:

    public void LiteDB_ShowAll()
    {
        using (var dataBase = new LiteDatabase(dbConnectionString))
        {
            var collection = dataBase.GetCollection<Stranka>("stranka");
            lvStranke.Items.Clear();

            var count = collection.Count(Query.All());
            // From last ID to first (Descending)
            for (int i = count; i >= 1; i--)
            {
                lvStranke.Items.Add(collection.FindById(i));
            }               
        }         
    }

Answer 1

Have you looked at the example at the Queries wiki page? It looks like you can use LINQ to sort objects you've got by Find although this would be done on the client-side rather than by the engine itself.

    public void LiteDB_ShowAll()
    {
        using (var dataBase = new LiteDatabase(dbConnectionString))
        {
            var collection = dataBase.GetCollection<Stranka>("stranka");
            lvStranke.Items.Clear();

            foreach(var cust in collection.FindAll().OrderByDescending(x => x.Date)) // or by x.Id
            {
                lvStranke.Items.Add(cust);
            }               
        }         
    }

The important drawback in your LiteDB_ShowAll implementation is not its inefficiency. It is the fact that it expects that Customer objects can never be deleted from the DB and this is often just not true. So you eventually will have "gaps" in your IDs and that will break your code.