August 2017
Intermediate to advanced
330 pages
7h 26m
English
Content preview from Mastering ASP.NET Web API
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...