Dapper Tutorial Dapper Contrib - GetAll
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.
| Name | Description |
|---|---|
| transaction | It represents a database transaction. This parameter is optional if we are using this method outside of a transaction, otherwise, it is required. |
| commandTimeout | It represents the time in seconds to wait before terminating the command execution and generating an error. The default value of this parameter is 30 seconds. This parameter is optional. |
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(); }