How to SQLite Query with constraint in xamarin forms cross platform C#?

Question

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.

public SearchPage()
{
        InitializeComponent();

        _connection = DependencyService.Get<ISQLiteDb>   ().GetConnection();
}

private SQLiteAsyncConnection _connection;
private ObservableCollection<Job> _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<Job>();

    var jobs = await _connection.Table<Job>().ToListAsync();

    _jobs = new ObservableCollection<Job>(jobs);

    JobListView.ItemsSource = _jobs;

    base.OnAppearing();
}

Milen · Accepted Answer · 2016-12-22 14:31:33Z

1

Add filering (Where) on AccountNumber

 var jobsWithSameAccountNumber = await _connection.Table<Job>()
                                  .Where(job => job.AccountNumber == accountNumberToCheck)
                                  .ToListAsync()

answered Dec 22, 2016 at 14:31

Milen

8,8977 gold badges47 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sykotiix Over a year ago

Worked like a charm. Thank you so much Milen

Collectives™ on Stack Overflow

How to SQLite Query with constraint in xamarin forms cross platform C#?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related