Class InsertSelect

Inheritance
System.Object
BaseInsert
InsertSelect
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 class InsertSelect : BaseInsert, IParametrizedQuery, ISqlGenerating, ICacheableQuery, ICloneable, IDBCommand

Constructors

InsertSelect(InsertSelect)

Declaration
public InsertSelect(InsertSelect source)
Parameters
Type Name Description
InsertSelect source

InsertSelect(UserConnection)

Declaration
public InsertSelect(UserConnection userConnection)
Parameters
Type Name Description
UserConnection userConnection

Properties

Columns

Declaration
public ModifyQueryColumnCollection Columns { get; }
Property Value
Type Description
ModifyQueryColumnCollection

Select

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

Methods

BuildSqlText(StringBuilder)

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

Clone()

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

FromSelect(Query)

Declaration
public InsertSelect FromSelect(Query subSelectQuery)
Parameters
Type Name Description
Query subSelectQuery
Returns
Type Description
InsertSelect

FromSelect(Select)

Declaration
public InsertSelect FromSelect(Select subSelect)
Parameters
Type Name Description
Select subSelect
Returns
Type Description
InsertSelect

GetSqlText()

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

GetUsingParameters()

Declaration
public override QueryParameterCollection GetUsingParameters()
Returns
Type Description
QueryParameterCollection
Overrides

Into(String)

Declaration
public InsertSelect Into(string schemaName)
Parameters
Type Name Description
System.String schemaName
Returns
Type Description
InsertSelect

Into(ModifyQuerySource)

Declaration
public InsertSelect Into(ModifyQuerySource source)
Parameters
Type Name Description
ModifyQuerySource source
Returns
Type Description
InsertSelect

Set(IEnumerable<String>)

Declaration
public InsertSelect Set(IEnumerable<string> sourceColumnAliases)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<System.String> sourceColumnAliases
Returns
Type Description
InsertSelect

Set(IEnumerable<ModifyQueryColumn>)

Declaration
public InsertSelect Set(IEnumerable<ModifyQueryColumn> columns)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<ModifyQueryColumn> columns
Returns
Type Description
InsertSelect

Set(String[])

Declaration
public InsertSelect Set(params string[] sourceColumnAliases)
Parameters
Type Name Description
System.String[] sourceColumnAliases
Returns
Type Description
InsertSelect

Set(ModifyQueryColumn[])

Declaration
public InsertSelect Set(params ModifyQueryColumn[] columns)
Parameters
Type Name Description
ModifyQueryColumn[] columns
Returns
Type Description
InsertSelect

Implements

System.ICloneable

Extension Methods