ASP.NET MVC 5 – Entity Framework 6, CRUD Operations on Visual Studio 2015

• Download source - 786.7 KB

This demo focuses on using ASP.NET Scaffolding to generate the controllers and views.

STEP 1 - Create a New Project on Visual Studio 2015

• Open Visual Studio
• Create a new ASP.NET Web Application Project
• Give a name to the project (in this case, I call him MVC5)
• Select Template MVC

STEP 2 - Create class Movies

Add a new class to the project (this class represents a table, and the properties the columns of that table).

Give a name to that class (in my sample, I call him MoviesModel).

On the class, create the following code:

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Dynamic;
using System.Linq;
using System.Web;

namespace MVC5.Models
{
    public class Email
    {
        public int ID { get; set; }
        public string To { get; set; }
        public string Subject { get; set; }
        public string Message { get; set; }
    }

    public class EmailDBContext : DbContext
    {
        public DbSet<email> Emails { get; set; }
    }
}

Put the class inside the Models folders, just to organize your code.

STEP 3 - Create a controller with views using Entity Framework

Add new Scaffolded to the project (new item existent on MVC5):

Choose option MVC5 Controller with views using Entity Framework:

Click Add

If you receive an error, it may be because you did not build the project in the previous section. If so, try building the project, and then add the scaffolded item again.

After the code generation process is complete, you will see a new controller and views in your project.

STEP 4 - Controller and Views Generation

a. The Controller was automatically created with 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 MVC5.Models
{
    public class MoviesController : Controller
    {
        private MovieDBContext db = new MovieDBContext();

        // GET: Movies
        public async Task<actionresult> Index()
        {
            return View(await db.Movies.ToListAsync());
        }

        // GET: Movies/Details/5
        public async Task<actionresult> Details(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Movie movie = await db.Movies.FindAsync(id);
            if (movie == null)
            {
                return HttpNotFound();
            }
            return View(movie);
        }

        // GET: Movies/Create
        public ActionResult Create()
        {
            return View();
        }

        // POST: Movies/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,Title,ReleaseDate,Genre,Price")] Movie movie)
        {
            if (ModelState.IsValid)
            {
                db.Movies.Add(movie);
                await db.SaveChangesAsync();
                return RedirectToAction("Index");
            }

            return View(movie);
        }

        // GET: Movies/Edit/5
        public async Task<actionresult> Edit(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Movie movie = await db.Movies.FindAsync(id);
            if (movie == null)
            {
                return HttpNotFound();
            }
            return View(movie);
        }

        // POST: Movies/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,Title,ReleaseDate,Genre,Price")] Movie movie)
        {
            if (ModelState.IsValid)
            {
                db.Entry(movie).State = EntityState.Modified;
                await db.SaveChangesAsync();
                return RedirectToAction("Index");
            }
            return View(movie);
        }

        // GET: Movies/Delete/5
        public async Task<actionresult> Delete(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Movie movie = await db.Movies.FindAsync(id);
            if (movie == null)
            {
                return HttpNotFound();
            }
            return View(movie);
        }

        // POST: Movies/Delete/5
        [HttpPost, ActionName("Delete")]
        [ValidateAntiForgeryToken]
        public async Task<actionresult> DeleteConfirmed(int id)
        {
            Movie movie = await db.Movies.FindAsync(id);
            db.Movies.Remove(movie);
            await db.SaveChangesAsync();
            return RedirectToAction("Index");
        }

        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                db.Dispose();
            }
            base.Dispose(disposing);
        }
    }
}

b. The Views were automatically created

Run the application:

MVC5 Resources

Some good online resources about MVC5:

ASP.NET MVC5: The official Microsoft .NET WebSite http://www.asp.net/mvc/tutorials/mvc-5

For more examples, follow my blog at http://joaoeduardosousa.wordpress.com/

Check My Other Source Code

• http://code.msdn.microsoft.com/MVC4-ENTITY-FRAMEWORK-10-e15ef983 
• http://code.msdn.microsoft.com/ASPNET-MVC-5-Bootstrap-30-622be454 
• http://code.msdn.microsoft.com/MVC5-Authentication-App-b5200efd 
• http://code.msdn.microsoft.com/ASPNET-WebAPI-2-Stream-7d96cb70 
• http://code.msdn.microsoft.com/ASPNET-WebAPI-Basic-Redis-ade42ca7 
• http://code.msdn.microsoft.com/ASPNET-WebApi-Use-Redis-as-a0d942a3 
• http://code.msdn.microsoft.com/ASPNET-MVC-connect-with-1f40770f 
• http://code.msdn.microsoft.com/ASPNET-WebAPI-Enable-Cors-666b88eb 
• http://code.msdn.microsoft.com/ASPNET-WebAPI-Entity-2f8797a1