Using CRUD Operation In ASP.NET MVC 4.5 Framework

Step 1: Open Visual Studio and click File=> New=> Project.

Step 2: Now, select ASP.NET Web Application .Here, our project name will be “BookManagement “.

Step 3: Here, select MVC Template and click OK button.

Step 4: Right click on App_Data and Select Add => New Item.

Step 5: In the following figure, give a database name. Here, my database name is “BookDatabase”.

Step 6: After creating a database, you will create a table for it.

Step 7: Now, click on Server Explorer at the left side of the Window, select BookDatabase.Mdf. Afterwards, right click Tables, Add New Table.

Step 8: I need to create some data field name and define its data type. After creating a data field name, you will click Update button. I have given the name of table “Mybook”.

Step 9: As given in the figure, you will click Update Database button.

Step 10: Now, I need to create a model Class. Right click on the models folder and click Add. Click Class to add a class.

Step 11: Again, select Class template and give it a name. I have given the name of Class “Mybook”.

Click add button.

Thus, our model class has been created. There are six properties in the class. Here, I am using validation. I need to add “using System.ComponentModel.DataAnnotations;” namespace for the validation.

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Web;
namespace BookManagmentMVC.Models
{
public class MyBook {
public int Id {
get;
set;
}
[Required(ErrorMessage = "Please Enter BookName")]
public string BookName {
get;
set;
}
[Required(ErrorMessage = "Please Enter AuthorName")]
public string AuthorName {
get;
set;
}
[Required(ErrorMessage = "Please Enter Price")]
public int BookPrice {
get;
set;
}
[Required(ErrorMessage = "Please Enter Bookpublish")]
public string BookPublish {
get;
set;
}
[Required(ErrorMessage = "Please Enter Comments")]
public string Comments {
get;
set;
}
}
}

Step 12: You need to create a controller with the views, using Entity Framework. Add new Scaffold in the project.

Step 13: Now, choose MVC 5 Controller, using Entity framework.

Click Add button.

Step 14: In case of error, you will be building the project and again Add Controller.

Step 15: Finally, the controller was created by automatic CRUD operations. It is very simple to perform CRUD operations.

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Entity;
using System.Linq;
using System.Threading.Tasks;
using System.Net;
using System.Web;
using System.Web.Mvc;
namespace BookManagmentMVC.Models
{
public class MyBooksController: Controller {
private BookManagmentMVCContext db = new BookManagmentMVCContext();
// GET: MyBooks
public async Task < ActionResult > Index() {
return View(await db.MyBooks.ToListAsync());
}
// GET: MyBooks/Details/5
public async Task < ActionResult > Details(int ? id) {
if (id == null) {
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
MyBook myBook = await db.MyBooks.FindAsync(id);
if (myBook == null) {
return HttpNotFound();
}
return View(myBook);
}
// GET: MyBooks/Create
public ActionResult Create() {
return View();
}
// POST: MyBooks/Create
// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see http://go.microsoft.com/fwlink/?LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task < ActionResult > Create([Bind(Include = "Id,BookName,AuthorName,BookPrice,BookPublish,Comments")] MyBook myBook) {
if (ModelState.IsValid) {
db.MyBooks.Add(myBook);
await db.SaveChangesAsync();
return RedirectToAction("Index");
}
return View(myBook);
}
// GET: MyBooks/Edit/5
public async Task < ActionResult > Edit(int ? id) {
if (id == null) {
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
MyBook myBook = await db.MyBooks.FindAsync(id);
if (myBook == null) {
return HttpNotFound();
}
return View(myBook);
}
// POST: MyBooks/Edit/5
// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see http://go.microsoft.com/fwlink/?LinkId=317598.
[HttpPost]
[ValidateAntiForgeryToken]
public async Task < ActionResult > Edit([Bind(Include = "Id,BookName,AuthorName,BookPrice,BookPublish,Comments")] MyBook myBook) {
if (ModelState.IsValid) {
db.Entry(myBook).State = EntityState.Modified;
await db.SaveChangesAsync();
return RedirectToAction("Index");
}
return View(myBook);
}
// GET: MyBooks/Delete/5
public async Task < ActionResult > Delete(int ? id) {
if (id == null) {
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
MyBook myBook = await db.MyBooks.FindAsync(id);
if (myBook == null) {
return HttpNotFound();
}
return View(myBook);
}
// POST: MyBooks/Delete/5
[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public async Task < ActionResult > DeleteConfirmed(int id) {
MyBook myBook = await db.MyBooks.FindAsync(id);
db.MyBooks.Remove(myBook);
await db.SaveChangesAsync();
return RedirectToAction("Index");
}
protected override void Dispose(bool disposing) {
if (disposing) {
db.Dispose();
}
base.Dispose(disposing);
}
}
}

Step 16: You can see, here the views are automatically created.

Here is the output:

Here, click Create button. You will find all the validations are working.

In the screenshot, you will get all the information successfully inserted. If you need to Delete or Edit, you will go to the link button on Delete and Edit modify.

11 Comments

Join the conversation! Your thoughts help the community grow.

Kalyani Shinde8y ago
Very helpful article and very ggod
Avinash Thakur10y ago
Thanks Gagan Sharma
Gagan Sharma10y ago
Very helpful to learn
Subash10y ago
Nice
Avinash Thakur10y ago
Thanks
Amit Mishra10y ago
Good one.......
Bhavik Patel10y ago
Nice
Pankaj Kumar Choudhary10y ago
Nice Example of EntityFramework with MVC..
- Avinash Thakur10y ago
  Thanks sir
kalu singh rao10y ago
Nice Starting
Vignesh Mani10y ago
Good start