Click here to Skip to main content
15,867,308 members
Articles / Web Development / HTML

CRUD Operations with ASP.NET Web API using FluentNHibernate, Repository Pattern

Rate me:
Please Sign up or sign in to vote.
5.00/5 (10 votes)
16 Oct 2014CPOL6 min read 71.7K   675   22   25
In this step-by-step article, we will discuss all about CRUD (Create Read Update Delete) operations with Web API using Repository pattern.

Introduction

In this step-by-step article, we will discuss all about Create, Read, Update, Delete (CRUD) operations with the Web API using the Repository pattern and using the most popular ORM, FluentNHibernate. In this article, we will not go into depth about how to consume WEB APIs.

I recommend reading the following article to learn more if you want to use the Web API from a third-party as a client:

Why WEB API?

While preparing this whitepaper, I asked myself the question "Why Web API?". In simple and few words, there are numerous things why we are doing it with the Web API and not with WebServices, WCF or REST WCF.

I categorized these as follows:

  • Features
  • Functionalities
  • Resources
  • Behavioral

Although we will not dig deely into the preceding since that is beyond the scope of our main topic, I would like to recommend reading the following to understand these terms better:

Pre-requisites

To implement and play with the source code, one should have:

  • Basic knowledge of ASP.NET MVC
  • Basic knowledge of REST services
  • Basic knowledge of FluentNHibernate
  • Basic knowledge of Repository pattern
  • Require Visual Studio 2012 or later with ASP.NET WebAPI support

Let's Start Creating an ASP.NET Web API Project

  • Start your Visual Studio and choose File -> New Project (Ctrl + Shift + N)
  • From the available dialog, choose Web Templates -> ASP.NET MVC 4 Web Application
  • I named it as ‘CRUDWithWebAPI’ – you can choose your favorite one :)

    Add asp.net web api application

    Add ASP.NET web API application.
  • Select Empty Web API using Razor View Engine.

    Add asp.net web api application

    Add ASP.NET web API application.

Folder Structure

By default, we get these folders:

  • App_Data
  • App_Start: Contains config classes required to initiate the app (e.g. route collection, etc.)
  • Controllers: Controller of web API
  • Models: Contain model/classes
  • Scripts: All scripts and CSS
  • Views

Default folder structure of asp.net Web API application

Default folder structure of ASP.NET Web API application

More explanation of each and every folder mentioned above is beyond the scope of this article.

Installing FluentNHibernate

To install FluentNHIbernate support to your project:

  • Open ‘Package Manager Console’ using View-> Other Windows
  • Now type ‘Install-Package FluentNHibernate’ and hit enter

Wait till FluentNHibernate gets installed.

Models, Mappings and Repository Pattern

In this step, we will create Model its mapping and will add a repository.

Adding Models and their Mappings

  • To add model, right click on Models folder from Solution Explorer and choose class, name it ‘ServerData’.
    C#
    public class ServerData
      {
          public virtual int Id { get; set; }
          public virtual DateTime InitialDate { get; set; }
          public virtual DateTime EndDate { get; set; }
          public virtual int OrderNumber { get; set; }
          public virtual bool IsDirty { get; set; }
          public virtual string IP { get; set; }
          public virtual int Type { get; set; }
          public virtual int RecordIdentifier { get; set; }
      }
    

    Adding a model

    Adding a Model
  • Add its mapping class, right click on Models folder from Solution Explorer and choose class, name it ‘ServerDataMap’.
    C#
    public class ServerDataMap : ClassMap<ServerData>
      {
          public ServerDataMap()
          {
              Table("ServerData");
    
              Id(x => x.Id, "Id").GeneratedBy.Identity().UnsavedValue(0);
    
              Map(x => x.InitialDate);
              Map(x => x.EndDate);
              Map(x => x.OrderNumber);
              Map(x => x.IsDirty);
              Map(x => x.IP).Length(11);
              Map(x => x.Type).Length(1);
              Map(x => x.RecordIdentifier);
          }
      }
    
  • Do not forget to add the following namespace:
    C#
    using FluentNHibernate.Mapping;
    

Adding NHibernate Support to Your Application

  • Add new folder and name it as ‘Helper’.
  • Add a new class beneath ‘Helper’ folder and name it as ‘NHibernateHelper’.
  • In this class, we need to configure NHibernate and build all sessionfactory, so our application will interact with database:

    C#
    private static void CreateSessionFactory()
       {
           _sessionFactory = Fluently.Configure()
               .Database(MsSqlConfiguration.MsSql2008.ConnectionString(connectionString).ShowSql)
               .Mappings(m => m.FluentMappings.AddFromAssemblyOf<ServerData>())
               .ExposeConfiguration(cfg => new SchemaExport(cfg).Create(false, false))
               .BuildSessionFactory();
       }
    

    We are not going to discuss all this stuff in detail as these are beyond the scope of this article.

  • Create a new folder beneath ‘Models’ and name it as ‘Persistance’.
  • Add one Interface ‘IServerDataRepository’ under ‘Persistance’.
    C#
    public interface IServerDataRepository
       {
           ServerData Get(int id);
           IEnumerable<ServerData> GetAll();
           ServerData Add(ServerData serverData);
           void Delete(int id);
           bool Update(ServerData serverData);
       }
    
  • Add one class ‘ServerDataRepository’ under ‘Persistance’ and implement ‘IServerDataRepository’.
    C#
    public class ServerDataRepository : IServerDataRepository
       {
        //method implementation goes here
       }
    

    Now, we have our Repository which is ready to start play. :)

    Refer to http://msdn.microsoft.com/en-us/library/ff649690.aspx for more details on Repository Pattern.

