Book Image

Mastering ASP.NET Web API

By : Mithun Pattankar
Book Image

Mastering ASP.NET Web API

By: Mithun Pattankar

Overview of this book

Microsoft has unified their main web development platforms. This unification will help develop web applications using various pieces of the ASP.NET platform that can be deployed on both Windows and LINUX. With ASP.NET Core (Web API), it will become easier than ever to build secure HTTP services that can be used from any client. Mastering ASP.NET Web API starts with the building blocks of the ASP.NET Core, then gradually moves on to implementing various HTTP routing strategies in the Web API. We then focus on the key components of building applications that employ the Web API, such as Kestrel, Middleware, Filters, Logging, Security, and Entity Framework.Readers will be introduced to take the TDD approach to write test cases along with the new Visual Studio 2017 live unit testing feature. They will also be introduced to integrate with the database using ORMs. Finally, we explore how the Web API can be consumed in a browser as well as by mobile applications by utilizing Angular 4, Ionic and ReactJS. By the end of this book, you will be able to apply best practices to develop complex Web API, consume them in frontend applications and deploy these applications to a modern hosting infrastructure.
Table of Contents (14 chapters)

Integrating using Dapper

Dapper is an open source simple object mapper for .NET-based applications. It's also referred to as Micro ORM when compared with Entity Framework or NHibernate.

It extends the IDbConnection interface and does not depend on any specific DB implementation; this makes it work with almost all relational databases, such as SQLite, SQL CE, Firebird, Oracle, MySQL, PostgreSQL, and SQL Server.

It's considered as the king of ORM for being lightweight, high performance among other ORM. I recommend reading their GitHub repo at https://github.com/StackExchange/dapper-dot-net.

As Dapper is used with an existing database, we will use the same AdventureWorks2014 database for it. In this section, we will work with the HumanResources.Department table.

Let's create an ASP.NET Core Web API application integrating with the AdventureWorks2014 database using...