MVC CRUD Operations Using Entity Framework

Introduction

In this article I am going to talk about MVC CRUD Operations Using Entity Framework 6 without writing any code. First, you should learn about MVC and the basics of Entity Framework.

• The View is responsible for the look and feel.
• Model represents the real world object and provides data to the View.
• The Controller is responsible for taking the end user's request and loading the appropriate Model and View.
• Download Sample

Building the Sample

Step 1

Create sample employee SQL table:

Step 2

Open Visual studio -> Create New Project Asp.net WebApplication with MVC:

Step 3

Right Click on the Project and go to Manage NuGet Packages..

Step 4

Click on the browse button then find entity framework. In this article I have selected framework 6:

Step 5

Right Click on the project -> go to Add -> New Item - >Select ADO.NET Entity Data Model. Give model name.

Step 6

Click on the New Connection -> Select Data Source as Microsoft SQL Server

Step 7

Choose Server Name & Database Name then click OK

Step 8

By default connection string will be generated -> Select Table Data

Step 9

Add new controller with the name "Employee"

Step 10

Select Model Class and Data Context cClass from combo box. Select Generate View Checkbox and give controller a name.

Step 11

Change default "Home" controller to "Employees" and hit F5 to run the sample.

Step 12

Without writing a single of code the application is created with CRUD views.