How to SQLite Query with constraint in xamarin forms cross platform C#?
<p>I am working on this pet project in Xamarin.Forms cross platform. I am having difficulty running a query in SQLite using constraint.  I am able to list all the elements stored on the table. However, I am unable to query the table for all the jobs with the same AccountNumber. I've searched everywhere but i can't find the answer. Can anyone provide a working method that would help please and thank you in advance.</p>

<pre><code>public SearchPage()
{
        InitializeComponent();

        _connection = DependencyService.Get&lt;ISQLiteDb&gt;   ().GetConnection();
}

private SQLiteAsyncConnection _connection;
private ObservableCollection&lt;Job&gt; _jobs;

public class NewJobTable
{
    [PrimaryKey]
    public string JobID { get; set; }

    public long AccountNumber { get; set; }
    public int JobNumber { get; set; }
    public DateTime DateCompleted { get; set; }
}

protected override async void OnAppearing()
{
    await _connection.CreateTableAsync&lt;Job&gt;();

    var jobs = await _connection.Table&lt;Job&gt;().ToListAsync();

    _jobs = new ObservableCollection&lt;Job&gt;(jobs);

    JobListView.ItemsSource = _jobs;

    base.OnAppearing();
}
</code></pre>