The Dapper Execute method returns a negative value if the query execution fails. Let’s explain in detail with examples.
Dapper is a lightweight Object-Relational Mapping (ORM) framework for .NET. It provides a fast and efficient way to retrieve data from a database using SQL queries.
The Execute
method in Dapper is used to execute a query that does not return any result set, such as an INSERT, UPDATE, or DELETE statement. It returns the number of affected rows as an integer, with a negative value indicating an error or failure.
Here’s an example of how to use the Execute
method:
// Assuming you have a database connection named 'connection'
string sql = "DELETE FROM Users WHERE Id = @UserId";
int userId = 1;
int affectedRows = connection.Execute(sql, new { UserId = userId });
if (affectedRows >= 0)
{
Console.WriteLine("Deletion successful. Affected rows: " + affectedRows);
}
else
{
Console.WriteLine("Deletion failed.");
}
In this example, we are using the Execute
method to delete a user from the “Users” table. The SQL query uses a parameterized query to specify the “Id” of the user to be deleted. The affectedRows
variable will contain the number of affected rows after executing the query.
If the deletion is successful, the value of affectedRows
will be greater than or equal to 0, and a success message will be printed. Otherwise, if the query fails or encounters an error, the value of affectedRows
will be negative, and a failure message will be printed.