Click or drag to resize

FindStatement Class

Represents a chaining collection find statement.
Inheritance Hierarchy
SystemObject
  MySqlX.XDevAPI.CommonBaseStatementDocResult
    MySqlX.XDevAPI.CommonTargetedBaseStatementCollection, DocResult
      MySqlX.XDevAPI.CommonFilterableStatementFindStatement, Collection, DocResult
        MySqlX.XDevAPI.CRUDFindStatement

Namespace:  MySqlX.XDevAPI.CRUD
Assembly:  MySql.Data (in MySql.Data.dll) Version: 8.0.22
Syntax
public class FindStatement : FilterableStatement<FindStatement, Collection, DocResult>

The FindStatement type exposes the following members.

Properties
Methods
  NameDescription
Public methodBind(Object)
Binds the parameter values in filter expression.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodBind(String)
Binds the parameter values in filter expression.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodBind(DbDoc)
Binds the parameter values in filter expression.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodBind(String, Object)
Binds the parameter values in filter expression.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodClone
Clones the filterable data but Session and Target remain the same.
(Inherited from FilterableStatementT, TTarget, TResult.)
Protected methodConvertToPreparedStatementT
Converts a statement to prepared statement for a second execution without any change but Bind, Limit, or Offset.
(Inherited from BaseStatementTResult.)
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodExecute
Executes the Find statement.
(Overrides BaseStatementTResultExecute.)
Protected methodExecute(FuncT, TResult, T)
Executes the statement.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodExecuteAsync
Executes a statement asynchronously.
(Inherited from BaseStatementTResult.)
Public methodFields
List of column projections that shall be returned.
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodGroupBy
Sets the collection aggregation.
Public methodHaving
Filters criteria for aggregated groups.
Public methodLimit
Sets the number of items to be returned by the operation.
(Inherited from FilterableStatementT, TTarget, TResult.)
Public methodLockExclusive
Locks matching rows so no other transaction can read or write to it.
Public methodLockShared
Locks matching rows against updates.
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodOffset
Sets the number of items to be skipped before including them into the result.
(Inherited from FilterableStatementT, TTarget, TResult.)
Protected methodSetChanged
Sets the status as Changed for prepared statement validation.
(Inherited from BaseStatementTResult.)
Public methodSort
Sets user-defined sorting criteria for the operation. The strings use normal SQL syntax like "order ASC" or "pages DESC, age ASC".
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Protected methodValidateOpenSession
Validates if the session is open and valid.
(Inherited from BaseStatementTResult.)
Public methodWhere Obsolete.
Enables the setting of Where condition for this operation.
Top
Fields
See Also