Click here to Skip to main content
Click here to Skip to main content

Tagged as

Go to top

LOB Gamification Service Admin Website: Data Services

, 17 Dec 2012
Rate this:
Please Sign up or sign in to vote.
The goal of this post is to use ASP.NET MVC Web API to surface database data to the client browser.

At the end of the last post, I had a solution with multiple projects. One of the projects contained the POCO domain model and another project leveraged EF Code First to read/write the domain model to a dynamically created SQL Server database. The goal of this post is to use ASP.NET MVC Web API to surface database data to the client browser.

Most of my career I have spent on the server side of things moving data between layers. I have been part of teams where we created our own application infrastructure as well as a user of IdeaBlade’s DevForce, WCF RIA Services, CSLA, etc.

In the last year, I have had the pleasure of learning from Jon Sarker who is a senior software architect at ProModel. Jon has helped ProModel streamline moving data efficiently and quickly through the use of enterprise design patterns such as Repositories, Commanding, Factories (for repos and commands in particular), DTOs, Request/Response objects, etc. Once you understand and start using these data design patterns, everything seems so modular, clean and maintainable.

As I embarked on learning the new world of HTML5, JavaScript and Web API, I figured the learning materiel on the web would be the equivalent of showing me how to drag and drop a datasource control. That is why I was so blown away at the depth of John Papa’s course “Single Page Apps with HTML5, Web API, Knockout and jQuery”. From John’s blog, the SPA has lots of patterns “including the Repository Pattern (to expose the data in a consistent way), Unit of Work Pattern (to decouple the Web API from the lower layers and to aggregate the repositories), the Factory pattern (for creating repositories), and Single Responsibility Principle (SRP). The SRP is all throughout the client and server, in fact. Simply put, the patterns help make the app easier to debug, scale and maintain.”

For better or worse, I am using John Papa’s server design without questioning much. My goal is to accelerate getting to the technology I am not familiar with which is the client side HTML5 and JavaScript libraries.

The focus in this blog post will be documenting the process of using Mr. Papa’s Code Camper code to do the following against the gamification service domain model:

1. Build Repositories

2. Build Unit of Work with Repository Factories

3. Web API Controllers

Build Repositories

I recommend reading Patrik Lowendahl’s “The repository pattern explained and implemented” which contained the following definition for the Repository Pattern found here.

“Mediates between the domain and the data mapping layers using a collection-like interface for accessing domain objects.”

So far, LobGame.Data.Contracts is empty. Borrowing from John, I put the following IRepository interface in the “LobGame.Data.Contracts” project.

clip_image001

I must admit I hit a case of analysis paralysis here. Mr. Papa used Int as the data type for his unique identifier. My domain object classes used a mix of string and Guid as the unique identifiers therefore I needed the flexibility of the Object type.

I will be using Entity Framework to get/save data from the SQL Server database. The following is the concrete implementation of the IRepository using EF.

clip_image002

clip_image003

As long as I fetch data through the IRepository interface, no one needs to know under the hood I am using Entity Framework. I love how the EFRepository provides basic CRUD operation for free. This will allow me to get something up and running really fast and then override to optimize later as needed.

Notice the “GetAll” returns IQueryable<T>. From my previous experience with Repositories, I have debated the value of returning IQueryable<T> in our repositories. Just for food for thought, I share the following links for perhaps a future debate.

1. http://mikehadlow.blogspot.com/2009/01/should-my-repository-expose-iqueryable.html

2. http://www.codetunnel.com/blog/post/103/should-you-return-iqueryablet-from-your-repositories

Build Unit of Work with Repository Factories

I do not have much experience with the Unit of Work pattern. Seeing it in action I see the value. Martin Fowler defines Unit of Work pattern as:

“Maintains a list of objects affected by a business transaction and coordinates the writing out of changes and the resolution of concurrency problems.”

In previous web services I built, it would be common to instantiate 1 to many repositories in a command or service constructor. With the UoW, I have easy access to all repositories. It allows one to derive a base class more easily and simply put the UoW in it.

Again. borrowing directly from Mr. Papa, I put the following interface for ILobGameUow in the “LobGame.Data.Contracts” project.

clip_image004

The interface is simple basically containing a repository for each class in the domain model.

The concrete implementation is found in the “LobGame.Data” project and is shown below.

clip_image006

The concrete implementation of the “Unit of Work”

1) Decouples the Repositories from the controllers

2) Decouples the DbContext and Entity Framework from the Web API controllers

