vitormormul/dotnet-webapi-ef

Example ASP.NET Web API 2 & Entity Framework 6 microservice

dotnet-webapi-ef

A solution I developed in 2015 to get a feel of Web API 2 with Entity Framework.

Table of Contents

• Technology
• Database
• Setup
• API Endpoints
• Dojocat

Technology

This uses the following technology...

• C#
• ASP.NET Web API 2
• Entity Framework 6 (using code first approach)
• JsonPatch
• SimpleInjector
• NUnit
• NSubsitute
• NBuilder
• FluentAssertions

Database

Developed against localdb

Connection string can be found here

Database is seeded with test data, found here

##Setup Restore nuget packages

nuget install

Seed database by typing the following in Package Manager Console

Update-Database

Note: You can more information on seeding here

API endpoints

Replace placeholder {} with actual value

Get all Books

http://localhost:{port}/api/library/books

Get book by Id

http://localhost:{port}/api/library/books/3

Get books by Author

http://localhost:{port}/api/library/authors/{author}/books

Post new book

http://localhost:{port}/api/library/books

{
    "Title": "Austrailia",
    "Isbn": "66666",
    "Author": {
        "Id": 1,
        "Name": "Amy Brown"
    },
    "Publisher": {
        "Id": 1,
        "Name": "O' Reilly"
    }
}

Patch title of existing book using book id

http://localhost:{port}/api/library/books/{id}

[
  { "op": "replace", "path": "Title", "value": "Australia" }
]

More info about other patching operations can be found here

Delete existing book using book id

http://localhost:{port}/api/library/books/{id}

Dojocat

This repo would not be complete without the Dojocat...