Datagridview - how to load values ​​into DataGridViewComboBoxColumn from DB via Nhibernate?

Question

NHibernate

Greetings.
Do not tell me how to load values ​​from the database into the Datagridview, into the DataGridViewComboBoxColumn via Nhibernate?
Initial conditions. There are two tables Recipes and Products.

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
  
  <class name="Dietolog.Domain.Products, Dietolog" table="Products" lazy="true">
    <id name="Id" column="Id">
      <generator class="native">
        <param name="sequence">PRODUCTS_ID_GEN</param>
      </generator>
    </id>
    <property name="Name" column="Name" type="String"/>
    <property name="Cost" column="Cost" type="Double"/>
    <property name="IsPerishable" column="Is_Perishable" type="Boolean"/>
  </class>

</hibernate-mapping>

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">

  <class name="Dietolog.Domain.Recipes , Dietolog" table="Recipes " lazy="true">
    <id name="Id" column="Id">
      <generator class="native">
        <param name="sequence">RECIPES_ID_GEN</param>
      </generator>
    </id>
    <many-to-one name="Product" column="Product_ID"  not-null="true" class="Dietolog.Domain.Products, Dietolog"/>
    <property name="Weight" column="Weight" type="Double"/>
  </class>

</hibernate-mapping>

How can I implement in the Recipes Datagridview, Product column, a drop-down list whose data is loaded from the database, the Products table (Product.Name should be displayed, and Product.ID should be used values)?
How to work with the database through nhibernate is clear, it is not clear how to link two tables into one Datagridview through a drop-down list.

Answer 1

If WPF application, then through DataContext it is possible to specify the list of elements for Combobox.