 | SqlStatement Class |
Represents a SQL statement builder tool
Inheritance HierarchyNamespace: SanteDB.OrmLite
Assembly: SanteDB.OrmLite (in SanteDB.OrmLite.dll) Version: 2.2.1
SyntaxThe SqlStatement type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | SqlStatement(IDbProvider) |
Creates a new empty SQL statement
|
| SqlStatement(IDbProvider, String, Object) |
Create a new sql statement from the specified sql
|
Properties| Name | Description | |
|---|---|---|
 | Arguments |
Arguments for the SQL Statement
|
| DbProvider |
Get the DB provider
|
| IsFinalized |
True if the sql statement is finalized
|
| SQL |
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(String, Object) |
Append the specified SQL
|
| Build |
Build the special SQL statement
|
| 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.) |
| GetLast |
Get the last statement
|
| GetMember |
Get member information from lambda
|
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| InnerJoin(Type, Type) |
Inner join left and right
|
| InnerJoinTLeft, TRight(ExpressionFuncTLeft, Object, ExpressionFuncTRight, Object) |
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
|
| OrderByTExpression |
Construct an order by
|
| RemoveLast |
Removes the last statement from the list
|
| RemoveLast(SqlStatement) |
Removes the last statement from the list
|
| SelectFrom(Type) |
Return a select from
|
| SelectFrom(Type, ColumnMapping) |
Return a select from
|
| ToString |
Represent as string
(Overrides ObjectToString.) |
| 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
|
Fields| Name | Description | |
|---|---|---|
 | m_arguments |
Arguments for the SQL statement
|
| m_provider | |
| m_rhs |
RHS of the SQL statement
|
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.) |
| GetInstanceOfTDomain |
Gets an instance of TDomain from me
(Defined by ModelExtensions.) |
See Also