 | SqlStatementT Class |
Represents a strongly typed SQL Statement
Inheritance HierarchySystemObject
SanteDB.DisconnectedClient.SQLite.QuerySqlStatement
SanteDB.DisconnectedClient.SQLite.QuerySqlStatementT
SanteDB.DisconnectedClient.SQLite.QuerySqlStatement
SanteDB.DisconnectedClient.SQLite.QuerySqlStatementT
Namespace: SanteDB.DisconnectedClient.SQLite.Query
Assembly: SanteDB.DisconnectedClient.SQLite (in SanteDB.DisconnectedClient.SQLite.dll) Version: 2.2.1
SyntaxThe SqlStatementT type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | SqlStatementT |
Creates a new empty SQL statement
|
| SqlStatementT(String, Object) |
Create a new sql statement from the specified sql
|
Properties| Name | Description | |
|---|---|---|
 | Arguments |
Arguments for the SQL Statement
(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.) |
| 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.) |
| 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
|
| InnerJoinTJoinTable, TReturn |
Appends an inner join
|
| InnerJoinTLeft, TRight(ExpressionFuncTLeft, Object, ExpressionFuncTRight, Object) |
Inner join
(Inherited from SqlStatement.) |
| JoinTLeft, TRight | (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(ExpressionFuncT, Object) |
Construct a SELECT FROM statement
|
| SelectFrom(String) |
Construct a SELECT FROM statement
|
| SelectFrom(String) |
Construct a SELECT FROM statement
|
| SelectFrom(Type) |
Return a select from
(Inherited from SqlStatement.) |
| ToString |
represent as a 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_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