Work With Entity Framework To Perform CRUD Operation

Create Entity framework file

Go to Visual Studio and create windows form application and click on OK as in the following figure 1:


Figure 1

Go to solution explorer, select the solution click with right mouse button and then click Add. Click on New Item as in the following figure 2:


Figure 2

Select Data from Visual C# item in installed template. Select ADO .NET Entity Data Model, type the model name within parenthesis Model1.edmx, click on Add as in the following figure 3:


Figure 3

Select Generate from database option click on next as in the following figure 4:


Figure 4

Click on New Connection, type the server name, select the radio button and use the windows authentication (also we can use SQL Server authentication). Select the database name within parenthesis and check the Save Connection setting in App.Configure and click on Finish as shown in Figure 5.


Figure 5

Now choose database objects in Entity Data Model Wizard. And select Table which we would like to display then click on Finish. As shown in Figure 6.


Figure 6

Design the form as in the following figure 7.


Figure 7

Write the following code,