| title | Using Commands to modify data |
|---|---|
| description | Describes how to use a data provider to execute stored procedures or data definition language (DDL) statements. |
| author | David-Engel |
| ms.author | davidengel |
| ms.reviewer | v-chmalh |
| ms.date | 11/25/2020 |
| ms.service | sql |
| ms.subservice | connectivity |
| ms.topic | concept-article |
[!INCLUDE dotnet-all]
[!INCLUDEDriver_ADONET_Download]
Using the Microsoft SqlClient Data Provider for SQL Server, you can execute stored procedures or data definition language statements (for example, CREATE TABLE and ALTER COLUMN) to perform schema manipulation on a database or catalog. These commands do not return rows as a query would, so the xref:Microsoft.Data.SqlClient.SqlCommand object provides an xref:Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery%2A to process them.
In addition to using ExecuteNonQuery to modify schema, you can also use this method to process SQL statements that modify data but that do not return rows, such as INSERT, UPDATE, and DELETE.
Although rows are not returned by the ExecuteNonQuery method, input and output parameters and return values can be passed and returned via the Parameters collection of the Command object.
Updating data in a data source
Describes how to execute commands or stored procedures that modify data in a database.
Performing catalog operations
Describes how to execute commands that modify database schema.