Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.


Entity Framework with ASP.NET MVC Course

via Treehouse


In Entity Framework Basics, you learned how to use Entity Framework to persist data to a database within the context of a console application. In this course, you'll learn how to use Entity Framework within the Comic Book Library Manager web app—a web application developed using the ASP.NET MVC web framework. You'll work on completing this web app so that users can create, update, and delete comic books from their digital library.

Throughout this course you'll learn by example by completing hands-on coding exercises. See how to put EF related code into its own class library project, retrieve and persist data from within a web app, organize your data access code using popular design patterns, and more!

What you'll learn

  • Leveraging Class Library Projects
  • Adding EF to an ASP.NET MVC Project
  • Managing the Context's Lifetime
  • Using Data Access Design Patterns


Project Setup

We'll start by taking a look at the Comic Book Library Manager web app. Then we'll add class library and ASP.NET MVC projects to the existing Comic Book Library Manager console app project's Visual Studio solution. We'll also add a set of starter files to our MVC project and see how you can use a view model to supply data to a view.

Chevron 6 steps
  • Using Entity Framework with MVC Web Apps


  • Introducing the Comic Book Library Manager Web App


  • Adding the Class Library Project


  • Adding the ASP.NET MVC Project


  • Reviewing the Provided Project Code


  • Section Review

    5 questions

Entity Framework and ASP.NET MVC

Now that we have our solution setup, we'll configure EF and update the comic books controller to use EF for all of its data retrieval and persistence. Along the way, we'll see how we can hook into the controller's lifetime in order to manage the lifetime of the database context. You'll also have the chance to work on a hands-on exercise as you finish the comic book artists controller.

Chevron 9 steps
  • Preparing Our Plan


  • Configuring Entity Framework


  • Handling Reads


  • Managing the Context's Lifetime


  • Handling Creates and Updates


  • Handling Deletes


  • Exercise: Finishing the Comic Book Artists Controller


  • Solution: Finishing the Comic Book Artists Controller


  • Section Review

    5 questions

Data Access Design Patterns

Now that our web app has been updated to use EF, we'll look at some ways we can improve the design and organization of our data access code. We'll see how we can use the repository pattern in a variety of ways including creating a generic base repository class to help facilitate implementing entity-type-focused repositories. We'll also take a look at using query and command classes as an alternative to using repositories.

Chevron 9 steps
  • Adding a Base Controller Class


  • Using the Repository Pattern


  • Reviewing the Completed Repository


  • Breaking Apart Our Repository


  • Reviewing the Comic Book Artists Repository


  • Creating a Generic Base Repository Class


  • Using Our Generic Base Repository Class


  • Alternatives to Using Repositories


  • Section Review

    5 questions

Completing the Project

We'll complete the course with a set of exercises for you to complete: one exercise to finish the "Series" section and another to finish the "Artists" section.

Chevron 5 steps
  • Exercise: Finishing the "Series" Section


  • Solution: Finishing the "Series" Section


  • Exercise: Finishing the "Artists" Section


  • Solution: Finishing the "Artists" Section


  • Section Review

    5 questions


Start your review of Entity Framework with ASP.NET MVC Course

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.