Database First Approach

In Database First Approach first we create database and then we will create designer and code file using this database.

Database Detail


		
create database techaltum_ef

use techaltum_ef

create table student(stu_id int primary key identity(1,1), stu_name varchar(100), age int, course varchar(100))

 	

For Example

First of all open the visual studio->new->Website->Empty Website

Now go to add new item and add Ado.net Entity Data Model


		
db approach in ef

		Figure 1
		


Click on add button and you will get following window

In code first we create code file first and then if database not exist then database will be created automatically at runtime using this code.


		
add db approach in ef

		Figure 2
		

As we have already database created so we will select Generate from Database. Later on we will discuss on Empty Model and Code first approach.

Now click on Next button and in the following window click on New Connection and you will get following window where add your connection of database and click on ok button.


		
add db approach in ef step 3

		Figure 3
		


As you click on ok button you will get the following window


		
add db approach in ef step 4

		Figure 4
		

As you can see this window, in which its showing that by which name our connection string will be stored in Web Config file. Later on we can also change this connection string.

Now click on Next button you will get the following window


		
add db approach in ef step 5

		Figure 5
		

Now select tables from your database which you want to use in your project. You can also select View and Stored procedure for the use. In my next articles series I will discuss how we can work with Views and Stored Procedure.

As you can see that it has created a namespace techaltum_efModel in which our classes will be added. We can also change the specific name according to our project or can leave it as it is.

Now click on Finish Button you will get your entity framework classes and designer in your solution explorer




		
add db approach in ef step 6

		Figure 6
		

As you can see in your solution explorer it will simply added techaltum.edmx. edmx is the extension of entity framework which means Entity Data Model Xml. In my next article first we will discuss about this file.