This class implements the “Unit of Work” pattern in which the “UoW” serves as a facade for querying and saving to the database. Querying is delegated to “repositories”. Each repository serves as a container dedicated to a particular root entity type such as an Application. A repository typically exposes “Get” methods for querying and will offer add, update, and delete methods if those features are supported. The repositories rely on their parent UoW to provide the interface to the data layer which in this implementation is the EF DbContext.

There are 2 methods within the UoW that know how to return a repository based upon the domain model entity type. GetStandardRepo<T> will create the most basic repository based upon EfRepository. GetRepo<T> will find a specialized version you have created for a specific domain model entity. For brevity, I am not showing some Factory classes. Perhaps I will follow up in a later post. You can find them here.

clip_image007

At this point, I have not created any specialized repositories yet so notice the UoW is always calling GetStandardRepo<T>. I will create some specialized repositories in the next blog post. For now, repositories will only provide the ability to GetAll, GetById, Add, Delete and Update using the generic EFRepository implementation.

Web API Controllers

With the Repositories and UoW defined, getting a working version of a web API is pretty easy. I need an APIController for each domain model class. Each controller ideally should have access to the UoW therefore ApiControllerBase makes sense to be created.

clip_image009

If you compare this to the John Papa’s Code Camper application, you will notice its use of Inversion of Control to define the UoW. If requested, I will discuss IoC in a later blog post.

Next, I created my first APIController for my Application entity and derived it from ApiControllerBase. I right clicked on the “Controllers” folder and added the following:

clip_image010

I then modified the template ApplicationsController to be derived from ApiControllerBase. I added a constructor which constructed the repository factories and ultimately a LobGameUow.

clip_image012

As you can see above, just to see if things were working, I implemented the Get() method by simply calling into Uow.Applications.GetAll().

Oh yeah, I commented out creating the LobGameDbcontext in the Global.asax.cs from the previous post since LobGameDbcontext will be creating as part of the UoW contruction within the ApiControllerBase.

clip_image013

Before we run this, let recap the blog series so far:

1. In “Model” project, built the domain objects.

2. In “Data” project built the DbContext referencing the domain objects in the DbSets. EF Code First created and seeded the database.

3. In “Data.Contracts” project,

a. Added 2 interfaces IRepository and ILobGameUow.

b. Added “Helpers” folder for Repository Factory classes.

4. In “Data” project, created 2 concrete classes EFRepository and LobGameUow. LobGameUow simply contains repositories for each class in the domain model.

5. In “Web” project, created our first ApiController for Application.

If you run the project, you will get the home page provided by the Visual Studio MVC4 template as shown here.

clip_image014

I replaced the url with this http://localhost:58016/api/applications and voila, data is returned as seen below.

clip_image015

You can see data from the SQL Server database is being returned to the browser. Notice however that the format is XML whereas we would like it to be in JSON. To address this, John Papa added the following class to LobGame.Web project’s “App_Start” folder which removes the Xml formatters from the HttpConfiguration.

clip_image017

Now call this new class within Global.asax.cs.

clip_image018

Rerun and voila, JSON now.

clip_image019

Typing in “/api/applications/?id=a3963393-926a-464b-8525-1ef4ad8a2022” will fetch just a single application with that id.

clip_image020

The majority of the code I have discussed is “write once” plumbing such as IRepository, EFRepository, APIBaseController, RepositoryFactories, RepositoryProvider, etc. With the plumbing already written, one can easily surface data to a browser by simply creating:

1. Domain Model

2. DbContext

3. UoW

4. APIController(s)

This blog post gave a high level overview of some data design patterns such as Repositories and Unit of Work and ended with fetching data from the database for one of the classes in the domain model. In the next blog post, I will most discuss adding, deleting and updating data through the Web API for at least 2 of the domain model classes.

Possible Future Discussion Points

The following list of topics is things I skimmed over or ignored altogether. If you are interested in one of these let me know.

· Repository Factories deep dive

· ASP.NET MVC and Inversion of Control using Ninject

· Pros/Cons of returning IQueryable<> from Repositories

· Int versus Guid for unique identifier

· If I don’t get burned out, I think a good future task would be to swap out the client and server infrastructure with Breeze.js and DevForce.

· Microsoft Upshot

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

DapperDanH
Chief Technology Officer PROMODEL Corporation
United States United States
No Biography provided
Follow on   Twitter

Comments and Discussions

 
GeneralMy vote of 4 PinmemberOleksandr Kulchytskyi21-Dec-12 10:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web03 | 2.8.140926.1 | Last Updated 17 Dec 2012
Article Copyright 2012 by DapperDanH
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid