Bummer! This is just a preview. You need to be signed in with a Basic account to view the entire video.
Start a free Basic trial
to watch this video
Let's start with reviewing the comic books controller—specifically the `Index`, `Detail`, and `Add` action methods—and put together our plan for updating the action methods to use EF to retrieve data from the database.
Follow Along
To follow along committing your changes to this course, you'll need to fork the dotnet-comic-book-library-manager repo. Then you can clone, commit, and push your changes to your fork like this:
git clone <your-fork>
cd dotnet-comic-book-library-manager
git checkout tags/v1.5 -b preparing-our-plan
Keyboard Shortcuts
-
CTRL+MCTRL+O- Collapse to Definitions -
CTRL+MCTRL+M- Toggle Outlining Expansion
-
0:00
[MUSIC]
-
0:04
Welcome back.
-
0:06
In this section we will be updating our web app to retrieve and
-
0:09
process Comic book data from and to the database.
-
0:12
As we do that, we'll look at how to configure the context
-
0:15
database connection string, set the database initializer,
-
0:19
manage the lifetime of the database context, and more.
-
0:22
Are you ready to start updating our web app to UCF?
-
0:25
Let's get started.
-
0:27
The Comic Book Library Manager Web App has three top level sections.
-
0:31
Comic Books, Series, and Artists.
-
0:35
Any of these sections could be used as a starting point for
-
0:38
adding EF to our web app.
-
0:39
But let's start with the comic books section,
-
0:42
that will give us a good jumping off point into our web app.
-
0:45
It's the heart of our app, and it has enough meat on the bones, so to speak,
-
0:50
to give us a realistic example.
-
0:55
We'll start with updating the ComicBooksController,
-
0:58
specifically the index.
-
1:02
Detail and Add action methods.
-
1:09
Each place in the controller class that we need to update
-
1:12
is marked with a TODO code comment.
-
1:14
The Index action method needs a query that returns a list of comic books.
-
1:19
The detailAction method needs a query that returns a single comic book.
-
1:28
And in the addAction method, the viewModelsInit method
-
1:35
Needs to query a list of the artists and roles.
-
1:43
And in the base class, a list of series.
-
1:47
When we move the EF related classes out of the console lib project, the class library
-
1:52
project, one of the classes that we moved was a repository class.
-
1:57
Let's review the contents of that class.
-
1:59
Press Ctrl+m, Ctrl+o to collapse the class down to its definitions.
-
2:05
That'll make it easier to see all of the methods in the class at a glance.
-
2:09
Placing your cursor on a collapsed section and
-
2:12
pressing Ctrl+m, Ctrl+m will expand that section.
-
2:15
Pressing Ctrl+m, Ctrl+m a second time will collapse that section again.
-
2:21
The GetContext() method is responsible for creating an instance of the context class.
-
2:26
Other methods in this class,
-
2:28
as we'll see in the next method, call this method to get an instance of the context.
-
2:32
Notice that the Database.Log property is being set to a simple Lambda expression
-
2:37
that uses the Debug.WriteLine method to log messages.
-
2:41
The GetComicBooks method returns a list of comic books.
-
2:45
And it eagerly loads the related series entity by
-
2:48
including the series navigation property.
-
2:55
The GetComicBook method returns a single comic book with the series and
-
3:00
artists related entities eagerly loaded.
-
3:04
And a bit further down, here are methods that
-
3:09
return lists of Series, Artists and Roles.
-
3:14
Each of this lists is needed by the view model for the AddComicBook page.
-
3:19
So to recap, the repository class has a method to complete every one
-
3:23
of the TODOs in the index, detail and add action methods.
-
3:29
That's great.
-
3:30
What's not so great is that each method in the repository class
-
3:34
instantiates it's own instance of the context class.
-
3:38
Why is this a problem?
-
3:40
Let's look at an example.
-
3:47
The addAction method will need to call the GetSeries, GetArtists,
-
3:53
and GetRoles methods on the repository class in order to get the series,
-
3:58
artist, and roles data.
-
4:02
If we expand those methods, we can see that each method makes a call
-
4:06
to the GetContext() Method, wrapped in a using () statement.
-
4:10
So three instances of the context class will get instantiated.
-
4:14
Ideally, each of these queries would use the same context class, especially when
-
4:19
they're being called from within the same invocation of the add action method.
-
4:24
In the next section, we'll create an improved version of our repository
-
4:28
that'll work better with our MVC web app.
-
4:31
For now, we'll just copy the link queries that we need from the repository class
-
4:36
to our controller action methods.
-
4:38
But before we do that, there is some prep work that we need to do.
-
4:42
Two things are needed in order to ensure that EF is
-
4:45
properly configured for a web app.
-
4:47
Configure the server and
-
4:48
database that EF should use and configure the database initializer.
-
4:54
We'll start with configuring the server and database.
-
4:57
There are a number of ways to accomplish this.
-
4:59
Do you recall the method that allows you to specify the server and
-
5:03
database via configuration?
-
5:06
In the next video we'll start with making that change to our web app.
You need to sign up for Treehouse in order to download course files.
Sign up