In this article I am going to explain Model First
Approach in MVC using Entity Framework.
First question comes in our mind what is Entity Framework?
The Microsoft ADO.NET
Entity Framework is an Object/Relational Mapping (ORM) framework that enables
developers to work with relational data as domain-specific objects, eliminating
the need for most of the data access plumbing code that developers usually need
to write.
Below
Image will explain Entity Framework architecture.
Image 1.
What is O/RM?
ORM is a tool for
storing data from domain objects to relational database like MS SQL Server, in
an automated way, without much programming. O/RM includes three main parts:
Domain class objects, Relational database objects and Mapping information on
how domain objects map to relational database objects (tables, views & Stored
Procedures). ORM allows us to keep our database design separate from our domain
class design.
Now we will learn Model First Approach Step By Step.
Model first is the domain
modelling approach in Entity Framework. It enables you to create model's
Entities, relationships, and inheritance hierarchies on the design surface of
empty model (.edmx file) by using entity designer and then create database from
it.
Now Open
Visual Studio -> File -> New -> Project.
Image 2.
Image 3.
Now Right
Click On Model Folder -> Add New ADO.NET Entity Data Model.
Image 4.
Image 5.
Select Here
Empty Model.
Image 6.
Now Right
Click -> Add-> Entity.
Image 7.
Give Name,
Select Data Type & Set Key.
Image 8.
Click ok.
Image 9.
Now Add More
Column to your Entity.
Image 10.
It Will Add
New Property or Column to your entity. Now you can set Data type and other
properties of this newly added column like below.
Image 11.
Now Add all
column (Properties) which you want. After this our ADO.NET Entity Data Model
Will look like.
Image 12.
Now time to
generate Data Base from This Model. So Right click in your edmx like below.
Image 13.
Image 14.
This will
give below Message -> Click Yes.
Image 15.
This will
show connection string in next step like below.
Image 16.
Click Next
-> This will generate DB Script.
Image 17.
Image 18.
Image 19.
After Command
executed successfully check your Data Base.
Image 20.
Now generate
class. So Right Click on Models-> School.edmx ->School.tt
->RunCustomTool
Image 21.
Image 22.
Now time to
perform CRUD operations. So right click on Controller -> Add ->
Controller.
Image 23.
It will create CRUD
Views also like below.
Image 24.
Now Run Your
Application.
Add New
Student.
Image 25.
Showing All
Students Records.
Image 26.
Edit any
student record.
Image 27.
Showing
Details of Student.
Image 28.
Delete any
student Record.
Image 29.
Now see your
Data Base.
Image 30.