Add Web API Controller

In this step, we will create all the necessary action methods:

  • Right click on folder ‘Controllers’ and add a new controller, name it as ‘ServerDataController’ (remember to select an empty controller)
  • It would look like:
    C#
    public class ServerDataController : ApiController
      {
      }
    

    Add the following line of code (it will initiate our repository).

    C#
    static readonly IServerDataRepository serverDataRepository = new ServerDataRepository();
    

    Adding web API empty controller

    Adding web API empty controller.
    Quote:

    Please note that in this article/demo, we are not going to implement any DI pattern or Inversion of Control (IOC) framework.

    We are now ready to start the game. :)

    C#
    public IEnumerable<ServerData> GetServerData()
       {
           return serverDataRepository.GetAll();
       }
    

    See the above defined method, why we add ‘Get’ suffix, this is a good practice to add ‘Get’ with your method name, by convention it maps GET request.

    This method does not have any parameter, so, you can say this maps URI which does not contain ‘id’ parameter.

  • Add the following method to get ServerData by id. This is an optional parameter as defined in our route and ASP.NET Web API framework automatically converts its type to int.
  • It will throw ‘HttpResponseException‘ exception if id is not valid (in the following method, we converted the exception to 404 NOT Found exception).
    C#
    public ServerData GetServerDataById(int id)
       {
           var serverData = serverDataRepository.Get(id);
    
           if (serverData == null)
               throw new HttpResponseException(HttpStatusCode.NotFound);
    
           return serverData;
       }
    
  • The following method is to get ServerData by its type:

    C#
    public IEnumerable<ServerData> GetServerDataByType(int type)
      {
          return serverDataRepository.GetAll().Where(d => d.Type == type);
      }
    
  • To invoke the above method, we need to define new routes in ‘WebApiConfig.cs’ as follows:

    C#
    config.Routes.MapHttpRoute(
                   name: "ProductByType",
                   routeTemplate: "api/{controller}/type/{type}"
               );
    
  • Similarly for:

    C#
    public IEnumerable<ServerData> GetServerDataByIP(string ip)
           {
               return serverDataRepository.GetAll().Where(d => d.IP.ToLower() == ip.ToLower());
           }
    
    C#
    config.Routes.MapHttpRoute(
                   name: "ProductByIP",
                   routeTemplate: "api/{controller}/ip/{ip}"
               );
    
  • Here, we are going to delete serverdata using this method:

    C#
    public void DeletServerData(int id)
       {
           var serverData = serverDataRepository.Get(id);
    
           if (serverData == null)
               throw new HttpResponseException(HttpStatusCode.NotFound);
           serverDataRepository.Delete(id);
       }
    
  • Let's add a new method to our controller to add new record of ServerData.

    C#
    public ServerData PostServerData(ServerData serverData)
    {
        return serverDataRepository.Add(serverData);
    }
    

Will the above method work? Of course, it works, but it's not an ideal method or say it's not quite complete, why?

  • In the above, suffix is ‘Post’ which sounds like it sends Http POST request.
  • Also, it's noticeable parameter is of type ‘ServerData’.
  • Complex type parameters are deserialized from the requested body when we used Web API, also, we can say we expect serialized input from client like either in XML or JSON.
  • In the above method, we miss the following from HTTP response:
    • Response code: by default, it is 200 (Ok) but as per HTTP1.1 protocol, the server should reply 201 (created), while POST request results in the creation of a resource.
    • Location: Server should include the URI of the new resource in the location header of the response, whenever it creates a resource.
  • So, we can implement this as defined in the following methods:
    C#
    public HttpResponseMessage PostServerData(ServerData serverData)
      {
          serverData = serverDataRepository.Add(serverData);
    
          var response = Request.CreateResponse<ServerData>(HttpStatusCode.Created, serverData);
    
          var uri = Url.Link("DefaultApi", new { id = serverData.Id });
          response.Headers.Location = new Uri(uri);
    
          return response;
      }
    
  • Finally, we need to add an update method, it's straight forward:
    C#
    public void PutServerData(int id, ServerData serverData)
       {
           serverData.Id = id;
    
           if (!serverDataRepository.Update(serverData))
               throw new HttpResponseException(HttpStatusCode.NotFound);
       }
    

    From the above, we can understand that WEB API matches this method to PUT request, the above method has two parameter ids and serverdata. So, id is taken from URI path and serverdata is deserialized from the request body.

