Dapper Contrib GetAll Discover How to Retrieve All Data From a Table

Description

The Dapper.Contrib library also provides the GetAll<T>() extension method that allows you to retrieve all the data from the database and populate data in your object model.

Parameters

The syntax of the GetAll<T> method is given below:

public static IEnumerable<T> GetAll<T>(IDbTransaction transaction = null, int? commandTimeout = null)

The following table shows the different parameters of a GetAll method.

In the following example, we will use the GetAll method to fetch all the records from the database table.

using (var connection = My.ConnectionFactory())
{
    connection.Open();

    var invoices = connection.GetAll<Invoice>().ToList();
}