Welcome back.

So, how did you do?

Were you able to complete the series section?

Let's take a look at my solution.

I decided to create an entity type focus repository for the series entity type.

So, the first thing that I did was add a series repository class

to the class library's data folder.

I inherited from the base repository class and specified the series entity type for

the entity type generic parameter.

Then, I added a constructor in order to get a reference to the data base context,

and implemented the get and git list abstract methods.

In the git method,

I called the DB set AsQueryable method to get a reference to an I queryable object.

in order to eagerly load the comic book's navigation collection property,

if the include related entities parameter is set to true.

And in the GetList method, I simply called the ToList method on the context of series

DBSet property, ordering the list by the series title property.

I also added a SeriesHasTitle method that uses the any operator

to check if there's a series with a different ID, but the same title.

Once I had the repository completed I turned my attention to the series

controller class.

I started by updating the controller to inherit from our BaseController class.

Remember, inheriting from our custom controller based class

gives the descending controller class access to our database context class.

Then, I added a private field for the series repository, and

added a constructor to initialize the private field.

In the index action method I replaced the instantiation with the list collection

with a call to the repositories get list method.

In the detail action method I replaced the instantiation of the series in the class.

With a call to the repository skip method.

In the add post action method,

I added a call to the repository's add method to add the series to the database.

In the edit get action method, I added another call to the repository's get

method, this time setting the includeRelatedEntities parameter to false.

Setting the included related entities parameter to false

wasn't absolutely necessary to do.

If you didn't you probably noticed that the page rendered just fine.

It's just a small optimization to not load the series as comic books

since the edit series page doesn't display them.

In the edit post action method, I added a call to the repository's update method.

To persist to the data base any changes made to the series entity.

In the delete get action method,

I added another call to the repository's get method.

And in the delete post action method I added a call to the repositories delete

method to delete the series entity from the data base.

And lastly, I updated the validate series method,

with a call to the repositories series has title method.

While that completed all the necessary changes to implement the series

section I decided to do a bit of cleanup work in the repository class.

The GetSeriesList method had the same implementation as the entity type focused

repositories GetList method, so I removed that method.

Removing the GetSeriesList method from the repository class

introduced an error in the coin books view model class as the Init

method contained a call to that method.

To resolve the error, I added another parameter for the seriesRepository.

And replaced the call to the GetSeriesList method with a call to

the seriesRepository.GetList method.

Changing the signature of the virtual Init method then

caused an error in the comic books adview model class.

I resolved that air by adding the seriesRepository parameter, so

its signature match the Init method in the base class.

And I updated the call to the base classes Init method

by passing in the seriesRepository parameter.

Changing the signature of the view models Init method

broke every call to that method in the ComicBooksController class.

A total of four errors.

To resolve those errors, I needed an instance of the series repository

class that I could pass to every Init method call.

So, I added a private field for the series repository, and updated the constructor

to initialize that private field to an instance of the SeriesRepository class.

Then I updated each call to the Init method to pass in

the _seriesRepository private field.

It's sometimes surprising how such a simple change like removing one

method from a repository can result in so many cascading changes,

once I had completed all of my changes, I ran and tested the app.

Don't worry if you weren't able to complete all of the tasks.

Attempting to complete a task, regardless of whether, or

not you were successful, is an important part of the learning process.

Failing at a task is not a measure of your abilities.

It's simply a signal that you've got something else to learn.

Also, you may have done things differently than how I did, and that's okay.

There's almost always more than one way to implement a feature, or

to solve a problem.

Next up finishing the artist section of the web app.