|
ITableOperationsQueryRecords(String, RecordRestriction, Int32) Method
|
Queries database and returns modeled table records for the specified parameters.
Namespace: GSF.Data.ModelAssembly: GSF.Core (in GSF.Core.dll) Version: 2.4.181-beta
Syntax abstract QueryRecords :
?orderByExpression : string *
?restriction : RecordRestriction *
?limit : int
(* Defaults:
let _orderByExpression = defaultArg orderByExpression null
let _restriction = defaultArg restriction null
let _limit = defaultArg limit -1
*)
-> IEnumerable
function QueryRecords(orderByExpression, restriction, limit);
View SourceParameters
- orderByExpression String (Optional)
- Field name expression used for sort order, include ASC or DESC as needed - does not include ORDER BY; defaults to primary keys.
- restriction RecordRestriction (Optional)
- Record restriction to apply, if any.
- limit Int32 (Optional)
- Limit of number of record to return.
Return Value
IEnumerableAn enumerable of modeled table row instances for queried records.
Remarks
If no record restriction or limit is provided, all rows will be returned.
If any of the restriction parameters reference a table field that is modeled with
either an EncryptDataAttribute or FieldDataTypeAttribute, then the function
GetInterpretedFieldValue(String, Object) will need to be called, replacing the target parameter with the
returned value so that the field value will be properly set prior to executing the database function.
See Also