Dapper Contrib Get Discover How to Retrieve Data From a Table

Description

To retrieve the desired data the user presents a set of criteria through a query. In SQL, to retrieve data stored in our tables, we use the SELECT statement.

The Dapper.Contrib library provides a Get<T>(id) extension method to retrieve a single record from the database based on the id passed as an argument and populate the data in your object model.

• The Get method is used to fetch a single record from the database.
• The method takes an id as a parameter and returns the matching record from the database.
• If no matching record is found, then the method returns null.

Parameters

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

public static T Get<T>(dynamic id, IDbTransaction transaction = null, int? commandTimeout = null)

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

The following example retrieves a record from the database where the id is 1.

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

    var invoice = connection.Get<Invoice>(1);
}

It will return a single entity by a single id from the table.