student_course | C# Online Compiler

student_course by psrirajan@gmail.com

using System;  
using System.Collections;
using System.Collections.Generic;
	 
using System.Linq;  
using System.Web;  
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;  
// using System.Data.Entity.dbcontext;

namespace CrudExample.Models  
{  
public class StudentRecord : DbContext  
    {  
public DbSet<Student> Students { get; set; }  
protected override void OnModelCreating(DbModelBuilder modelBuilder)  
        {  
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();  
        }  
    }  
}

Model

​x
 
using System;  
using System.Collections;
using System.Collections.Generic;
     
using System.Linq;  
using System.Web;  
using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;  
// using System.Data.Entity.dbcontext;
​
namespace CrudExample.Models  
{  
public class StudentRecord : DbContext  
    {  
public DbSet<Student> Students { get; set; }  
protected override void OnModelCreating(DbModelBuilder modelBuilder)  
        {  
            modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();  
        }  
    }  
}  

@model IEnumerable<scaffoldingTest.Models.Student>  
@{  
    ViewBag.Title = "Index";  
}  
<h2>Index</h2>  
<p>  
    @Html.ActionLink("Create New", "Create")  
</p>  
<table class="table">  
<tr>  
<th>  
            @Html.DisplayNameFor(model => model.Name)  
</th>  
<th>  
            @Html.DisplayNameFor(model => model.Email)  
</th>  
<th>  
            @Html.DisplayNameFor(model => model.Contact)  
</th>  
<th></th>  
</tr>  
@foreach (var item in Model) {  
<tr>  
<td>  
            @Html.DisplayFor(modelItem => item.Name)  
</td>  
<td>  
            @Html.DisplayFor(modelItem => item.Email)  
</td>  
<td>  
            @Html.DisplayFor(modelItem => item.Contact)  
</td>  
<td>  
            @Html.ActionLink("Edit", "Edit", new { id=item.ID }) |  
            @Html.ActionLink("Details", "Details", new { id=item.ID }) |  
            @Html.ActionLink("Delete", "Delete", new { id=item.ID })  
</td>  
</tr>  
}  
</table>

View

 
@model IEnumerable<scaffoldingTest.Models.Student>  
@{  
    ViewBag.Title = "Index";  
}  
<h2>Index</h2>  
<p>  
    @Html.ActionLink("Create New", "Create")  
</p>  
<table class="table">  
<tr>  
<th>  
            @Html.DisplayNameFor(model => model.Name)  
</th>  
<th>  
            @Html.DisplayNameFor(model => model.Email)  
</th>  
<th>  
            @Html.DisplayNameFor(model => model.Contact)  
</th>  
<th></th>  
</tr>  
@foreach (var item in Model) {  
<tr>  
<td>  
            @Html.DisplayFor(modelItem => item.Name)  
</td>  
<td>  
            @Html.DisplayFor(modelItem => item.Email)  
</td>  
<td>  
            @Html.DisplayFor(modelItem => item.Contact)  
</td>  
<td>  
            @Html.ActionLink("Edit", "Edit", new { id=item.ID }) |  
            @Html.ActionLink("Details", "Details", new { id=item.ID }) |  
            @Html.ActionLink("Delete", "Delete", new { id=item.ID })  
</td>  
</tr>  
}  
</table>  

using System;  
using System.Collections;
using System.Collections.Generic;  
using System.Data;  
using System.Data.Entity;  
using System.Linq;  
using System.Net;  
using System.Web;  
using System.Web.Mvc;  
using CrudExample.Models;  
namespace CrudExample.Controllers  
{  
public class StudentsController : Controller  
    {  
private StudentRecord db = newStudentRecord();  
// GET: Students  
public ActionResult Index()  
        {  
return View(db.Students.ToList());  
        }  
// GET: Students/Details/5  
public ActionResult Details(int? id)  
        {  
if (id == null)  
            {  
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);  
            }  
Student student = db.Students.Find(id);  
if (student == null)  
            {  
return HttpNotFound();  
            }  
return View(student);  
        }  
// GET: Students/Create  
public ActionResult Create()  
        {  
return View();  
        }  
// POST: Students/Create  
// To protect from overposting attacks, please enable the specific properties you want to bind to, for   
// more details see https://go.microsoft.com/fwlink/?LinkId=317598.  
        [HttpPost]  
        [ValidateAntiForgeryToken]  
public ActionResult Create([Bind(Include = "ID,Name,Email,Contact")] Student student)  
        {  
if (ModelState.IsValid)  
            {  
                db.Students.Add(student);  
                db.SaveChanges();  
return RedirectToAction("Index");  
            }  
return View(student);  
        }  
// GET: Students/Edit/5  
public ActionResult Edit(int? id)  
        {  
if (id == null)  
            {  
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);  
            }  
Student student = db.Students.Find(id);  
if (student == null)  
            {  
return HttpNotFound();  
            }  
return View(student);  
        }  
