Dapper - Execute Reader

Description

The ExecuteReader is an extension method that can be called from any object of type IDbConnection. This is typically used when the results of a query are not processed by Dapper. For example, to fill a DataTable or DataSet.

using(var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
{
    var reader = connection.ExecuteReader("SELECT * FROM Customers;");
    DataTable table = new DataTable();
    table.Load(reader);
    FiddleHelper.WriteTable(table);
}

Try it: .NET Core | .NET Framework

Parameters

The following table shows the different parameters of an ExecuteReader method.

Example - Stored Procedure

The ExecuteReader extension method can also execute a stored procedure.

using(var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))
{
    var reader = connection.ExecuteReader("SelectAllCustomers @IsActive = @isActive", new {IsActive = true} );
    DataTable table = new DataTable();
    table.Load(reader);
    FiddleHelper.WriteTable(table);
}

Try it: .NET Core | .NET Framework