Xamarin Forms Picker Binding

First, there are some mistakes in your code.

1.When you go through the loop (the data you gained from db), options is always updated with new data(so it generates using last object), and you set it to BindingContext. You should set a modelView here rather a model.

2.The itemSource of Picker must be a list, however you set a model here.

3.The viewmodel must implement INotifyPropertyChanged to notify the changes.

I think what you need understanding most is not this Picker , it is How to work with binding.

Bindable Properties

Data Binding Basics

From Data Bindings to MVVM

Okay, let us come back to this case. What you need is here

I simplified the demo and you can refer to it.

• XAML

  <Picker x:Name="picker" 
          Title="Select Job" 
          ItemsSource="{Binding JobList}"
          ItemDisplayBinding="{Binding Name}"
          SelectedItem="{Binding SelectedJob}"/>
  
  <Label Text="{Binding SelectedJob.JobsId}" IsVisible="True" x:Name="TxtId" Margin="0,100,0,0"/>
  <Label Text="{Binding SelectedJob.Name}" IsVisible="True" x:Name="TxtName"/>
  <Label Text="{Binding SelectedJob.Location}" IsVisible="True" x:Name="TxtLoc"/>
  

• Model and ViewModel:

  public class Jobs
  {
      public string JobsId { get; set; }
      public string Name { get; set; }
      public string Location { get; set; }
  }
  
  public class RootModel : INotifyPropertyChanged
  {
  
      List<Jobs> jobList;
      public List<Jobs> JobList
      {
          get { return jobList; }
          set
          {
              if (jobList != value)
              {
                  jobList = value;
                  OnPropertyChanged();
              }
          }
      }
  
      Jobs selectedJob;
      public Jobs SelectedJob
      {
          get { return selectedJob; }
          set
          {
              if (selectedJob != value)
              {
                  selectedJob = value;
                 OnPropertyChanged();
              }
          }
      }
  
  
      public event PropertyChangedEventHandler PropertyChanged;
  
      protected virtual void OnPropertyChanged([CallerMemberName] string propertyName = null)
      {
          PropertyChangedEventHandler handler = PropertyChanged;
          if (handler != null)
          {
              handler(this, new PropertyChangedEventArgs(propertyName));
          }
      }
  }
  

• Code behind:

   public MainPage()
   {
        InitializeComponent();
  
        this.BindingContext = new RootModel
        {
            JobList = GetJobsInfo()
        };
   }
  
   private List<Jobs> GetJobsInfo()
   {
        var db = _connection.Table<Jobs>();
        return db.ToList();
   }
  

• My Test:

  

XAML:

<Picker x:Name="ListJobs" Title="Select Job" ItemsSource="{Binding AllJobs}"
        ItemDisplayBinding="{Binding Name}" SelectedItem="{Binding SelectedJob}"/>
<Label Text="{Binding SelectedJob.JobId}" IsVisible="True" x:Name="TxtId"/>
<Label Text="{Binding SelectedJob.Name}" IsVisible="True" x:Name="TxtName"/>
<Label Text="{Binding SelectedJob.Location}" IsVisible="True" x:Name="TxtLoc"/>

Model:

public class Job
{
    public string JobId { get; set; }
    public string Name { get; set; }
    public string Location {get; set; }
}

public class JobModel
{
    public List<Job> AllJobs { get; set; }
    public Job SelectedJob { get; set; }
}

Code behind:

protected override OnAppearing()
{
    BindingContext = new JobsModel {
        AllJobs = GetJobs()
    };
}

private List<Jobs> GetJobs()
{
    var db = _connection.Table<Jobs>();
    return db.ToList();
}