 | SqlStatementT Class |
Represents a strongly typed SQL Statement
Inheritance HierarchyNamespace: SanteDB.OrmLite
Assembly: SanteDB.OrmLite (in SanteDB.OrmLite.dll) Version: 2.2.1
SyntaxThe SqlStatementT type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | SqlStatementT(IDbProvider) |
Creates a new empty SQL statement
|
| SqlStatementT(IDbProvider, String, Object) |
Create a new sql statement from the specified sql
|
Properties| Name | Description | |
|---|---|---|
 | Arguments |
Arguments for the SQL Statement
(Inherited from SqlStatement.) |
| DbProvider |
Get the DB provider
(Inherited from SqlStatement.) |
| IsFinalized |
True if the sql statement is finalized
(Inherited from SqlStatement.) |
| SQL |
Gets the constructed or set SQL
(Inherited from SqlStatement.) |
| TableType |
Gets the table type
|
Methods| Name | Description | |
|---|---|---|
| And(SqlStatement) |
Append an AND condition
(Inherited from SqlStatement.) |
| And(String, Object) |
Construct a where clause on the expression tree
(Inherited from SqlStatement.) |
| AndTExpression(ExpressionFuncTExpression, Boolean) |
Expression
(Inherited from SqlStatement.) |
| Append(SqlStatement) |
Append the SQL statement
(Inherited from SqlStatement.) |
| Append(SqlStatementT) |
Append the SQL statement
|
| Append(String, Object) |
Append the specified SQL
(Inherited from SqlStatement.) |
| AutoJoinTJoinTable, TReturn |
Appends an inner join
|
| Build |
Build the special SQL statement
(Inherited from SqlStatement.) |
| DeleteFrom |
Create 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.) |
| GetLast |
Get the last statement
(Inherited from SqlStatement.) |
| GetMember |
Get member information from lambda
(Inherited from SqlStatement.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| InnerJoin(Type, Type) |
Inner join left and right
(Inherited from SqlStatement.) |
| InnerJoinTRight(ExpressionFuncT, Object, ExpressionFuncTRight, Object) |
Inner join
|
| InnerJoinTLeft, TRight(ExpressionFuncTLeft, Object, ExpressionFuncTRight, Object) |
Inner join
(Inherited from SqlStatement.) |
| JoinTLeft, TRight |
Join by specific type of join
(Inherited from SqlStatement.) |
| Limit |
Limit of the
(Inherited from SqlStatement.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| Offset |
Append an offset statement
(Inherited from SqlStatement.) |
| Or(SqlStatement) |
Append an AND condition
(Inherited from SqlStatement.) |
| Or(String, Object) |
Construct a where clause on the expression tree
(Inherited from SqlStatement.) |
| OrderByTExpression |
Construct an order by
(Inherited from SqlStatement.) |
| RemoveLast |
Removes the last statement from the list
(Inherited from SqlStatement.) |
| RemoveLast(SqlStatement) |
Removes the last statement from the list
(Inherited from SqlStatement.) |
| SelectFrom |
Construct a SELECT FROM statement
|
| SelectFrom(ColumnMapping) |
Construct a SELECT FROM statement with the specified selectors
|
| SelectFrom(Type) |
Return a select from
(Inherited from SqlStatement.) |
| SelectFrom(Type) |
Construct a SELECT FROM statement with the specified selectors
|
| SelectFrom(Type, ColumnMapping) |
Return a select from
(Inherited from SqlStatement.) |
| ToString |
Represent as string
(Inherited from SqlStatement.) |
| UpdateSet |
Generate an update statement
|
| Where(ExpressionFuncT, Boolean) |
Construct a where clause on the expression tree
|
| Where(SqlStatement) |
Where clause
(Inherited from SqlStatement.) |
| Where(String, Object) |
Construct a where clause on the expression tree
(Inherited from SqlStatement.) |
| WhereTExpression(ExpressionFuncTExpression, Boolean) |
Construct a where clause on the expression tree
(Inherited from SqlStatement.) |
Fields| Name | Description | |
|---|---|---|
 | m_arguments |
Arguments for the SQL statement
(Inherited from SqlStatement.) |
| m_provider | (Inherited from SqlStatement.) |
| m_rhs |
RHS of the SQL statement
(Inherited from SqlStatement.) |
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