title: SQLite Database search in Xamarin Forms
body: <p>I have a search bar with list. The list will display all the suggestions from the database. The problem my search query is not working. I am getting zero count. I am not sure  if my query has a correct syntax. </p>
  
  <pre><code>private void NameSearch_SearchButtonPressed(object sender, EventArgs e)
      {
          var keyword = NameSearch.Text;
  
          var db = DependencyService.Get&lt;ISQLiteDB&gt;();
          var conn = db.GetConnection();
  
          var getCaf = conn.QueryAsync&lt;ContactsTable&gt;("SELECT FileAS FROM tblContacts WHERE FileAs LIKE '%?%'", keyword);
          var resultCount = getCaf.Result.Count;
  
          if (resultCount &gt; 0)
          {
              var result = getCaf.Result;
              lstName.ItemsSource = result;
          }
      }
  </code></pre>