 | Query |
Query builder for model objects
Inheritance HierarchyNamespace: SanteDB.OrmLite
Assembly: SanteDB.OrmLite (in SanteDB.OrmLite.dll) Version: 3.0.2081-alpha+d0a78774d3f97b9193d2ae2fef6d129ea9f29519
SyntaxThe QueryBuilder type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | QueryBuilder | Represents model mapper |
Properties| Name | Description | |
|---|---|---|
 | StatementFactory | Provider |
Methods| Name | Description | |
|---|---|---|
 | AddQueryHacks | Add query builder hacks |
| CreateParameterValue | Create parameter value |
| CreateQuery(Type, IDictionaryString, String, ColumnMapping) | Create query |
| CreateQuery(Type, LambdaExpression, ColumnMapping) | Create a query from expression without needing type |
| CreateQuery(Type, IDictionaryString, String, String, Boolean, IEnumerableTableMapping, ColumnMapping) | Query query |
| CreateQueryTModel(ExpressionFuncTModel, Boolean, ColumnMapping) | Create a query |
| CreateSqlPredicate | Create the actual SQL predicate |
| CreateWhereTModel | Create a query |
| CreateWhereCondition | Create a where condition |
| 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) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
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) |
Remarks
Because the ORM used in the ADO persistence layer is very very lightweight, this query builder exists to parse
LINQ or HTTP query parameters into complex queries which implement joins/CTE/etc. across tables. Stuff that the
classes in the little data model can't possibly support via LINQ expression.
To use this, simply pass a model based LINQ expression to the CreateQuery method. Examples are in the test project.
Some reasons to use this:
- The generated SQL will gather all table instances up the object hierarchy for you (one hit instead of multiple)
- The queries it writes use efficient CTE tables
- It can do intelligent join conditions
- It uses Model LINQ expressions directly to SQL without the need to translate from Model LINQ to Domain LINQ queries
- It lets us hack the query (via IQueryHack interface) to manually write code
ExampleQueryBuilder.CreateQuery<Patient>(o => o.DeterminerConcept.Mnemonic == "Instance")
See Also