Class BaseInsert

Inheritance
System.Object
BaseInsert
Insert
InsertSelect
Implements
System.ICloneable
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: Terrasoft.Core.DB
Assembly: Terrasoft.Core.dll
Syntax
public abstract class BaseInsert : IParametrizedQuery, ISqlGenerating, ICacheableQuery, ICloneable

Constructors

BaseInsert()

Declaration
protected BaseInsert()

BaseInsert(BaseInsert)

Declaration
protected BaseInsert(BaseInsert source)
Parameters
Type Name Description
BaseInsert source

BaseInsert(UserConnection)

Declaration
protected BaseInsert(UserConnection userConnection)
Parameters
Type Name Description
UserConnection userConnection

Properties

BuildParametersAsValue

Declaration
public bool BuildParametersAsValue { get; set; }
Property Value
Type Description
System.Boolean

CachedSqlText

Declaration
public string CachedSqlText { get; set; }
Property Value
Type Description
System.String

DBEngine

Declaration
protected DBEngine DBEngine { get; }
Property Value
Type Description
DBEngine

HasParameters

Declaration
public bool HasParameters { get; }
Property Value
Type Description
System.Boolean

IsCacheEnabled

Declaration
public bool IsCacheEnabled { get; set; }
Property Value
Type Description
System.Boolean

Parameters

Declaration
public QueryParameterCollection Parameters { get; }
Property Value
Type Description
QueryParameterCollection

Source

Declaration
public ModifyQuerySource Source { get; set; }
Property Value
Type Description
ModifyQuerySource

UserConnection

Declaration
public UserConnection UserConnection { get; set; }
Property Value
Type Description
UserConnection

Methods

BuildSqlText(StringBuilder)

Declaration
public abstract void BuildSqlText(StringBuilder sb)
Parameters
Type Name Description
System.Text.StringBuilder sb

Clone()

Declaration
public abstract object Clone()
Returns
Type Description
System.Object

Execute()

Declaration
public int Execute()
Returns
Type Description
System.Int32

Execute(DBExecutor)

Executes SQL query using given instance of DBExecutor and returns number of affected rows.

Declaration
public int Execute(DBExecutor dbExecutor)
Parameters
Type Name Description
DBExecutor dbExecutor

Instance of DBExecutor, to be used for SQL query.
Returns
Type Description
System.Int32

Number of affected rows.

GetSqlText()

Declaration
public abstract string GetSqlText()
Returns
Type Description
System.String

GetUsingParameters()

Declaration
public virtual QueryParameterCollection GetUsingParameters()
Returns
Type Description
QueryParameterCollection

InitializeParameters()

Declaration
public void InitializeParameters()

ResetCachedSqlText()

Declaration
public void ResetCachedSqlText()

ResetParameters()

Declaration
public void ResetParameters()

SetParameterValue(String, Object)

Sets insert query parameter value.

Declaration
public void SetParameterValue(string name, object value)
Parameters
Type Name Description
System.String name

Parameter name.
System.Object value

Parameter value.

Implements

System.ICloneable

Extension Methods