OrmQueryResultSetTResultUnion(ExpressionFuncTResult, Boolean) Method

public IQueryResultSet<TResult> Union(
	Expression<Func<TResult, bool>> query
)

Public Function Union ( 
	query As Expression(Of Func(Of TResult, Boolean))
) As IQueryResultSet(Of TResult)

public:
virtual IQueryResultSet<TResult>^ Union(
	Expression<Func<TResult, bool>^>^ query
) sealed

abstract Union : 
        query : Expression<Func<'TResult, bool>> -> IQueryResultSet<'TResult> 
override Union : 
        query : Expression<Func<'TResult, bool>> -> IQueryResultSet<'TResult> 

Parameters

query  ExpressionFuncTResult, Boolean

[Missing <param name="query"/> documentation for "M:SanteDB.OrmLite.OrmQueryResultSet`1.Union(System.Linq.Expressions.Expression{System.Func{`0,System.Boolean}})"]

Return Value

[Missing <returns> documentation for "M:SanteDB.OrmLite.OrmQueryResultSet`1.Union(System.Linq.Expressions.Expression{System.Func{`0,System.Boolean}})"]

Implements

This method returns a new IQueryResultSetTData which contains a UNION of results in the current set and a new set described by query.

The method used to load these results depends on the underlying persistence layer, however in SQL would be:

In SQL based persistence services this results in a query similar to:

SELECT * FROM ( SELECT * FROM x WHERE sts_cd_id = 'ACTIVE_UUID' UNION SELECT * FROM x WHERE sts_cd_id = 'NEW_UUID' ) I WHERE crt_utc > CURRENT_TIMESTAMP;

Reference