{"id":9167,"date":"2021-03-25T17:13:51","date_gmt":"2021-03-25T11:43:51","guid":{"rendered":"https:\/\/www.h2kinfosys.com\/blog\/?p=9167"},"modified":"2024-06-06T19:39:34","modified_gmt":"2024-06-06T14:09:34","slug":"asp-net-mvc-scaffolding","status":"publish","type":"post","link":"https:\/\/www.h2kinfosys.com\/blog\/asp-net-mvc-scaffolding\/","title":{"rendered":"ASP.NET MVC Scaffolding"},"content":{"rendered":"\n

MVC Scaffolding is a feature of ASP.NET that allows you to generate functional code rapidly. It is also known as a code generator framework and is pre-installed in Visual Studio 2013 and a higher version.<\/p>\n\n\n\n

To create a basic CRUD application, scaffolding is the best choice. It reduces time amount and generates clean code. Here, we are using scaffolding to develop a CRUD application<\/a>.<\/p>\n\n\n\n

ASP.NET CRUD Example<\/strong><\/p>\n\n\n\n

This example consists of a couple of steps that are given below.<\/p>\n\n\n\n

    \n
  1. Create New Project<\/li>\n<\/ol>\n\n\n\n

    Select File menu from the menu bar and select New->Project. We can use the shortcut Ctrl+Shift+N also to create a new project.<\/p>\n\n\n\n

    \"MVC<\/figure>\n\n\n\n

    This will pop up a window containing projects. Here, we are selecting ASP.NET Web Application.<\/p>\n\n\n\n

    \"ASP<\/figure>\n\n\n\n

    After clicking on ok, it pops up a new window of templates. Here, we are selecting the MVC template which is used to create an MVC web application.<\/p>\n\n\n\n

    \"MVC<\/figure>\n\n\n\n

    Hit ok, and then it will create a project and also shows a progress bar as shown below.<\/p>\n\n\n\n

    \"ASP<\/figure>\n\n\n\n

    CRUD Project Structure:<\/strong><\/p>\n\n\n\n

    \"MVC<\/figure>\n\n\n\n

    We can run the above application by pressing Ctrl+F5 that will produce a default index page to the browser and looks like the one below.<\/p>\n\n\n\n

    \"ASP<\/figure>\n\n\n\n

    For creating complete crud, we need to add Models, Views, and Controllers in our project. Here, we are going to create a Model that deals with the data.<\/p>\n\n\n\n

    1. Create a New Model<\/p>\n\n\n\n

    We are now creating a Student Model inside the Models folder of our project. Right-click on the Models folder and select add->class that will pop up a dialog box. Create a class by providing a name.<\/p>\n\n\n\n

    \"ASP<\/figure>\n\n\n\n

    This model class has some source code, we can modify its code as given below.<\/p>\n\n\n\n

    \/\/ Student.cs\nusing System;  \nusing System.Collections.Generic;  \nusing System.ComponentModel.DataAnnotations;  \nusing System.Linq;  \nusing System.Web;  \nnamespace CrudExample.Models  \n{  \npublic class Student  \n    {  \npublic int ID { get; set; }  \n        [Required]  \npublic string Name { get; set; }  \n        [Required]  \n        [EmailAddress]  \npublic string Email { get; set; }  \n        [Required]  \npublic string Contact { get; set; }  \n    }  \n}   \n<\/pre>\n\n\n\n
    2. Create a Context Class<\/p>\n\n\n\n
    We will now create another class inside the Models folder, and it is used to communicate with Entity Framework and perform database operations<\/a>. This class inherits DbContext class.<\/p>\n\n\n\n
    \/\/ StudentRecord.cs\nusing System;  \nusing System.Collections.Generic;  \nusing System.Linq;  \nusing System.Web;  \nusing System.Data.Entity.ModelConfiguration.Conventions;  \nusing System.Data.Entity;  \nnamespace CrudExample.Models  \n{  \npublic class StudentRecord : DbContext  \n    {  \npublic DbSet<Student> Students { get; set; }  \nprotected override void OnModelCreating(DbModelBuilder modelBuilder)  \n        {  \n            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();  \n        }  \n    }  \n}  \n<\/pre>\n\n\n\n
    3. Add Scaffold to the Project<\/p>\n\n\n\n
    Right-click on the Controllers folder and add scaffold as we did in the screenshot.<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    It will pop up the below dialog box. Now, select controller with Entity Framework.<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    And click Add button. It asks for the Model and context name. Fill in the entries and click ok.<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    After clicking the add button, it creates a StudentsController controller and a Students folder. The Students folder contains web pages for each CRUD operation.<\/p>\n\n\n\n
    \/\/ StudentsController.cs\nusing System;  \nusing System.Collections.Generic;  \nusing System.Data;  \nusing System.Data.Entity;  \nusing System.Linq;  \nusing System.Net;  \nusing System.Web;  \nusing System.Web.Mvc;  \nusing CrudExample.Models;  \nnamespace CrudExample.Controllers  \n{  \npublic class StudentsController : Controller  \n    {  \nprivate StudentRecord db = newStudentRecord();  \n\/\/ GET: Students  \npublic ActionResult Index()  \n        {  \nreturn View(db.Students.ToList());  \n        }  \n\/\/ GET: Students\/Details\/5  \npublic ActionResult Details(int? id)  \n        {  \nif (id == null)  \n            {  \nreturn new HttpStatusCodeResult(HttpStatusCode.BadRequest);  \n            }  \nStudent student = db.Students.Find(id);  \nif (student == null)  \n            {  \nreturn HttpNotFound();  \n            }  \nreturn View(student);  \n        }  \n\/\/ GET: Students\/Create  \npublic ActionResult Create()  \n        {  \nreturn View();  \n        }  \n\/\/ POST: Students\/Create  \n        [HttpPost]  \n        [ValidateAntiForgeryToken]  \npublic ActionResult Create([Bind(Include = \"ID,Name,Email,Contact\")] Student student)  \n        {  \nif (ModelState.IsValid)  \n            {  \n                db.Students.Add(student);  \n                db.SaveChanges();  \nreturn RedirectToAction(\"Index\");  \n            }  \nreturn View(student);  \n        }  \n\/\/ GET: Students\/Edit\/5  \npublic ActionResult Edit(int? id)  \n        {  \nif (id == null)  \n            {  \nreturn new HttpStatusCodeResult(HttpStatusCode.BadRequest);  \n            }  \nStudent student = db.Students.Find(id);  \nif (student == null)  \n            {  \nreturn HttpNotFound();  \n            }  \nreturn View(student);  \n        }  \n\/\/ POST: Students\/Edit\/5 \n        [HttpPost]  \n        [ValidateAntiForgeryToken]  \npublic ActionResult Edit([Bind(Include = \"ID,Name,Email,Contact\")] Student student)  \n        {  \nif (ModelState.IsValid)  \n            {  \n                db.Entry(student).State = EntityState.Modified;  \n                db.SaveChanges();  \nreturn RedirectToAction(\"Index\");  \n            }  \nreturn View(student);  \n        }  \n\/\/ GET: Students\/Delete\/5  \npublic ActionResult Delete(int? id)  \n        {  \nif (id == null)  \n            {  \nreturn new HttpStatusCodeResult(HttpStatusCode.BadRequest);  \n            }  \nStudent student = db.Students.Find(id);  \nif (student == null)  \n            {  \nreturn HttpNotFound();  \n            }  \nreturn View(student);  \n        }  \n\/\/ POST: Students\/Delete\/5  \n        [HttpPost, ActionName(\"Delete\")]  \n        [ValidateAntiForgeryToken]  \npublic ActionResult DeleteConfirmed(int id)  \n        {  \nStudent student = db.Students.Find(id);  \n            db.Students.Remove(student);  \n            db.SaveChanges();  \nreturn RedirectToAction(\"Index\");  \n        }  \nprotected override void Dispose(bool disposing)  \n        {  \nif (disposing)  \n            {  \n                db.Dispose();  \n            }  \nbase.Dispose(disposing);  \n        }  \n    }  \n} \n<\/pre>\n\n\n\n
    The Students folder available inside the View contains the below files.<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    The Index.cshtml file contains the below code.<\/p>\n\n\n\n
    \/\/ Index.cshtml\n@model IEnumerable<scaffoldingTest.Models.Student>  \n@{  \n    ViewBag.Title = \"Index\";  \n}  \n<h2>Index<\/h2>  \n<p>  \n    @Html.ActionLink(\"Create New\", \"Create\")  \n<\/p>  \n<table class=\"table\">  \n<tr>  \n<th>  \n            @Html.DisplayNameFor(model => model.Name)  \n<\/th>  \n<th>  \n            @Html.DisplayNameFor(model => model.Email)  \n<\/th>  \n<th>  \n            @Html.DisplayNameFor(model => model.Contact)  \n<\/th>  \n<th><\/th>  \n<\/tr>  \n@foreach (var item in Model) {  \n<tr>  \n<td>  \n            @Html.DisplayFor(modelItem => item.Name)  \n<\/td>  \n<td>  \n            @Html.DisplayFor(modelItem => item.Email)  \n<\/td>  \n<td>  \n            @Html.DisplayFor(modelItem => item.Contact)  \n<\/td>  \n<td>  \n            @Html.ActionLink(\"Edit\", \"Edit\", new { id=item.ID }) |  \n            @Html.ActionLink(\"Details\", \"Details\", new { id=item.ID }) |  \n            @Html.ActionLink(\"Delete\", \"Delete\", new { id=item.ID })  \n<\/td>  \n<\/tr>  \n}  \n<\/table> \n<\/pre>\n\n\n\n
    Output:<\/p>\n\n\n\n
    Right-click on the Index.cshtml file and select “view in browser.” This will execute the file and produce the following output.<\/p>\n\n\n\n
    \/\/ Index file<\/p>\n\n\n\n
    This index file is used to show student records. Currently, the table is empty, so it does not show any data.<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    Add new Student<\/strong><\/p>\n\n\n\n
    We can add a new student by clicking on the Create New button. This will redirect to a student form.<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    After adding it, we added two more entries then redirect them back to the index file. Now, it contains three student records.<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    Update Record<\/strong><\/p>\n\n\n\n
    We can update the record by clicking on the Edit button. This will redirect to the update form. The following screenshot shows the edit page.<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    After updating the record, the index page looks like this:<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    Delete Record<\/strong><\/p>\n\n\n\n
    We can delete any record simply by clicking on the provided Delete link. Let’s delete Roman John from the table. A confirmation message will be displayed to the user for surety.<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    After clicking on the Delete button, it redirects to the index page that contains the remaining records.<\/p>\n\n\n\n
    \"ASP<\/figure>\n\n\n\n
    We can see that there are only two records are present.<\/p>\n","protected":false},"excerpt":{"rendered":"
    MVC Scaffolding is a feature of ASP.NET that allows you to generate functional code rapidly. It is also known as a code generator framework and is pre-installed in Visual Studio 2013 and a higher version. To create a basic CRUD application, scaffolding is the best choice. It reduces time amount and generates clean code. Here, […]<\/p>\n","protected":false},"author":1,"featured_media":9170,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[499],"tags":[],"class_list":["post-9167","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dotnet-tutorials"],"_links":{"self":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/posts\/9167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/comments?post=9167"}],"version-history":[{"count":0,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/posts\/9167\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/media\/9170"}],"wp:attachment":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/media?parent=9167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/categories?post=9167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/tags?post=9167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}