You often need data that are stored in separate tables. For example, you may want to produce a report that gets information about flight delays from one table and boarding capacity from another.

To map a many-to-many relationship using Dapper, you must handle the join table and make several SQL queries or one well-constructed query to fetch the related data.