SqlQuery.From method (1 of 4)
namespace: Serenity.Data assembly: Serenity.Net.Data
Adds a table to the FROM statement, with given short name.
public SqlQuery From(IAlias alias)
parameter | description |
---|---|
alias | Alias that contains table name and short name. |
Return Value
The query itself.
Remarks
This overload requires that alias has a table name.
See Also
SqlQuery.From method (2 of 4)
namespace: Serenity.Data assembly: Serenity.Net.Data
Adds a table to the FROM statement. When it is called more than once, puts a comma between table names (cross join)
public SqlQuery From(string table)
parameter | description |
---|---|
table | Table name |
Return Value
The query itself.
See Also
- class SqlQuery
SqlQuery.From method (3 of 4)
namespace: Serenity.Data assembly: Serenity.Net.Data
Adds a subquery to the FROM statement, with given short name.
public SqlQuery From(ISqlQuery subQuery, IAlias alias)
parameter | description |
---|---|
subQuery | A subquery |
alias | Alias that contains the short name. |
Return Value
The query itself.
Remarks
This overload requires that alias has a table name.
See Also
SqlQuery.From method (4 of 4)
namespace: Serenity.Data assembly: Serenity.Net.Data
Adds a table to the FROM statement with an alias. When it is called more than once, puts a comma between table names (cross join)
public SqlQuery From(string table, IAlias alias)
parameter | description |
---|---|
table | Table |
alias | Alias for the table |
Return Value
The query itself.