Class InsertCommandBuilder
Represents Insert Sql Command this.Script.
Implements
System.IDisposable
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Mediachase.BusinessFoundation.Data.Sql
Assembly: Mediachase.BusinessFoundation.Data.dll
Version: 11.8.3Syntax
public class InsertCommandBuilder : SqlCommandBuilder, IDisposableConstructors
InsertCommandBuilder(TableConfig)
Initializes a new instance of the InsertCommandBuilder class.
Declaration
public InsertCommandBuilder(TableConfig config)Parameters
| Type | Name | Description |
|---|---|---|
| TableConfig | config | The config. |
InsertCommandBuilder(String)
Initializes a new instance of the InsertCommandBuilder class.
Declaration
public InsertCommandBuilder(string table)Parameters
| Type | Name | Description |
|---|---|---|
| System.String | table |
Properties
PkParameter
Declaration
protected SqlParameter PkParameter { get; set; }Property Value
| Type | Description |
|---|---|
| System.Data.SqlClient.SqlParameter |
PrimaryKeyHasIdentity
Gets a value indicating whether [primary key has identity].
Declaration
public bool PrimaryKeyHasIdentity { get; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
|
PrimaryKeyId
Gets the primary key id.
Declaration
public PrimaryKeyId? PrimaryKeyId { get; }Property Value
| Type | Description |
|---|---|
| System.Nullable<PrimaryKeyId> | The primary key id. |
Values
Gets the values.
Declaration
public Dictionary<string, object> Values { get; protected set; }Property Value
| Type | Description |
|---|---|
| System.Collections.Generic.Dictionary<System.String, System.Object> | The values. |
Methods
Build(Dictionary<String, Object>)
Declaration
public void Build(Dictionary<string, object> values)Parameters
| Type | Name | Description |
|---|---|---|
| System.Collections.Generic.Dictionary<System.String, System.Object> | values |
Clear()
Declaration
public override void Clear()Overrides
Dispose(Boolean)
Declaration
protected override void Dispose(bool disposing)Parameters
| Type | Name | Description |
|---|---|---|
| System.Boolean | disposing |
Overrides
WriteExtendedTableInsert(Table)
Writes the extended table.
Declaration
protected virtual void WriteExtendedTableInsert(Table extTable)Parameters
| Type | Name | Description |
|---|---|---|
| Table | extTable | The ext table. |
WriteExtendedTableInsertColumns(ColumnCollection)
Writes the extended table insert columns.
Declaration
protected virtual void WriteExtendedTableInsertColumns(ColumnCollection columns)Parameters
| Type | Name | Description |
|---|---|---|
| ColumnCollection | columns | The columns. |
WriteExtendedTableInsertColumnValues(ColumnCollection)
Writes the extended table insert column values.
Declaration
protected virtual void WriteExtendedTableInsertColumnValues(ColumnCollection columns)Parameters
| Type | Name | Description |
|---|---|---|
| ColumnCollection | columns | The columns. |
WriteInsertColumnValue(Column)
Writes the insert column value.
Declaration
protected virtual void WriteInsertColumnValue(Column column)Parameters
| Type | Name | Description |
|---|---|---|
| Column | column | The column. |
WritePrimaryTableInsert()
Writes the primary table insert.
Declaration
protected virtual void WritePrimaryTableInsert()WritePrimaryTableInsertColumns(ColumnCollection)
Writes the primary table insert columns.
Declaration
protected virtual void WritePrimaryTableInsertColumns(ColumnCollection columns)Parameters
| Type | Name | Description |
|---|---|---|
| ColumnCollection | columns | The columns. |
WritePrimaryTableInsertColumnValues(ColumnCollection)
Writes the primary table insert column values.
Declaration
protected virtual void WritePrimaryTableInsertColumnValues(ColumnCollection columns)Parameters
| Type | Name | Description |
|---|---|---|
| ColumnCollection | columns | The columns. |
WritePrimaryTableInsertNoColumns()
Writes the primary table insert no columns.
Declaration
protected virtual void WritePrimaryTableInsertNoColumns()WriteQuery()
Writes the query.
Declaration
protected override void WriteQuery()Overrides
WriteSelectIdentity()
Writes the select identity.
Declaration
protected virtual void WriteSelectIdentity()Implements
System.IDisposable
