In This Session I am going to describe Insert, Update, Delete operation in MVC-4 with Entity Framework.
Here I am using visual stdio 2012 (framework 4.5) , SQL server 2012 express and Entity Framework
So Lets start
Step -1
Create 'Employee' Table in Database
Step -2
Open visual stdio 2012 and Create New Project. Select Asp.net MVC 4 web Application. Now Select Razor view and click OK Button.
Step -3
Go to Solution Explorer and right click on Modal Folder and Add New item Select ADO.Net Entity Data Modal.
Step -4
Select EF Designer from database and click on next button.
Step -5
Click on New Connection button if there is no already connection It will open Connection Windows
Step -6
Here just select Data Source, SQL server name and database to want to connect . here my database is Demodatabase and table name is employee table to connect and click on OK button
Here I am using visual stdio 2012 (framework 4.5) , SQL server 2012 express and Entity Framework
So Lets start
Step -1
Create 'Employee' Table in Database
Step -2
Open visual stdio 2012 and Create New Project. Select Asp.net MVC 4 web Application. Now Select Razor view and click OK Button.
Step -3
Go to Solution Explorer and right click on Modal Folder and Add New item Select ADO.Net Entity Data Modal.
Step -4
Select EF Designer from database and click on next button.
Step -5
Click on New Connection button if there is no already connection It will open Connection Windows
Step -6
Here just select Data Source, SQL server name and database to want to connect . here my database is Demodatabase and table name is employee table to connect and click on OK button
Step -6
Select Employee table checkbox and click on Next Button . you can change the modal namespace as your required
Step -7
Here Entity framework create a Employee table Modal and its Generated all code and designer and connection string. Now just build the Application .
After successfully build the Application . Go to solution Explorer and right click
Controller folder
and go to the Add New controller
Step-9
Here I am going to create a
Employee controller so
I put Employee as controller name and in Template Select "MVC Controller with read write action and vies, using Framework" option and put the Data context class from drop down and select modal class from drop down. and click on add button.
It Will automatically generate all the code for add , edit and delete Operation in Controller class. And It also generate view for Add ,Edit, Delete in View folder. Now Build the application And Run It.
Step-11
Before run the application just change the RouterConfig.cs Class, The Controller default name is 'Home' and you have to change it 'Employee'.because our controller name is
Employee
Output will show like this
No comments:
Post a Comment
Thank you for comment