Quote:

Please note that by-default Web API framework takes simple parameter types from the route and complex types from the request body.

Set Default Result Output Type

We need result in JSON by default, let's add the following line either in Global.asx.cs file or in the file where you are registering routes:

C#
//return JSON response by default
config.Formatters.JsonFormatter.SupportedMediaTypes.Add(new MediaTypeHeaderValue("text/html"));

Testing Web API Results

Here, I used ‘Poster for Firefox’ plug in to test the output. You can directly download this plug in from plug in directory of Firefox:

Requesting a GET operation using Poster for Firefox

Requesting a GET operation using Poster for Firefox

Just enter the URI and press GET or whatever you want to play, you will get the output accordingly. :)

Response of a GET from Poster for Firefox

Response of a GET from Poster for Firefox

What To Do Next?

This is a very good video tutorial from Questpond on ‘REST (Representational State Transfer)’ to understand about REST services.

Closing Notes

I hope you enjoyed this article. I tried to make this as simple as I can. If you like this article, please rate it and share it to share the knowledge.

License

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


Written By
Chief Technology Officer
India India
Learning never ends.

Comments and Discussions

 
QuestionSomething wrong! Pin
Bui Tan Duoc21-Apr-17 1:04
professionalBui Tan Duoc21-Apr-17 1:04 
AnswerRe: Something wrong! Pin
Gaurav Aroraa22-Apr-17 8:07
professionalGaurav Aroraa22-Apr-17 8:07 
QuestionThank you Pin
Member 1133784722-Feb-16 5:18
Member 1133784722-Feb-16 5:18 
GeneralThanks for source code Pin
Shuby Arora13-Mar-15 5:40
Shuby Arora13-Mar-15 5:40 
AnswerRe: Thanks for source code Pin
Gaurav Aroraa13-Mar-15 7:49
professionalGaurav Aroraa13-Mar-15 7:49 
QuestionGreat Article Pin
Akash J16-Dec-14 19:29
Akash J16-Dec-14 19:29 
AnswerRe: Great Article Pin
Gaurav Aroraa16-Dec-14 22:04
professionalGaurav Aroraa16-Dec-14 22:04 
GeneralMy Vote 5 Pin
Shemeemsha (ഷെമീംഷ)29-Oct-14 20:11
Shemeemsha (ഷെമീംഷ)29-Oct-14 20:11 
GeneralRe: My Vote 5 Pin
Gaurav Aroraa29-Oct-14 21:11
professionalGaurav Aroraa29-Oct-14 21:11 
QuestionIt was a blog Pin
Nelek26-Oct-14 1:38
protectorNelek26-Oct-14 1:38 
AnswerRe: It was a blog Pin
Gaurav Aroraa26-Oct-14 2:14
professionalGaurav Aroraa26-Oct-14 2:14 
GeneralRe: It was a blog Pin
Nelek26-Oct-14 2:42
protectorNelek26-Oct-14 2:42 
GeneralRe: It was a blog Pin
Gaurav Aroraa26-Oct-14 6:13
professionalGaurav Aroraa26-Oct-14 6:13 
@Nelekk - thanks for your help
Gaurav Arora
http://gaurav-arora.com

GeneralRe: It was a blog Pin
Shuby Arora22-Mar-15 10:59
Shuby Arora22-Mar-15 10:59 
GeneralRe: It was a blog Pin
Gaurav Aroraa23-Mar-15 3:49
professionalGaurav Aroraa23-Mar-15 3:49 
GeneralRe: It was a blog Pin
Nelek23-Mar-15 7:57
protectorNelek23-Mar-15 7:57 
GeneralRe: It was a blog Pin
Shuby Arora23-Mar-15 8:27
Shuby Arora23-Mar-15 8:27 
GeneralRe: It was a blog Pin
Nelek23-Mar-15 8:36
protectorNelek23-Mar-15 8:36 
SuggestionWhy dont you start step-by-step series Pin
Shuby Arora25-Oct-14 8:37
Shuby Arora25-Oct-14 8:37 
GeneralRe: Why dont you start step-by-step series Pin
Gaurav Aroraa25-Oct-14 9:04
professionalGaurav Aroraa25-Oct-14 9:04 
GeneralMy vote ups Pin
Shuby Arora25-Oct-14 8:34
Shuby Arora25-Oct-14 8:34 
GeneralRe: My vote ups Pin
Gaurav Aroraa25-Oct-14 9:02
professionalGaurav Aroraa25-Oct-14 9:02 
GeneralRe: My vote ups Pin
Shuby Arora25-Oct-14 23:46
Shuby Arora25-Oct-14 23:46 
GeneralRe: My vote ups Pin
Gaurav Aroraa26-Oct-14 0:00
professionalGaurav Aroraa26-Oct-14 0:00 

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

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