Class SqlCommandBuilder

Represents base sql command bulder class.

Inheritance

System.Object

SqlCommandBuilder

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 abstract class SqlCommandBuilder : IDisposable

Constructors

SqlCommandBuilder()

Initializes a new instance of the SqlCommandBuilder class.

Declaration

public SqlCommandBuilder()

SqlCommandBuilder(TableConfig)

Declaration

public SqlCommandBuilder(TableConfig config)

Parameters

Type	Name	Description
TableConfig	config

SqlCommandBuilder(String)

Initializes a new instance of the SqlCommandBuilder class.

Declaration

public SqlCommandBuilder(string table)

Parameters

Type	Name	Description
System.String	table

Properties

Postfixes

Gets the sp body postfix.

Declaration

public StringCollection Postfixes { get; protected set; }

Property Value

Type	Description
StringCollection	The sp body postfix.

Prefixes

Gets the sp body prefix.

Declaration

public StringCollection Prefixes { get; protected set; }

Property Value

Type	Description
StringCollection	The sp body prefix.

Script

Gets or sets the script.

Declaration

public SqlScript Script { get; set; }

Property Value

Type	Description
SqlScript	The script.

TableConfig

Gets the table config.

Declaration

public TableConfig TableConfig { get; protected set; }

Property Value

Type	Description
TableConfig	The table config.

Methods

Build()

Declaration

public void Build()

Clear()

Declaration

public virtual void Clear()

Dispose()

Declaration

public void Dispose()

Dispose(Boolean)

Declaration

protected virtual void Dispose(bool disposing)

Parameters

Type	Name	Description
System.Boolean	disposing

InsertPostfix()

Declaration

protected virtual void InsertPostfix()

InsertPrefixes()

Declaration

protected virtual void InsertPrefixes()

WriteQuery()

Declaration

protected abstract void WriteQuery()

Implements

System.IDisposable