TableOperationsTQueryRecordsAsync(String, RecordRestriction, Int32, CancellationToken) Method

public IAsyncEnumerable<T> QueryRecordsAsync(
	string? orderByExpression = null,
	RecordRestriction? restriction = null,
	int limit = -1,
	CancellationToken cancellationToken = default
)

Public Function QueryRecordsAsync ( 
	Optional orderByExpression As String = Nothing,
	Optional restriction As RecordRestriction = Nothing,
	Optional limit As Integer = -1,
	Optional cancellationToken As CancellationToken = Nothing
) As IAsyncEnumerable(Of T)

public:
IAsyncEnumerable<T>^ QueryRecordsAsync(
	String^ orderByExpression = nullptr, 
	RecordRestriction^ restriction = nullptr, 
	int limit = -1, 
	CancellationToken cancellationToken = CancellationToken()
)

function QueryRecordsAsync(orderByExpression, restriction, limit, cancellationToken);

Parameters

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.

cancellationToken  CancellationToken  (Optional)

Propagates notification that operations should be canceled.

Return Value

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.

Reference