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