Table of Contents

Class DataSetStoreHelpers

Namespace
DevExpress.Xpo.DB.Helpers
Assembly
DevExpress.Xpo.v24.1.dll
public class DataSetStoreHelpers
Inheritance
DataSetStoreHelpers
Inherited Members

Methods

CreateIfNotExists(DataSet, DBTable)

public static DataTable CreateIfNotExists(DataSet dataSet, DBTable table)

Parameters

dataSet DataSet
table DBTable

Returns

DataTable

CreateIfNotExists(DataTable, DBColumn)

public static void CreateIfNotExists(DataTable table, DBColumn dbObj)

Parameters

table DataTable
dbObj DBColumn

CreateIfNotExists(DataTable, DBForeignKey)

public static void CreateIfNotExists(DataTable table, DBForeignKey dbObj)

Parameters

table DataTable
dbObj DBForeignKey

CreateIfNotExists(DataTable, DBIndex)

public static void CreateIfNotExists(DataTable table, DBIndex dbObj)

Parameters

table DataTable
dbObj DBIndex

CreateIfNotExists(DataTable, DBPrimaryKey)

public static void CreateIfNotExists(DataTable table, DBPrimaryKey dbObj)

Parameters

table DataTable
dbObj DBPrimaryKey

DoDeleteRecord(DataViewEvaluatorContextDescriptor, CriteriaOperator, bool, ICollection<ICustomFunctionOperator>, ICollection<ICustomAggregate>, List<DataRow>)

public static int DoDeleteRecord(DataViewEvaluatorContextDescriptor descriptor, CriteriaOperator condition, bool caseSensitive, ICollection<ICustomFunctionOperator> customFunctions, ICollection<ICustomAggregate> customAggregates, List<DataRow> affectedRows)

Parameters

descriptor DataViewEvaluatorContextDescriptor
condition CriteriaOperator
caseSensitive bool
customFunctions ICollection<ICustomFunctionOperator>
customAggregates ICollection<ICustomAggregate>
affectedRows List<DataRow>

Returns

int

DoDeleteRecord(DataViewEvaluatorContextDescriptor, CriteriaOperator, bool, ICollection<ICustomFunctionOperator>, List<DataRow>)

public static int DoDeleteRecord(DataViewEvaluatorContextDescriptor descriptor, CriteriaOperator condition, bool caseSensitive, ICollection<ICustomFunctionOperator> customFunctions, List<DataRow> affectedRows)

Parameters

descriptor DataViewEvaluatorContextDescriptor
condition CriteriaOperator
caseSensitive bool
customFunctions ICollection<ICustomFunctionOperator>
affectedRows List<DataRow>

Returns

int

DoGetData(DataViewEvaluatorContextDescriptor, CriteriaOperator, ExpressionEvaluator[], SortingComparer, int, int, bool, ICollection<ICustomFunctionOperator>)

public static SelectStatementResult DoGetData(DataViewEvaluatorContextDescriptor descriptor, CriteriaOperator condition, ExpressionEvaluator[] dataEvaluators, SortingComparer sortingComparer, int skipRecords, int topRecords, bool caseSensitive, ICollection<ICustomFunctionOperator> customFunction)

Parameters

descriptor DataViewEvaluatorContextDescriptor
condition CriteriaOperator
dataEvaluators ExpressionEvaluator[]
sortingComparer SortingComparer
skipRecords int
topRecords int
caseSensitive bool
customFunction ICollection<ICustomFunctionOperator>

Returns

SelectStatementResult

DoGetData(DataViewEvaluatorContextDescriptor, CriteriaOperator, ExpressionEvaluator[], SortingComparer, int, int, bool, ICollection<ICustomFunctionOperator>, ICollection<ICustomAggregate>)

public static SelectStatementResult DoGetData(DataViewEvaluatorContextDescriptor descriptor, CriteriaOperator condition, ExpressionEvaluator[] dataEvaluators, SortingComparer sortingComparer, int skipRecords, int topRecords, bool caseSensitive, ICollection<ICustomFunctionOperator> customFunction, ICollection<ICustomAggregate> customAggregates)

Parameters

descriptor DataViewEvaluatorContextDescriptor
condition CriteriaOperator
dataEvaluators ExpressionEvaluator[]
sortingComparer SortingComparer
skipRecords int
topRecords int
caseSensitive bool
customFunction ICollection<ICustomFunctionOperator>
customAggregates ICollection<ICustomAggregate>

Returns

SelectStatementResult

DoGetGroupedData(DataViewEvaluatorContextDescriptor, CriteriaOperator, ExpressionEvaluator[], ExpressionEvaluator, SortingComparer, int, int, ExpressionEvaluator[], bool, ICollection<ICustomFunctionOperator>)

public static SelectStatementResult DoGetGroupedData(DataViewEvaluatorContextDescriptor descriptor, CriteriaOperator condition, ExpressionEvaluator[] groupEvaluators, ExpressionEvaluator havingEvaluator, SortingComparer sortingComparer, int skipRecords, int topRecords, ExpressionEvaluator[] dataEvaluators, bool caseSensitive, ICollection<ICustomFunctionOperator> customFunctions)

