wpf datagrid combo box binding to database

Question

I want my DataGrid have ComboBox with default value for example I have a column for Genre:

1. Action
2. Drama
3. Comedy

I Want ComboBox Show those data and then select the item in database (for example in database Genre is Drama.

1. I use WPF Net 6 with EF Sqlite for manage Database.

2. in Database Class I set Genre as string.

3. DataGrid of other Column I use Something like this:

    <DataGridTextColumn Header="ID" Binding="{Binding Path=ID,UpdateSourceTrigger=PropertyChanged}"/>
   

4. in Code Behind: DgTest.ItemsSource=db.Test.ToList();

Answer 1

This is how i fix my problem. same as Firo but in simple way.

My Model for Genre:

public int ID {get; set;}
public string? Title {get; set;}

my Repository:

Create A list of Genre and then Return it

My View-Model

public ObservableCollection<Genre> AllGenreList => new (_repository.GetAllGenre())
private Genre _genre;
public Genre SelectedGenre{get=> _genre; set{ _genre=value; ONotifyPropertyChanged(nameof(Genre);}

and then Bind AllGenreList to ComboBox.

<ComboBox ItemsSource="{Binding AllGenreList }" SelectedItem="{Binding SelectedGenre}"/>

this is how i fix my problem. hope solve some one else problem.