title: Order by Xamarin request
body: <p>I am a  novice in Xamarin . I looking for a way to do a sqlite request order by , but It is not working.</p>
  
  <p>I want to sort my listview by asc or desc when I click on the button</p>
  
  <p>here is my button:</p>
  
  <pre><code>&lt;Button Text="sort"  WidthRequest="40"  HeightRequest="40" Clicked="OnSort" /&gt;
  </code></pre>
  
  <p>here is my methode :</p>
  
  <pre><code>void OnSort(object sender, EventArgs args)
  {
  
      var words = mywordsdatabase.SortWords();
      listWordsView.ItemsSource = words;
  }
  </code></pre>
  
  <p>Here is my database method : 
  //Sort Worder  </p>
  
  <pre><code>public List&lt;MyWords&gt;  SortWords()
  {
      var myword = (from word in conn.Table&lt;MyWords&gt;()
  
          orderby  word.ID descending
  
          select word );
  
      return myword.ToList();
  }
  </code></pre>