Parameters

descriptor DataViewEvaluatorContextDescriptor
condition CriteriaOperator
groupEvaluators ExpressionEvaluator[]
havingEvaluator ExpressionEvaluator
sortingComparer SortingComparer
skipRecords int
topRecords int
dataEvaluators ExpressionEvaluator[]
caseSensitive bool
customFunctions ICollection<ICustomFunctionOperator>

Returns

SelectStatementResult

DoGetGroupedData(DataViewEvaluatorContextDescriptor, CriteriaOperator, ExpressionEvaluator[], ExpressionEvaluator, SortingComparer, int, int, ExpressionEvaluator[], bool, ICollection<ICustomFunctionOperator>, ICollection<ICustomAggregate>)

public static SelectStatementResult DoGetGroupedData(DataViewEvaluatorContextDescriptor descriptor, CriteriaOperator condition, ExpressionEvaluator[] groupEvaluators, ExpressionEvaluator havingEvaluator, SortingComparer sortingComparer, int skipRecords, int topRecords, ExpressionEvaluator[] dataEvaluators, bool caseSensitive, ICollection<ICustomFunctionOperator> customFunctions, ICollection<ICustomAggregate> customAggregates)

Parameters

descriptor DataViewEvaluatorContextDescriptor
condition CriteriaOperator
groupEvaluators ExpressionEvaluator[]
havingEvaluator ExpressionEvaluator
sortingComparer SortingComparer
skipRecords int
topRecords int
dataEvaluators ExpressionEvaluator[]
caseSensitive bool
customFunctions ICollection<ICustomFunctionOperator>
customAggregates ICollection<ICustomAggregate>

Returns

SelectStatementResult

DoInsertRecord(DataTable, QueryParameterCollection, CriteriaOperatorCollection, ParameterValue, TaggedParametersHolder, List<DataRow>)

public static int DoInsertRecord(DataTable table, QueryParameterCollection parameters, CriteriaOperatorCollection operands, ParameterValue identityParameter, TaggedParametersHolder identitiesByTag, List<DataRow> affectedRows)

Parameters

table DataTable
parameters QueryParameterCollection
operands CriteriaOperatorCollection
identityParameter ParameterValue
identitiesByTag TaggedParametersHolder
affectedRows List<DataRow>

Returns

int

DoUpdateRecord(DataViewEvaluatorContextDescriptor, QueryCriteriaReprocessor, QueryParameterCollection, CriteriaOperatorCollection, TaggedParametersHolder, CriteriaOperator, bool, ICollection<ICustomFunctionOperator>, ICollection<ICustomAggregate>, List<DataRow>)

public static int DoUpdateRecord(DataViewEvaluatorContextDescriptor descriptor, QueryCriteriaReprocessor processor, QueryParameterCollection parameters, CriteriaOperatorCollection operands, TaggedParametersHolder identitiesByTag, CriteriaOperator condition, bool caseSensitive, ICollection<ICustomFunctionOperator> customFunction, ICollection<ICustomAggregate> customAggregates, List<DataRow> affectedRows)

Parameters

descriptor DataViewEvaluatorContextDescriptor
processor QueryCriteriaReprocessor
parameters QueryParameterCollection
operands CriteriaOperatorCollection
identitiesByTag TaggedParametersHolder
condition CriteriaOperator
caseSensitive bool
customFunction ICollection<ICustomFunctionOperator>
customAggregates ICollection<ICustomAggregate>
affectedRows List<DataRow>

Returns

int

DoUpdateRecord(DataViewEvaluatorContextDescriptor, QueryCriteriaReprocessor, QueryParameterCollection, CriteriaOperatorCollection, TaggedParametersHolder, CriteriaOperator, bool, ICollection<ICustomFunctionOperator>, List<DataRow>)

public static int DoUpdateRecord(DataViewEvaluatorContextDescriptor descriptor, QueryCriteriaReprocessor processor, QueryParameterCollection parameters, CriteriaOperatorCollection operands, TaggedParametersHolder identitiesByTag, CriteriaOperator condition, bool caseSensitive, ICollection<ICustomFunctionOperator> customFunction, List<DataRow> affectedRows)

Parameters

descriptor DataViewEvaluatorContextDescriptor
processor QueryCriteriaReprocessor
parameters QueryParameterCollection
operands CriteriaOperatorCollection
identitiesByTag TaggedParametersHolder
condition CriteriaOperator
caseSensitive bool
customFunction ICollection<ICustomFunctionOperator>
affectedRows List<DataRow>

Returns

int

GetTable(DataSet, string)

public static DataTable GetTable(DataSet dataSet, string tableName)

Parameters

dataSet DataSet
tableName string

Returns

DataTable

QueryTable(DataSet, string)

public static DataTable QueryTable(DataSet dataSet, string tableName)

Parameters

dataSet DataSet
tableName string

Returns

DataTable