November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

Class InsertCommandBuilder

Represents Insert Sql Command this.Script.

Inheritance
System.Object
SqlCommandBuilder
InsertCommandBuilder
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: 12.17.2
Syntax
public class InsertCommandBuilder : SqlCommandBuilder, IDisposable

Constructors

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

true if [primary key has identity]; otherwise, false.

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