Class NonQueryResultGenerator

Namespace

Dynamicweb.Data.Firehose.ResultGenerators

Assembly

Dynamicweb.Core.dll

Generates results for SQL statements that do not return data rows, such as INSERT, UPDATE, or DELETE commands.

public sealed class NonQueryResultGenerator : ResultGeneratorBase

Inheritance

object

ResultGeneratorBase

NonQueryResultGenerator

Inherited Members

ResultGeneratorBase.Skip

ResultGeneratorBase.Take

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Remarks

This class is intended for use with non-query SQL operations where the primary result is the number of rows affected. It provides methods to execute the command and retrieve the affected row count in a standardized result format. Instances of this class are typically created internally and are not intended to be instantiated directly by application code.

Methods

EstimateAffectedRows()

Executes the query in dry-run mode to validate syntax and estimate results without making any changes.

public int EstimateAffectedRows()

Returns

int

The number of rows that would be affected by the query if it were executed.

Remarks

Use this method to verify the impact of a query before performing actual data modifications. No data is changed when using dry-run execution.

GetResult()

Executes the query and returns the result as a RowQueryResult instance.

public override RowQueryResult GetResult()

Returns

RowQueryResult

A RowQueryResult containing the data produced by the query execution.