SqlClient ExecuteNonQuery Method Nemiro.Data.dll
Executes a Transact-SQL statement against the connection and returns the number of rows affected. This method is used in conjunction with the properties CommandType, CommandText and Parameters.

Namespace: Nemiro.Data.Sql
Assembly: Nemiro.Data (in Nemiro.Data.dll) Version: (

public int ExecuteNonQuery()

Return Value

Type: Int32

SqlExceptionThe exception that is thrown when SQL Server returns a warning or error.
ValueForIdentityExceptionAn exception occurs if the property of primary key has not flag the Identity and field is autoincrement.
StringOrBinaryDataWouldBeTruncatedExceptionAn exception occurs if some of the fields of the table are added values ​​that exceed the allowable size of a table field.

Caching options are ignored.


using (SqlClient client = new SqlClient())
  client.CommandText = "UPDATE messages SET hits = hits + 1 WHERE id = 42";
  int used = client.ExecuteNonQuery();
  Console.WriteLine("Updated {0} rows.", used);
See Also