CustomSqlCommandBuilder Class
Custom Command builder for SQLServer class
Inheritance Hierarchy
- System.Object
- DBaddin.CustomCommandBuilder
- DBaddin.CustomSqlCommandBuilder
- DBaddin.CustomCommandBuilder
Namespace: DBaddinAssembly: DBaddin in (DBaddin.dll)
Syntax
public class CustomSqlCommandBuilder : CustomCommandBuilder
The CustomSqlCommandBuilder type exposes the following members.
Constructors
| Class | Summary | |
|---|---|---|
 | CustomSqlCommandBuilder(DataTable, SqlConnection, DataColumn[], Collection) |
Methods
| Name | Summary | |
|---|---|---|
 | CreateOldParam(DataColumn) | build "old" (for where clause) SqlParameter for DataColumn column |
| CreateParam(DataColumn) | build "new" (for set clause) SqlParameter for DataColumn column |
 | DeleteCommand() | Creates Delete command |
| GetTextCommand(String) | build a specific Sql command to be used for the Insert, Update and Delete builders |
| InsertCommand() | Creates Insert command with support for Auto-increment (Identity) fields |
| UpdateCommand() | Creates Update command |
Fields
| Name | Description | |
|---|---|---|
 | connection | the driver specific connection needed to get the driver specific command in GetTextCommand |
| schemaDataTypeCollection | collection for casting .NET data type to ADO.NET DbType in DBModifHelper.TypeToDbType |