CustomCommandBuilder Class
Custom Command builder base class for SQL Server, ODBC and OLE DB 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
Inheritance Hierarchy
- System.Object
- DBaddin.CustomCommandBuilder
Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)
Syntax
public class CustomCommandBuilder
The CustomCommandBuilder type exposes the following members.
Constructors
| Class | Summary | |
|---|---|---|
 | CustomCommandBuilder(DataTable, DataColumn[], Boolean) |
Methods
| Name | Summary | |
|---|---|---|
 | AutoincrementKeyColumns() | get auto increment columns |
 | DeleteCommand() | Creates Delete command |
| InsertCommand() | Creates Insert command with support for Auto-increment (Identity) fields |
| TableName() | build correct quoted table name from the dataTables TableName |
| UpdateCommand() | Creates Update command |
Fields
| Name | Description | |
|---|---|---|
 | allColumns | array of all column information (DataColumn) in the data table |
| dataTable | the data table to get all the schema information from |
| preventAutoInc | Used to avoid creation of auto increment code (avoids SELECT SCOPE_IDENTITY()) |