Database First Approach in Entity Framework Step by Step

Piyush Dixit

11y11.9k20100Article

20 Comments

Join the conversation! Your thoughts help the community grow.

Subash10y ago
Good one
Yashwanth Muthineni11y ago
Nice Share
Santhakumar Munuswamy11y ago
Welcome
Santhakumar Munuswamy11y ago
Good Start
- Piyush Dixit11y ago
  thank you so much for appreciating me
Rahul Prajapat11y ago
Nice article and Welcome
- Piyush Dixit11y ago
  thanks
Gopi Chand11y ago
Well done and welcome :)
- Piyush Dixit11y ago
  thank you so much for appreciating me
Nilesh Jadav11y ago
Great Article sir
Sibeesh Venu11y ago
Nice Share. Thank you.
Mohammed Ibrahim11y ago
nice
Gowtham K11y ago
Good one
Khargesh Rajput11y ago
thnx to share
Karthikeyan K11y ago
Thanks for share...
Ankit Bansal11y ago
thanks for share...
Sumit Joshi11y ago
thanks for share.
Rajeesh Menoth11y ago
Nice Share
Vaikesh K P11y ago
Good
- Piyush Dixit11y ago
  thanks Vaikesh K P

Introduction

Entity Framework is an Object Relational Mapper. What is meant of Object Relational Mapper (ORM)?

It's means in simple words:

If you want to use RDBMS tables as classes, the table's attributes as properties and its procedures as methods in C# applications then it will map all the relational database objects into C# objects like properties and methods.
If you want to create a table from C# code in SQL Server and work on it then it generates the required SQL scripts for creating database objects.

SO ORM works to map C# code in a SQL Server sript for creating the database and table and vice versa the RDBMS table to C# objects.

Step 1

Create a database and tables.

CREATE DATABASE ENTITYDB
GO
USE ENTITYDB
GO
CREATE TABLE tblStudent
(
ID INT PRIMARY KEY IDENTITY(1,1),
NAME VARCHAR(50),
GENDER VARCHAR(10),
AGE INT,
COURSE VARCHAR(50)
)
GO
INSERT INTO tblStudent VALUES('MACK','MALE',20,'BCA'),('JACK','MALE',24,'MCA'),('RIYA','FEMALE',21,'BCA'),('TOM','MALE',23,'MCS')

Step 2

Now add a project and choose console application.

Step 3

Now go to Add New item -> ADO.NET Entity Data Model and provide an appropriate name.

Step 4

Step 5

Now fill in the required information as in the following:

Step 6

Now choose new connection and add your databse. Here there are the following two checkboxes.

The first checkbox tells you "Do you want to exclude sensitive data like your password from connectionstring if you check it then it exclude your sensitive data from configuration file".
The second checkbox tells you "Do you want to include sensitive data like your password in connectionstring if you check it then it incclude your sensitive data in configuration file".

Step 7

Now go and choose your table. I selected tblStudent from the table list.

table

Step 8

After finishing a model has been created like this.

model

Basically when you finish the entity wizard then add a System.Data.Entity DLL is in your references. It's the base for working with Entity Framework.

And one Context class has been added to your edmx file. If you follow me then you go to "StudentModel.edmx" -> "StudentModel.Designer.cs" and look for "ENTITYDBEntities".

"ENTITYDBEntities" is the context class for this edmx file.

Step 9

Now write the following code in the console application.

using System;
using System.Linq;
namespace LearnEFStepbyStep
{
class Program
{
static void Main(string[] args)
{
using (ENTITYDBEntities cx = new ENTITYDBEntities())
{
var students=cx.tblStudents.ToList();
foreach (var student in students)
{
Console.WriteLine("StudentID : "+student.ID+" Student Name : "+student.NAME+" Gender : "+student.GENDER+" Age : "+student.AGE+" Course : "+student.COURSE);
}
Console.ReadKey();
}
}
}
}

Step 10

Now run it.

output

Conclusion

Here, I am trying to simplify all the terms related to Entity Framework in a very easy way.