<PackageReference Include="System.Data.SqlClient" Version="4.8.3" />

SqlCommandBuilder

public sealed class SqlCommandBuilder : DbCommandBuilder
Automatically generates single-table commands that are used to reconcile changes made to a DataSet with the associated SQL Server database. This class cannot be inherited.
public SqlDataAdapter DataAdapter { get; set; }

Gets or sets a SqlDataAdapter object for which Transact-SQL statements are automatically generated.

public SqlCommandBuilder()

Initializes a new instance of the SqlCommandBuilder class.

public SqlCommandBuilder(SqlDataAdapter adapter)

Initializes a new instance of the SqlCommandBuilder class with the associated SqlDataAdapter object.

public static void DeriveParameters(SqlCommand command)

Retrieves parameter information from the stored procedure specified in the SqlCommand and populates the Parameters collection of the specified SqlCommand object.

public SqlCommand GetDeleteCommand()

Gets the automatically generated SqlCommand object required to perform deletions on the database.

public SqlCommand GetDeleteCommand(bool useColumnsForParameterNames)

Gets the automatically generated SqlCommand object that is required to perform deletions on the database.

public SqlCommand GetInsertCommand()

Gets the automatically generated SqlCommand object required to perform insertions on the database.

public SqlCommand GetInsertCommand(bool useColumnsForParameterNames)

Gets the automatically generated SqlCommand object that is required to perform insertions on the database.

public SqlCommand GetUpdateCommand()

Gets the automatically generated SqlCommand object required to perform updates on the database.

public SqlCommand GetUpdateCommand(bool useColumnsForParameterNames)

Gets the automatically generated SqlCommand object required to perform updates on the database.