Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.

Preview

Start a free Basic trial
to watch this video

Sign up for Treehouse

Wrap Up

2:16 with James Churchill

Now that our CRUD operations are in place, the Comic Book Library Manager's data access layer is complete! Let's recap this section and wrap up the course.

Finished Project Code

Here's how to get the code for the finished project:

git clone git@github.com:treehouse-projects/dotnet-comic-book-gallery-model.git
cd dotnet-comic-book-gallery-model

Alternatives to Entity Framework

EF is not the only ORM for .NET. NHibernate and Dapper are two popular alternatives.

There's even a new version of Entity Framework, Entity Framework Core, developed by Microsoft as part of the new .NET "Core" family (i.e. .NET Core and ASP.NET Core).

Additional Project Ideas

Now that you've completed this course, it's a great time to reinforce what you've learned by working on a project.

Idea #1: Extend the Comic Book Library Manager Console App

Extend the Comic Book Library Manager console app with the ability to add, update, and delete comic book artists and their respective roles.

Here's the link to download the completed Comic Book Library Manager project files.

http://treehouse-project-downloads.s3.amazonaws.com/dotnet-ef-basics-comic-book-library-manager-completed.zip

Idea #2: Update the Comic Book Gallery website to Use EF

Update the Comic Book Gallery website—from the earlier Treehouse course on ASP.NET MVC—to use EF. For more information see:

Additional Treehouse Entity Framework Courses

Treehouse has two more EF courses that'll be available soon.

Additional Resources

  • 0:00

    Let's recap the section.

  • 0:03

    We learned how to organize our data access code into its own layer and

  • 0:06

    the advantages of doing so.

  • 0:08

    We reviewed how to create entities and

  • 0:11

    saw how to use foreign key properties to associate related entities.

  • 0:15

    We also saw how to manage related entities

  • 0:18

    in order to prevent unexpected duplicate records.

  • 0:21

    And we reviewed our options for updating and delete entities, and

  • 0:26

    saw how to take control of cascading deletes.

  • 0:30

    Now that our crud operations are in place,

  • 0:32

    the comic book library manager's data access layer is complete.

  • 0:36

    Great job finishing the work on this critical part of the application.

  • 0:41

    While entity framework is a popular ORM option amongst .NET developers,

  • 0:46

    it's certainly not the only available option.

  • 0:49

    In hibernate is a port of the popular Hibernate ORM for Java, and

  • 0:54

    there's a library called Dapper that offers a lightweight alternative to EF.

  • 1:00

    Microsoft has also been this only working on the successor to

  • 1:04

    EF Entity Framework core.

  • 1:06

    EF core is a complete rewrite of EF that is both lightweight and extensible.

  • 1:12

    For more information on in hibernate, Dapper, or EF core,

  • 1:16

    see the teacher's notes.

  • 1:19

    Now that you've completed this course,

  • 1:21

    it's a great time to reinforce what you've learned by working on a project.

  • 1:25

    For instance, you could work on extending the comic book

  • 1:28

    library manager console lab with the ability to add,

  • 1:32

    update and delete comic book artists and their respective roles.

  • 1:36

    Or you could update the kind of gallery website from

  • 1:40

    the earlier Treehouse course on ASP.NET NVC to use EF.

  • 1:45

    We've covered a lot of ground in this course but

  • 1:47

    there's still more to learn about EF.

  • 1:50

    See the teacher's notes for links to Treehouse courses about EF code

  • 1:55

    first migrations and how to use EF with an ASP.Net NVC application.

  • 2:00

    There are also great online and offline resources available.

  • 2:05

    Again, see the teacher's notes for a list of these resources.

  • 2:09

    Thanks for

  • 2:10

    taking the time to hang out with me and learn the basics of Entity framework.

  • 2:14

    See you next time.

You need to sign up for Treehouse in order to download course files.

Sign up