Class Sql
Inheritance
System.Object
Namespace:System.Dynamic.ExpandoObject
Assembly:Umbraco.Core.dll
Syntax
Constructors
Sql()
Declaration
Sql(String, Object[])
Declaration
public Sql(string sql, params object[] args)
Parameters
Type |
Name |
Description |
System.String |
sql |
|
System.Object[] |
args |
|
Properties
Arguments
Declaration
public object[] Arguments { get; }
Property Value
Type |
Description |
System.Object[] |
|
Builder
Declaration
public static Sql Builder { get; }
Property Value
SQL
Declaration
public string SQL { get; }
Property Value
Type |
Description |
System.String |
|
Methods
Append(String, Object[])
Declaration
public Sql Append(string sql, params object[] args)
Parameters
Type |
Name |
Description |
System.String |
sql |
|
System.Object[] |
args |
|
Returns
Append(Sql)
Declaration
public Sql Append(Sql sql)
Parameters
Type |
Name |
Description |
Sql |
sql |
|
Returns
From(Object[])
Declaration
public Sql From(params object[] tables)
Parameters
Type |
Name |
Description |
System.Object[] |
tables |
|
Returns
GroupBy(Object[])
Declaration
public Sql GroupBy(params object[] columns)
Parameters
Type |
Name |
Description |
System.Object[] |
columns |
|
Returns
InnerJoin(String)
Declaration
public Sql.SqlJoinClause InnerJoin(string table)
Parameters
Type |
Name |
Description |
System.String |
table |
|
Returns
LeftJoin(String)
Declaration
public Sql.SqlJoinClause LeftJoin(string table)
Parameters
Type |
Name |
Description |
System.String |
table |
|
Returns
LeftOuterJoin(String)
Declaration
public Sql.SqlJoinClause LeftOuterJoin(string table)
Parameters
Type |
Name |
Description |
System.String |
table |
|
Returns
OrderBy(Object[])
Declaration
public Sql OrderBy(params object[] columns)
Parameters
Type |
Name |
Description |
System.Object[] |
columns |
|
Returns
RightJoin(String)
Declaration
public Sql.SqlJoinClause RightJoin(string table)
Parameters
Type |
Name |
Description |
System.String |
table |
|
Returns
Select(Object[])
Declaration
public Sql Select(params object[] columns)
Parameters
Type |
Name |
Description |
System.Object[] |
columns |
|
Returns
Where(String, Object[])
Declaration
public Sql Where(string sql, params object[] args)
Parameters
Type |
Name |
Description |
System.String |
sql |
|
System.Object[] |
args |
|
Returns