create table project_management.projects
(
		 project_id   int not null identity(1, 1) primary key
		,project_priority   int not null
		,project_name   varchar(255) not null
		,project_description   varchar(max) null
		,project_client   varchar(255) null
		,project_from_date   date null
		,project_to_date   date null
		,project_status   varchar(255) not null default 'Ожидает'
)

create table project_management.tasks
(
		 project_id   int not null
		,task_id   int not null identity(1, 1) primary key
		,task_priority   int not null
		,task_name   varchar(255) not null
		,task_description   varchar(max) null
		,task_from_plan_date   date null
		,task_to_plan_date   date null
		,task_from_fact_date   date null
		,task_to_fact_date   date null		
		,task_responsible   varchar(255) null
		,task_status   varchar(255)	not null default 'Ожидает'
		
		FOREIGN KEY (project_id)  REFERENCES project_management.projects (project_id)
)

 
    public partial class projects
    {
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
        public projects()
        {
            this.tasks = new HashSet<tasks>();
        }
    
        public int project_id { get; set; }
        public int project_priority { get; set; }
        public string project_name { get; set; }
        public string project_description { get; set; }
        public string project_client { get; set; }
        public Nullable<System.DateTime> project_from_date { get; set; }
        public Nullable<System.DateTime> project_to_date { get; set; }
        public string project_status { get; set; }
    
        [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
        public virtual ICollection<tasks> tasks { get; set; }
    }


    public partial class tasks
    {
        public int project_id { get; set; }
        public int task_id { get; set; }
        public int task_priority { get; set; }
        public string task_name { get; set; }
        public string task_description { get; set; }
        public Nullable<System.DateTime> task_from_plan_date { get; set; }
        public Nullable<System.DateTime> task_to_plan_date { get; set; }
        public Nullable<System.DateTime> task_from_fact_date { get; set; }
        public Nullable<System.DateTime> task_to_fact_date { get; set; }
        public string task_responsible { get; set; }
        public string task_status { get; set; }
    
        public virtual projects projects { get; set; }
    }

<DataGrid DockPanel.Dock="Top" x:Name="testEF" AutoGenerateColumns="False">

            <DataGrid.Columns>
                
                <DataGridTextColumn Binding="{Binding project_id}"          Header="project id" Width="50" IsReadOnly="True" />
                <DataGridTextColumn Binding="{Binding project_priority}"    Header="priority"   Width="50" IsReadOnly="True" />
                <DataGridTextColumn Binding="{Binding project_name}"        Header="Название"   Width="*" />
                <DataGridTextColumn Binding="{Binding project_client}"      Header="Заказчик"   Width="*" />
                
                <DataGridTemplateColumn Header="Срок от" Width="100">
                    <DataGridTemplateColumn.CellTemplate >
                        <DataTemplate>
                            <DatePicker SelectedDate="{Binding Path=project_from_date}"/>
                        </DataTemplate>
                    </DataGridTemplateColumn.CellTemplate>
                </DataGridTemplateColumn>
                
                <DataGridTemplateColumn Header="Срок до" Width="100">
                        <DataGridTemplateColumn.CellTemplate>
                        <DataTemplate>
                            <DatePicker SelectedDate="{Binding Path=project_to_date}"/>
                        </DataTemplate>
                    </DataGridTemplateColumn.CellTemplate>
                </DataGridTemplateColumn>

                <DataGridTextColumn Binding="{Binding project_to_date}"      Header="Срок до"     Width="100" />
                
                <DataGridTemplateColumn Header="Статус" Width="90">
                    <DataGridTemplateColumn.CellTemplate>
                        <DataTemplate>
                            <ComboBox SelectedValuePath="{Binding project_status}">
                                <ComboBoxItem IsSelected="True">Ожидает</ComboBoxItem>
                                <ComboBoxItem>Работаем</ComboBoxItem>
                                <ComboBoxItem>Завершен</ComboBoxItem>
                                <ComboBoxItem>Не делаем</ComboBoxItem>
                            </ComboBox>
                        </DataTemplate>
                    </DataGridTemplateColumn.CellTemplate>
                </DataGridTemplateColumn>


                <DataGridTextColumn Binding="{Binding project_status}"      Header="Статус"     Width="90" />

            </DataGrid.Columns>
            <DataGrid.RowDetailsTemplate >
               
                <DataTemplate>
                    <DataGrid AutoGenerateColumns="False">
                        <DataGrid.Columns>
                            <DataGridTextColumn Binding="{Binding project_description}"      Header="Заказчик"   Width="2000" />

                        </DataGrid.Columns>
                        <DataGrid.RowDetailsTemplate>
                            <DataTemplate>

                                <DataGrid AutoGenerateColumns="False" Name="grid_level_2" >
                                    <DataGridTextColumn Binding="{Binding task_id}"          Header="project id" Width="50" IsReadOnly="True" />
                                    <DataGridTextColumn Binding="{Binding task_priority}"    Header="priority"   Width="50" IsReadOnly="True" />

                                </DataGrid>
                            </DataTemplate>
                        </DataGrid.RowDetailsTemplate>
                    </DataGrid>
                </DataTemplate>
            </DataGrid.RowDetailsTemplate>
            
        </DataGrid>

            monitoring_EF monitoring_EF = new monitoring_EF();

            testEF.ItemsSource = monitoring_EF.projects.ToList();