CRUD Operation In Entity Framework With MVC - Part 1

After creating a table you can now see table structure as in the following figure 1.3.


Figure 1.3

Adding Database in MVC Application

For adding database entities right click Models Folder. See context menu and Add New Items. Every table create individual classes. You can add .edmx project in any folder.


Figure 1.4
Add New Item window will open. You can select ADO.Net Entity Data Model and enter name. Please enter name CRMX,edmx and click Add button


Figure 1.5

After clicking add button open Entity Data Model Wizard window. You can select Generate from database and click Next button as in the following figure 1.6:


Figure 1.6

After clicking Next open a new winodw to select connection. Click New Connection as in the following figure 1.7 or already available connection and then select dropdown list.


Figure 1.7

After clicking New Connection open windows Connection Properties and you can add Data Source and Server Name. Select Authentication Type Windows or SQL Server. Select database name already created in SQL Server. Here's figure 1.8:


Figure 1.8

Check connection as in the following figure 1.9. If connection is successful then alert message is successful, else failed. Click OK button.


Figure 1.9

After clicking OK button connection name and connection string display in window. Also, you can enter entities name. Click Next as in the following figure 1.10.


Figure 1.10

You can add the following object: Tables, Views, Stored Procedures and Functions. You need to select object and click Finish as in the following figure 1.11.


Figure 1.11



Figure 1.12