Méthode | Description | |
---|---|---|
AllRowsMatchColumnValue ( this table, int columnOffset, SqlExpressionType op, Field value ) : bool | ||
AnyRowMatchesColumnValue ( this table, int columnOffset, SqlExpressionType op, Field value ) : bool | ||
Composite ( this table, ITable other, CompositeFunction function, bool all ) : ITable | ||
DistinctBy ( this table, ObjectName columnNames ) : ITable | ||
DistinctBy ( this table, int columns ) : ITable | ||
EmptySelect ( this table ) : ITable | ||
Execept ( this table, ITable other, bool all ) : ITable | ||
ExhaustiveSelect ( this table, IRequest context, |
||
Exists ( this table, int columnOffset, Field value ) : bool | ||
Exists ( this table, int columnOffset1, Field value1, int columnOffset2, Field value2 ) : bool | ||
FindKeys ( this table, int columnOffsets, Field keyValue ) : IEnumerable |
||
GetColumn ( this table, int columnOffset ) : Column | ||
GetColumn ( this table, string columnName ) : Column | ||
GetFirstValue ( this table, int columnOffset ) : Field | ||
GetFirstValue ( this table, string columnName ) : Field | ||
GetFirstValues ( this table, int columnOffsets ) : Field[] | ||
GetLastValue ( this table, int columnOffset ) : Field | ||
GetLastValue ( this table, string columnName ) : Field | ||
GetLastValues ( this table, int columnOffsets ) : Field[] | ||
GetRow ( this table, int rowNumber ) : Deveel.Data.Sql.Tables.Row | ||
GetSingleValue ( this table, int columnOffset ) : Field | ||
GetSingleValue ( this table, string columnName ) : Field | ||
GetSingleValues ( this table, int columnOffsets ) : Field[] | ||
GetValue ( this table, int rowIndex, ObjectName columnName ) : Field | ||
GetValue ( this table, int rowIndex, string columnName ) : Field | ||
IndexOfColumn ( this table, ObjectName columnName ) : int | ||
IndexOfColumn ( this table, string columnName ) : int | ||
Intersect ( this table, ITable other, bool all ) : ITable | ||
Join ( this table, IRequest context, ITable other, ObjectName columnName, SqlExpressionType operatorType, |
||
Join ( this table, ITable otherTable, bool quick ) : ITable | ||
NaturalJoin ( this table, ITable otherTable ) : ITable | ||
NotIn ( this table, ITable otherTable, int tableColumns, int otherColumns ) : ITable | ||
OrderBy ( this table, ObjectName columnName, bool ascending ) : ITable | ||
OrderBy ( this table, int columns ) : ITable | ||
OrderBy ( this table, int columnIndex, bool ascending ) : ITable | ||
OrderBy ( this table, string columnName, bool ascending ) : ITable | ||
OrderRowsByColumns ( this table, int columns ) : IEnumerable |
||
OuterJoin ( this table, ITable rightTable ) : ITable | ||
Search ( this table, int column, string pattern ) : IEnumerable |
||
Search ( this table, int column, string pattern, char escapeChar ) : IEnumerable |
||
SelecRowsLess ( this table, int columnOffset, Field value ) : IEnumerable |
||
SelecRowsLess ( this table, int columnOffset, System.Objects value ) : IEnumerable |
||
Select ( this table, IRequest context, |
||
SelectAll ( this table, int columnOffset ) : ITable | ||
SelectAllRows ( this table ) : IEnumerable |
||
SelectAllRows ( this table, int columnOffset ) : IEnumerable |
||
SelectAnyAllNonCorrelated ( this table, ObjectName leftColumns, SqlExpressionType op, bool all, ITable rightTable ) : ITable | ||
SelectEqual ( this table, int columnIndex, Field value ) : ITable | ||
SelectEqual ( this table, string columnName, Field value ) : ITable | ||
SelectFirst ( this table, int columnOffset ) : IEnumerable |
||
SelectFromPattern ( this table, int column, SqlExpressionType op, Field ob ) : IEnumerable |
||
SelectLast ( this table, int columnOffset ) : IEnumerable |
||
SelectNotEqual ( this table, int columnOffset, Field value ) : IEnumerable |
||
SelectNotEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable |
||
SelectRange ( this thisTable, ObjectName columnName, |
||
SelectRows ( this table, IVariableResolver resolver, IRequest context, |
||
SelectRows ( this table, int columnOffsets, SqlExpressionType op, Field values ) : IEnumerable |
||
SelectRowsBetween ( this table, int column, Field minCell, Field maxCell ) : IEnumerable |
||
SelectRowsEqual ( this table, int columnIndex, Field value ) : IEnumerable |
||
SelectRowsEqual ( this table, int columnIndex1, Field value1, int columnIndex2, Field value2 ) : IEnumerable |
||
SelectRowsEqual ( this table, string columnName, Field value ) : IEnumerable |
||
SelectRowsGreater ( this table, int columnOffset, Field value ) : IEnumerable |
||
SelectRowsGreater ( this table, int columnOffset, System.Objects value ) : IEnumerable |
||
SelectRowsGreaterOrEqual ( this table, int columnOffset, Field value ) : IEnumerable |
||
SelectRowsGreaterOrEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable |
||
SelectRowsIn ( this table, ITable other, int column1, int column2 ) : IEnumerable |
This implements the
|
|
SelectRowsLessOrEqual ( this table, int columnOffset, Field value ) : IEnumerable |
||
SelectRowsLessOrEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable |
||
SelectRowsNotIn ( this table, ITable other, int col1, int col2 ) : IEnumerable |
This implements the Issue: This will be less efficient than |
|
SelectRowsRange ( this table, int column, |
||
SimpleJoin ( this thisTable, IRequest context, ITable other, |
||
SimpleSelect ( this table, IRequest context, ObjectName columnName, SqlExpressionType op, |
||
Subset ( this table, ObjectName columnNames, ObjectName aliases ) : ITable | ||
ToDictionary ( this table ) : Objects.ISqlObject>.Dictionary |
||
Union ( this thisTable, ITable otherTable ) : ITable |
Méthode | Description | |
---|---|---|
AsVirtual ( this table, Func |
||
MakeObject ( this table, int columnOffset, System.Objects value ) : Field |
public static AllRowsMatchColumnValue ( this table, int columnOffset, SqlExpressionType op, Field value ) : bool | ||
table | this | |
columnOffset | int | |
op | SqlExpressionType | |
value | Field | |
Résultat | bool |
public static AnyRowMatchesColumnValue ( this table, int columnOffset, SqlExpressionType op, Field value ) : bool | ||
table | this | |
columnOffset | int | |
op | SqlExpressionType | |
value | Field | |
Résultat | bool |
public static Composite ( this table, ITable other, CompositeFunction function, bool all ) : ITable | ||
table | this | |
other | ITable | |
function | CompositeFunction | |
all | bool | |
Résultat | ITable |
public static DistinctBy ( this table, ObjectName columnNames ) : ITable | ||
table | this | |
columnNames | ObjectName | |
Résultat | ITable |
public static DistinctBy ( this table, int columns ) : ITable | ||
table | this | |
columns | int | |
Résultat | ITable |
public static EmptySelect ( this table ) : ITable | ||
table | this | |
Résultat | ITable |
public static Execept ( this table, ITable other, bool all ) : ITable | ||
table | this | |
other | ITable | |
all | bool | |
Résultat | ITable |
public static ExhaustiveSelect ( this table, IRequest context, |
||
table | this | |
context | IRequest | |
expression | ||
Résultat | ITable |
public static Exists ( this table, int columnOffset, Field value ) : bool | ||
table | this | |
columnOffset | int | |
value | Field | |
Résultat | bool |
public static Exists ( this table, int columnOffset1, Field value1, int columnOffset2, Field value2 ) : bool | ||
table | this | |
columnOffset1 | int | |
value1 | Field | |
columnOffset2 | int | |
value2 | Field | |
Résultat | bool |
public static FindKeys ( this table, int columnOffsets, Field keyValue ) : IEnumerable |
||
table | this | |
columnOffsets | int | |
keyValue | Field | |
Résultat | IEnumerable |
public static GetColumn ( this table, int columnOffset ) : Column | ||
table | this | |
columnOffset | int | |
Résultat | Column |
public static GetColumn ( this table, string columnName ) : Column | ||
table | this | |
columnName | string | |
Résultat | Column |
public static GetFirstValue ( this table, int columnOffset ) : Field | ||
table | this | |
columnOffset | int | |
Résultat | Field |
public static GetFirstValue ( this table, string columnName ) : Field | ||
table | this | |
columnName | string | |
Résultat | Field |
public static GetFirstValues ( this table, int columnOffsets ) : Field[] | ||
table | this | |
columnOffsets | int | |
Résultat | Field[] |
public static GetLastValue ( this table, int columnOffset ) : Field | ||
table | this | |
columnOffset | int | |
Résultat | Field |
public static GetLastValue ( this table, string columnName ) : Field | ||
table | this | |
columnName | string | |
Résultat | Field |
public static GetLastValues ( this table, int columnOffsets ) : Field[] | ||
table | this | |
columnOffsets | int | |
Résultat | Field[] |
public static GetRow ( this table, int rowNumber ) : Deveel.Data.Sql.Tables.Row | ||
table | this | |
rowNumber | int | |
Résultat | Deveel.Data.Sql.Tables.Row |
public static GetSingleValue ( this table, int columnOffset ) : Field | ||
table | this | |
columnOffset | int | |
Résultat | Field |
public static GetSingleValue ( this table, string columnName ) : Field | ||
table | this | |
columnName | string | |
Résultat | Field |
public static GetSingleValues ( this table, int columnOffsets ) : Field[] | ||
table | this | |
columnOffsets | int | |
Résultat | Field[] |
public static GetValue ( this table, int rowIndex, ObjectName columnName ) : Field | ||
table | this | |
rowIndex | int | |
columnName | ObjectName | |
Résultat | Field |
public static GetValue ( this table, int rowIndex, string columnName ) : Field | ||
table | this | |
rowIndex | int | |
columnName | string | |
Résultat | Field |
public static IndexOfColumn ( this table, ObjectName columnName ) : int | ||
table | this | |
columnName | ObjectName | |
Résultat | int |
public static IndexOfColumn ( this table, string columnName ) : int | ||
table | this | |
columnName | string | |
Résultat | int |
public static Intersect ( this table, ITable other, bool all ) : ITable | ||
table | this | |
other | ITable | |
all | bool | |
Résultat | ITable |
public static Join ( this table, IRequest context, ITable other, ObjectName columnName, SqlExpressionType operatorType, |
||
table | this | |
context | IRequest | |
other | ITable | |
columnName | ObjectName | |
operatorType | SqlExpressionType | |
expression | ||
Résultat | ITable |
public static Join ( this table, ITable otherTable, bool quick ) : ITable | ||
table | this | |
otherTable | ITable | |
quick | bool | |
Résultat | ITable |
public static NaturalJoin ( this table, ITable otherTable ) : ITable | ||
table | this | |
otherTable | ITable | |
Résultat | ITable |
public static NotIn ( this table, ITable otherTable, int tableColumns, int otherColumns ) : ITable | ||
table | this | |
otherTable | ITable | |
tableColumns | int | |
otherColumns | int | |
Résultat | ITable |
public static OrderBy ( this table, ObjectName columnName, bool ascending ) : ITable | ||
table | this | |
columnName | ObjectName | |
ascending | bool | |
Résultat | ITable |
public static OrderBy ( this table, int columns ) : ITable | ||
table | this | |
columns | int | |
Résultat | ITable |
public static OrderBy ( this table, int columnIndex, bool ascending ) : ITable | ||
table | this | |
columnIndex | int | |
ascending | bool | |
Résultat | ITable |
public static OrderBy ( this table, string columnName, bool ascending ) : ITable | ||
table | this | |
columnName | string | |
ascending | bool | |
Résultat | ITable |
public static OrderRowsByColumns ( this table, int columns ) : IEnumerable |
||
table | this | |
columns | int | |
Résultat | IEnumerable |
public static OuterJoin ( this table, ITable rightTable ) : ITable | ||
table | this | |
rightTable | ITable | |
Résultat | ITable |
public static Search ( this table, int column, string pattern ) : IEnumerable |
||
table | this | |
column | int | |
pattern | string | |
Résultat | IEnumerable |
public static Search ( this table, int column, string pattern, char escapeChar ) : IEnumerable |
||
table | this | |
column | int | |
pattern | string | |
escapeChar | char | |
Résultat | IEnumerable |
public static SelecRowsLess ( this table, int columnOffset, Field value ) : IEnumerable |
||
table | this | |
columnOffset | int | |
value | Field | |
Résultat | IEnumerable |
public static SelecRowsLess ( this table, int columnOffset, System.Objects value ) : IEnumerable |
||
table | this | |
columnOffset | int | |
value | System.Objects | |
Résultat | IEnumerable |
public static Select ( this table, IRequest context, |
||
table | this | |
context | IRequest | |
expression | ||
Résultat | ITable |
public static SelectAll ( this table, int columnOffset ) : ITable | ||
table | this | |
columnOffset | int | |
Résultat | ITable |
public static SelectAllRows ( this table ) : IEnumerable |
||
table | this | |
Résultat | IEnumerable |
public static SelectAllRows ( this table, int columnOffset ) : IEnumerable |
||
table | this | |
columnOffset | int | |
Résultat | IEnumerable |
public static SelectAnyAllNonCorrelated ( this table, ObjectName leftColumns, SqlExpressionType op, bool all, ITable rightTable ) : ITable | ||
table | this | |
leftColumns | ObjectName | |
op | SqlExpressionType | |
all | bool | |
rightTable | ITable | |
Résultat | ITable |
public static SelectEqual ( this table, int columnIndex, Field value ) : ITable | ||
table | this | |
columnIndex | int | |
value | Field | |
Résultat | ITable |
public static SelectEqual ( this table, string columnName, Field value ) : ITable | ||
table | this | |
columnName | string | |
value | Field | |
Résultat | ITable |
public static SelectFirst ( this table, int columnOffset ) : IEnumerable |
||
table | this | |
columnOffset | int | |
Résultat | IEnumerable |
public static SelectFromPattern ( this table, int column, SqlExpressionType op, Field ob ) : IEnumerable |
||
table | this | |
column | int | |
op | SqlExpressionType | |
ob | Field | |
Résultat | IEnumerable |
public static SelectLast ( this table, int columnOffset ) : IEnumerable |
||
table | this | |
columnOffset | int | |
Résultat | IEnumerable |
public static SelectNotEqual ( this table, int columnOffset, Field value ) : IEnumerable |
||
table | this | |
columnOffset | int | |
value | Field | |
Résultat | IEnumerable |
public static SelectNotEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable |
||
table | this | |
columnOffset | int | |
value | System.Objects | |
Résultat | IEnumerable |
public static SelectRange ( this thisTable, ObjectName columnName, |
||
thisTable | this | |
columnName | ObjectName | |
ranges | ||
Résultat | ITable |
public static SelectRows ( this table, IVariableResolver resolver, IRequest context, |
||
table | this | |
resolver | IVariableResolver | |
context | IRequest | |
expression | ||
Résultat | IEnumerable |
public static SelectRows ( this table, int columnOffsets, SqlExpressionType op, Field values ) : IEnumerable |
||
table | this | |
columnOffsets | int | |
op | SqlExpressionType | |
values | Field | |
Résultat | IEnumerable |
public static SelectRowsBetween ( this table, int column, Field minCell, Field maxCell ) : IEnumerable |
||
table | this | |
column | int | |
minCell | Field | |
maxCell | Field | |
Résultat | IEnumerable |
public static SelectRowsEqual ( this table, int columnIndex, Field value ) : IEnumerable |
||
table | this | |
columnIndex | int | |
value | Field | |
Résultat | IEnumerable |
public static SelectRowsEqual ( this table, int columnIndex1, Field value1, int columnIndex2, Field value2 ) : IEnumerable |
||
table | this | |
columnIndex1 | int | |
value1 | Field | |
columnIndex2 | int | |
value2 | Field | |
Résultat | IEnumerable |
public static SelectRowsEqual ( this table, string columnName, Field value ) : IEnumerable |
||
table | this | |
columnName | string | |
value | Field | |
Résultat | IEnumerable |
public static SelectRowsGreater ( this table, int columnOffset, Field value ) : IEnumerable |
||
table | this | |
columnOffset | int | |
value | Field | |
Résultat | IEnumerable |
public static SelectRowsGreater ( this table, int columnOffset, System.Objects value ) : IEnumerable |
||
table | this | |
columnOffset | int | |
value | System.Objects | |
Résultat | IEnumerable |
public static SelectRowsGreaterOrEqual ( this table, int columnOffset, Field value ) : IEnumerable |
||
table | this | |
columnOffset | int | |
value | Field | |
Résultat | IEnumerable |
public static SelectRowsGreaterOrEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable |
||
table | this | |
columnOffset | int | |
value | System.Objects | |
Résultat | IEnumerable |
public static SelectRowsIn ( this table, ITable other, int column1, int column2 ) : IEnumerable |
||
table | this | |
other | ITable | |
column1 | int | |
column2 | int | |
Résultat | IEnumerable |
public static SelectRowsLessOrEqual ( this table, int columnOffset, Field value ) : IEnumerable |
||
table | this | |
columnOffset | int | |
value | Field | |
Résultat | IEnumerable |
public static SelectRowsLessOrEqual ( this table, int columnOffset, System.Objects value ) : IEnumerable |
||
table | this | |
columnOffset | int | |
value | System.Objects | |
Résultat | IEnumerable |
public static SelectRowsNotIn ( this table, ITable other, int col1, int col2 ) : IEnumerable |
||
table | this | |
other | ITable | |
col1 | int | |
col2 | int | |
Résultat | IEnumerable |
public static SelectRowsRange ( this table, int column, |
||
table | this | |
column | int | |
ranges | ||
Résultat | IEnumerable |
public static SimpleJoin ( this thisTable, IRequest context, ITable other, |
||
thisTable | this | |
context | IRequest | |
other | ITable | |
binary | ||
Résultat | ITable |
public static SimpleSelect ( this table, IRequest context, ObjectName columnName, SqlExpressionType op, |
||
table | this | |
context | IRequest | |
columnName | ObjectName | |
op | SqlExpressionType | |
exp | ||
Résultat | ITable |
public static Subset ( this table, ObjectName columnNames, ObjectName aliases ) : ITable | ||
table | this | |
columnNames | ObjectName | |
aliases | ObjectName | |
Résultat | ITable |
public static ToDictionary ( this table ) : Objects.ISqlObject>.Dictionary |
||
table | this | |
Résultat | Objects.ISqlObject>.Dictionary |
public static Union ( this thisTable, ITable otherTable ) : ITable | ||
thisTable | this | |
otherTable | ITable | |
Résultat | ITable |