 | Sql |
Represents a SQL statement builder tool
Inheritance HierarchyNamespace: SanteDB.OrmLite
Assembly: SanteDB.OrmLite (in SanteDB.OrmLite.dll) Version: 3.0.2081-alpha+d0a78774d3f97b9193d2ae2fef6d129ea9f29519
SyntaxThe SqlStatementBuilder type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | SqlStatementBuilder(IDbStatementFactory, SqlStatement) | Creates a new empty SQL statement |
| SqlStatementBuilder(IDbStatementFactory, String, Object) | Create a new sql statement from the specified sql |
Properties| Name | Description | |
|---|---|---|
 | DbProvider | Get the DB provider |
| Statement | Gets the constructed or set SQL |
Methods| Name | Description | |
|---|---|---|
| And(SqlStatement) | Append an AND condition |
| And(String, Object) | Construct a where clause on the expression tree |
| AndTExpression(ExpressionFuncTExpression, Boolean) | Expression |
| Append(SqlStatement) | Append the SQL statement |
| Append(SqlStatementBuilder) | Append all the commands in otherBuilder |
| Append(String, Object) | Append the specified SQL |
| DeleteFrom | Return a delete from |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| InnerJoinTLeft, TRight | Inner join |
| JoinTLeft, TRight | Join by specific type of join |
| Limit | Limit of the |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| Offset | Append an offset statement |
| Or(SqlStatement) | Append an AND condition |
| Or(String, Object) | Construct a where clause on the expression tree |
| OrderBy(LambdaExpression, SortOrderType) | Construct an order by |
| OrderByTData(ExpressionFuncTData, Object, SortOrderType) | Construct an order by |
| RemoveLast | Removes the last statement from the list |
| RemoveLimit | Remove the limit instruction |
| RemoveOffset | Remove the offset instruction |
| RemoveOrderBy | Remove the ORDER BY clause |
| SelectFrom(Type) | Construct a SELECT FROM statement with the specified selectors |
| SelectFrom(Type, ColumnMapping) | Return a select from |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
| UpdateSet | Generate an update statement |
| UsingAlias | Using an alias for column references |
| Where(LambdaExpression) | Construct a where clause |
| Where(SqlStatement) | Where clause |
| Where(String, Object) | Construct a where clause on the expression tree |
| WhereTExpression(ExpressionFuncTExpression, Boolean) | Construct a where clause on the expression tree |
| WrapAsSubQuery | Wrap as a subquery |
| WrapAsSubQuery(ColumnMapping) | Wrap as a subquery |
Extension Methods| Name | Description | |
|---|---|---|
 | ConvertTReturn |
The purpose of this method is to convert object me to TReturn. Why?
Because if you have an instance of Act that actually needs to be a SubstanceAdministration we can't just cast
so we have to copy.
(Defined by ExtensionMethods) |
| WithControl |
With control parameter is used as a wrapper for _ parameters
(Defined by QueryFilterExtensions) |
See Also