ADO.NET ENTITY FRAMEWORK WITH PARENT CHILD TABLE USING CONSOLE APPLICATION

   Generating Model from Database

File->New project

·        In the Solution Explorer right-click on the project and choose Add | New Item.

·        In the dialog choose ADO.NET Entity Data Model, click Add. This launches Entity Data Model Wizard.

And click on add

·        In the wizard choose Generate from database, click next.

     

    Click on New Connection.

Click on OK Button.

Click on Next Button. 

Select the tables and click on finish.

Go to Program.cs and write the following code 

Output