Grouping DataGrid based on two Entity Framework tables

Question

Hi All.
The Form1 has DataGrid populated from EF table Table1. From Form1 I call Form2 that also has DataGrid with multiple selected items and populated from EF Table2 which is related to Table1. When I selected items in Form2 and click save button the data will save in Table2. Now I would grouping DataGrid in Form1 based on source of Table1 and Table2. Something like this:

Where Department value from Table2 the rest from Table1. If that is passible. How to it do? I will appreciate for sample and detail explanation.

Thanks.

Answer 1

Hi DaisyTian-MSFT. Thanks for reply.
Both table related by ID field. Table1 has primary key Table1_ID and Table2 has primary key Table2_ID, foreign key Table1_ID. To populate the grouping DataGrid, I'm thinking, your idea is good to create class which include fields from both tables.

Thanks.