Dapper. What Exceptions does conn.Execute throw?

Question

Dapper. What Exceptions does conn.Execute throw?

c# dapper exception

Question

I'm using dapper.net and I've wrapped connection.Execute for my Delete and Update statements.

public virtual void Update(TEntity entity)
{
    IDbConnection connection = connectionService.Connection;

    connection.Execute(UpdateQuery, entity, connectionService.Transaction);
}

When I've come to use this, I want to know if it fails or not by catching an exception(s) and not just a general Exception. Which (if any) exceptions are thrown? I would assume SqlException, but a previous manager taught me to assume nothing.

Can anybody point me in the right direction as to where I find this information?

Jack Pettinger

View more on Stack Overflow

JDTLH9 · Accepted Answer · 7/17/2015 1:09:05 PM

Accepted Answer

Dapper will indeed throw SqlException when used against a SqlConnection.

The exceptions will be consistent with those that you will get from vanilla ADO.NET code. With a value that is the code of the specific SQL exception type.

JDTLH9

Dapper. What Exceptions does conn.Execute throw?

Question

Fastest Dapper Plus Extensions

Accepted Answer

Performance

Expression Evaluator