Class CustomSqlCommandBuilder
Custom Command builder for SQLServer to avoid primary key problems with built-in ones derived (transposed into VB.NET) from https://www.cogin.com/articles/CustomCommandBuilder.php Copyright by Dejan Grujic 2004. http://www.cogin.com
Inherited Members
Namespace: DBaddin
Assembly: DBaddin.dll
Syntax
public class CustomSqlCommandBuilder : CustomCommandBuilder
Constructors
| Improve this Doc View SourceCustomSqlCommandBuilder(DataTable, SqlConnection, DataColumn[], Collection)
Declaration
public CustomSqlCommandBuilder(DataTable dataTable, SqlConnection connection, DataColumn[] allColumns, Collection schemaDataTypeCollection)
Parameters
Name | Description |
---|---|
dataTable | |
connection | |
allColumns | |
schemaDataTypeCollection |
Methods
| Improve this Doc View SourceDeleteCommand()
Creates Delete command
Declaration
public override DbCommand DeleteCommand()
Returns
Description |
---|
SqlCommand for deleting |
Overrides
| Improve this Doc View SourceInsertCommand()
Creates Insert command with support for Auto-increment (Identity) fields
Declaration
public override DbCommand InsertCommand()
Returns
Description |
---|
SqlCommand for inserting |
Overrides
| Improve this Doc View SourceUpdateCommand()
Creates Update command
Declaration
public override DbCommand UpdateCommand()
Returns
Description |
---|
SqlCommand for updating |