Click or drag to resize

SqlResult Class

Represents a resultset that contains rows of data for relational operations.
Inheritance Hierarchy
SystemObject
  MySqlX.XDevAPI.CommonBaseResult
    MySqlX.XDevAPI.CommonBufferingResultRow
      MySqlX.XDevAPI.RelationalInternalRowResult
        MySqlX.XDevAPI.RelationalSqlResult

Namespace:  MySqlX.XDevAPI.Relational
Assembly:  MySql.Data (in MySql.Data.dll) Version: 8.0.22
Syntax
public class SqlResult : InternalRowResult

The SqlResult type exposes the following members.

Properties
  NameDescription
Public propertyAffectedItemsCount
Gets the number of records affected by the statement that generated this result.
(Inherited from BaseResult.)
Public propertyColumnCount
Gets the number of columns in this resultset.
(Inherited from InternalRowResult.)
Public propertyColumnNames
Gets a list containing the column names in this resultset.
(Inherited from InternalRowResult.)
Public propertyColumns
Gets the columns in this resultset.
(Inherited from InternalRowResult.)
Public propertyCurrent
Gets the current item.
(Inherited from BufferingResultT.)
Public propertyHasData
Gets a boolean value indicating if this result has data.
Public propertyItem
Gets the value of the column value at the current index.
(Inherited from InternalRowResult.)
Protected propertyNameMap
Gets a dictionary containing the column names and their index.
(Inherited from BufferingResultT.)
Public propertyPageSize
Gets the page size set for this buffered result.
(Inherited from BufferingResultT.)
Protected propertyProtocol
Gets the ProtocolBase object of the session.
(Inherited from BaseResult.)
Public propertyRows
Gets the rows of this resultset. This collection will be incomplete unless all the rows have been read either by using the Next method or the Buffer method.
(Inherited from InternalRowResult.)
Public propertyWarnings
Gets a read-only collection of WarningInfo objects derived from statement execution.
(Inherited from BaseResult.)
Public propertyWarningsCount
Gets the number of warnings in the Warnings collection derived from statement execution.
(Inherited from BaseResult.)
Top
Methods
  NameDescription
Protected methodBuffer
Retrieves a read-only list of the generic items associated to this buffered result.
(Inherited from BufferingResultT.)
Public methodDispose
No body has been defined for this method.
(Inherited from BufferingResultT.)
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodFetchAll
Retrieves a read-only list of the generic items associated to this buffered result.
(Inherited from BufferingResultT.)
Public methodFetchOne
Retrieves one element from the generic items associated to this buffered result.
(Inherited from BufferingResultT.)
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 methodGetEnumerator (Inherited from BufferingResultT.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodIndexOf
Returns the index of the given column name.
(Inherited from InternalRowResult.)
Protected methodLoadColumnData
Loads the column data into the _nameMap field.
(Inherited from BufferingResultT.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodMoveNext
Determines if all items have already been read.
(Inherited from BufferingResultT.)
Public methodNext
Determines if all items have already been read.
(Inherited from BufferingResultT.)
Public methodNextResult
Moves to next resultset.
Protected methodReadItem (Inherited from InternalRowResult.)
Public methodReset
Resets the value of the _position field to zero.
(Inherited from BufferingResultT.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
Fields
See Also