Class InsertSelect
Inheritance
System.Object
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()
Assembly: Terrasoft.Core.dll
Syntax
public class InsertSelect : BaseInsert, IParametrizedQuery, ISqlGenerating, ICacheableQuery, ICloneable, IDBCommand
Constructors
InsertSelect(InsertSelect)
Declaration
public InsertSelect(InsertSelect source)
Parameters
InsertSelect(UserConnection)
Declaration
public InsertSelect(UserConnection userConnection)
Parameters
Properties
Columns
Declaration
public ModifyQueryColumnCollection Columns { get; }
Property Value
Select
Declaration
public Select Select { get; set; }
Property Value
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
FromSelect(Select)
Declaration
public InsertSelect FromSelect(Select subSelect)
Parameters
Type |
Name |
Description |
Select |
subSelect |
|
Returns
GetSqlText()
Declaration
public override string GetSqlText()
Returns
Type |
Description |
System.String |
|
Overrides
GetUsingParameters()
Declaration
public override QueryParameterCollection GetUsingParameters()
Returns
Overrides
Into(String)
Declaration
public InsertSelect Into(string schemaName)
Parameters
Type |
Name |
Description |
System.String |
schemaName |
|
Returns
Into(ModifyQuerySource)
Declaration
public InsertSelect Into(ModifyQuerySource source)
Parameters
Returns
Set(IEnumerable<String>)
Declaration
public InsertSelect Set(IEnumerable<string> sourceColumnAliases)
Parameters
Type |
Name |
Description |
System.Collections.Generic.IEnumerable<System.String> |
sourceColumnAliases |
|
Returns
Set(IEnumerable<ModifyQueryColumn>)
Declaration
public InsertSelect Set(IEnumerable<ModifyQueryColumn> columns)
Parameters
Type |
Name |
Description |
System.Collections.Generic.IEnumerable<ModifyQueryColumn> |
columns |
|
Returns
Set(String[])
Declaration
public InsertSelect Set(params string[] sourceColumnAliases)
Parameters
Type |
Name |
Description |
System.String[] |
sourceColumnAliases |
|
Returns
Set(ModifyQueryColumn[])
Declaration
public InsertSelect Set(params ModifyQueryColumn[] columns)
Parameters
Returns
Implements
System.ICloneable
Extension Methods