// POST: Students/Edit/5  
// To protect from overposting attacks, please enable the specific properties you want to bind to, for   
// more details see https://go.microsoft.com/fwlink/?LinkId=317598.  
        [HttpPost]  
        [ValidateAntiForgeryToken]  
public ActionResult Edit([Bind(Include = "ID,Name,Email,Contact")] Student student)  
        {  
if (ModelState.IsValid)  
            {  
                db.Entry(student).State = EntityState.Modified;  
                db.SaveChanges();  
return RedirectToAction("Index");  
            }  
return View(student);  
        }  
// GET: Students/Delete/5  
public ActionResult Delete(int? id)  
        {  
if (id == null)  
            {  
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);  
            }  
Student student = db.Students.Find(id);  
if (student == null)  
            {  
return HttpNotFound();  
            }  
return View(student);  
        }  
// POST: Students/Delete/5  
        [HttpPost, ActionName("Delete")]  
        [ValidateAntiForgeryToken]  
public ActionResult DeleteConfirmed(int id)  
        {  
Student student = db.Students.Find(id);  
            db.Students.Remove(student);  
            db.SaveChanges();  
return RedirectToAction("Index");  
        }  
protected override void Dispose(bool disposing)  
        {  
if (disposing)  
            {  
                db.Dispose();  
            }  
base.Dispose(disposing);  
        }  
    }  
}

Controller

 
using System;  
using System.Collections;
using System.Collections.Generic;  
using System.Data;  
using System.Data.Entity;  
using System.Linq;  
using System.Net;  
using System.Web;  
using System.Web.Mvc;  
using CrudExample.Models;  
namespace CrudExample.Controllers  
{  
public class StudentsController : Controller  
    {  
private StudentRecord db = newStudentRecord();  
// GET: Students  
public ActionResult Index()  
        {  
return View(db.Students.ToList());  
        }  
// GET: Students/Details/5  
public ActionResult Details(int? id)  
        {  
if (id == null)  
            {  
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);  
            }  
Student student = db.Students.Find(id);  
if (student == null)  
            {  
return HttpNotFound();  
            }  
return View(student);  
        }  
// GET: Students/Create  
public ActionResult Create()  
        {  
return View();  
        }  
// POST: Students/Create  
// To protect from overposting attacks, please enable the specific properties you want to bind to, for   
// more details see https://go.microsoft.com/fwlink/?LinkId=317598.  
        [HttpPost]  
        [ValidateAntiForgeryToken]  
public ActionResult Create([Bind(Include = "ID,Name,Email,Contact")] Student student)  
        {  
if (ModelState.IsValid)  
            {  
                db.Students.Add(student);  
                db.SaveChanges();  
return RedirectToAction("Index");  
            }  
return View(student);  
        }  
// GET: Students/Edit/5  
public ActionResult Edit(int? id)  
        {  
if (id == null)  
            {  
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);  
            }  
Student student = db.Students.Find(id);  
if (student == null)  
            {  
return HttpNotFound();  
            }  
return View(student);  
        }  
// POST: Students/Edit/5  
// To protect from overposting attacks, please enable the specific properties you want to bind to, for   
// more details see https://go.microsoft.com/fwlink/?LinkId=317598.  
        [HttpPost]  
        [ValidateAntiForgeryToken]  
public ActionResult Edit([Bind(Include = "ID,Name,Email,Contact")] Student student)  
        {  
if (ModelState.IsValid)  
            {  
                db.Entry(student).State = EntityState.Modified;  
                db.SaveChanges();  
return RedirectToAction("Index");  
            }  
return View(student);  
        }  
// GET: Students/Delete/5  
public ActionResult Delete(int? id)  
        {  
if (id == null)  
            {  
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);  
            }  
Student student = db.Students.Find(id);  
if (student == null)  
            {  
return HttpNotFound();  
            }  
return View(student);  
        }  
// POST: Students/Delete/5  
        [HttpPost, ActionName("Delete")]  
        [ValidateAntiForgeryToken]  
public ActionResult DeleteConfirmed(int id)  
        {  
Student student = db.Students.Find(id);  
            db.Students.Remove(student);  
            db.SaveChanges();  
return RedirectToAction("Index");  
        }  
protected override void Dispose(bool disposing)  
        {  
if (disposing)  
            {  
                db.Dispose();  
            }  
base.Dispose(disposing);  
        }  
    }  
}  

View in Full Screen

ProductID	CategoryID	Name	Description
1	1	Dapper Plus	Use <a href="https://dapper-plus.net/" target="_blank">Dapper Plus</a> to extend your IDbConnection with high-performance bulk operations.
3	1	Entity Framework Extensions	Use <a href="https://entityframework-extensions.net/" target="_blank">Entity Framework Extensions</a> to extend your DbContext with high-performance bulk operations.

Cached Result
Last Run:	1:35:45 am
Compile:	0.04s
Execute:	0.87s
Memory:	52.46Mb
CPU:	0.91s

View IL Code