Loading

How to get updated row count in _dapper?

Akash Dani

How to get updated row count while using update query in oracle using _dapper.Please help me.

I can update the query using _dapper but I cant get the updated row count

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Akash Dani5y ago
Thanks Sachin brother
It was my mistake.I checked that update query in oracle but I forget to commit.So it didn't give the row count when I tried that from application.
now its working fine after commit.
0
Sachin Singh5y ago
Execute() extension method gives you the row affected by your update /delete/insert query.
string sql = "UPDATE Invoice SET Code = @Code WHERE InvoiceID = @InvoiceID";

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

    var affectedRows = connection.Execute(sql, new {InvoiceID = 1, Code = "Single_Update_1"});

    My.Result.Show(affectedRows);
}
+1