Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [Expand]DevExpress ORM Tool
 [Expand]DevExpress Data Library
 [Expand]Miscellaneous
 [Collapse]API Reference
  [Expand]DevExpress.Data
  [Expand]DevExpress.Data.Browsing
  [Expand]DevExpress.Data.Browsing.Design
  [Expand]DevExpress.Data.Camera
  [Expand]DevExpress.Data.Controls
  [Expand]DevExpress.Data.Controls.ExpressionEditor
  [Expand]DevExpress.Data.Entity
  [Expand]DevExpress.Data.Filtering
  [Expand]DevExpress.Data.Filtering.Exceptions
  [Expand]DevExpress.Data.Filtering.Helpers
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Data.ODataLinq
  [Expand]DevExpress.Data.PivotGrid
  [Expand]DevExpress.Data.PLinq
  [Expand]DevExpress.Data.TreeList
  [Expand]DevExpress.Data.Utils
  [Expand]DevExpress.Data.Utils.ServiceModel
  [Expand]DevExpress.Data.WcfLinq
  [Expand]DevExpress.Data.WizardFramework
  [Expand]DevExpress.Data.XtraReports.DataProviders
  [Expand]DevExpress.Data.XtraReports.Labels
  [Expand]DevExpress.Data.XtraReports.ServiceModel
  [Expand]DevExpress.Data.XtraReports.ServiceModel.DataContracts
  [Expand]DevExpress.Data.XtraReports.Wizard
  [Expand]DevExpress.Data.XtraReports.Wizard.Presenters
  [Expand]DevExpress.Data.XtraReports.Wizard.Views
  [Expand]DevExpress.DataAccess
  [Expand]DevExpress.DataAccess.ConnectionParameters
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Collapse]DevExpress.DataAccess.Sql
   [Expand]AggregateQueryInvalidSortingValidationException Class
    AggregationType Enumeration
   [Expand]AggregationWithoutAliasValidationException Class
   [Expand]AliasedBase Class
   [Expand]AllColumns Class
   [Expand]CircularRelationsValidationException Class
   [Expand]Column Class
   [Expand]ColumnBase Class
   [Expand]ColumnExpression Class
   [Expand]ColumnInfo Class
   [Expand]ColumnNotInSchemaValidationException Class
   [Expand]ColumnNullValidationException Class
    ConditionType Enumeration
   [Expand]ConfigureDataConnectionEventArgs Class
    ConfigureDataConnectionEventHandler Delegate
   [Expand]ConnectionErrorEventArgs Class
    ConnectionErrorEventHandler Delegate
   [Expand]ConnectionOptions Class
   [Expand]CustomExpression Class
   [Expand]CustomExpressionWithAmbiguousColumnValidationException Class
   [Expand]CustomExpressionWithColumnOfMissingTableValidationException Class
   [Expand]CustomExpressionWithMissingInSchemaColumnValidationException Class
   [Expand]CustomizeFilterExpressionEventArgs Class
    CustomizeFilterExpressionEventHandler Delegate
   [Expand]CustomSqlQuery Class
   [Expand]CustomSqlQueryValidationException Class
   [Expand]DatabaseConnectionException Class
   [Expand]DBSchema Class
   [Expand]DBSchemaProviderEx Class
   [Expand]DuplicatingColumnNamesValidationException Class
   [Expand]DuplicatingTableNamesValidationException Class
   [Expand]ExpressionBase Class
   [Expand]ExpressionNullValidationException Class
   [Expand]ExpressionStringNullValidationException Class
   [Expand]FilterByAmbiguousColumnValidationException Class
   [Expand]FilterByColumnOfMissingTableValidationException Class
   [Expand]FilterByMissingInSchemaColumnValidationException Class
   [Expand]Group Class
   [Expand]GroupByAggregateColumnValidationException Class
   [Expand]GroupByWithoutAggregateValidationException Class
   [Expand]GroupingInfo Class
   [Expand]GroupingInfoList Class
   [Expand]GroupNullValidationException Class
   [Expand]HavingWithoutGroupByValidationException Class
   [Expand]IDBSchemaProvider Interface
   [Expand]IDBSchemaProviderEx Interface
   [Expand]IncompleteRelationValidationException Class
   [Expand]InvalidExpressionStringValidationException Class
   [Expand]IResultSchemaProvider Interface
   [Expand]Join Class
   [Expand]MasterDetailInfo Class
   [Expand]MasterDetailInfoCollection Class
   [Expand]NegativeTopSkipValidationException Class
   [Expand]NoColumnsValidationException Class
   [Expand]NoRelationColumnsValidationException Class
   [Expand]NoTablesValidationException Class
   [Expand]PartialAggregationValidationException Class
   [Expand]QueryExecutionException Class
   [Expand]QueryParameter Class
   [Expand]RecordsCount Class
   [Expand]RelationColumnInfo Class
   [Expand]RelationColumnNotInSchemaValidationException Class
   [Expand]RelationColumnNullValidationException Class
   [Expand]RelationException Class
   [Expand]RelationInfo Class
   [Expand]RelationInfoList Class
   [Expand]RelationNullValidationException Class
   [Expand]RelationTableNotSelectedValidationException Class
   [Expand]ResultSchemaProvider Class
    SchemaLoadingMode Enumeration
   [Expand]SelectQuery Class
   [Expand]SelectQueryFluentBuilder Class
   [Expand]SkipWithoutSortingValidationException Class
   [Expand]SortByAggregateColumnValidationException Class
   [Expand]Sorting Class
   [Expand]SortingBySameColumnTwiceValidationException Class
   [Expand]SortingInfo Class
   [Expand]SortingInfoList Class
   [Expand]SortingNullValidationException Class
   [Expand]SqlDataConnection Class
   [Expand]SqlDataSource Class
   [Expand]SqlQuery Class
   [Expand]SqlQueryCollection Class
   [Expand]SqlStringEmptyValidationException Class
   [Expand]StoredProcNameNullValidationException Class
   [Expand]StoredProcNotInSchemaValidationException Class
   [Expand]StoredProcParamCountValidationException Class
   [Expand]StoredProcParamNameValidationException Class
   [Expand]StoredProcParamNullValidationException Class
   [Expand]StoredProcParamTypeValidationException Class
   [Expand]StoredProcQuery Class
   [Expand]Table Class
   [Expand]TableInfo Class
   [Expand]TableInfoList Class
   [Expand]TableNotInSchemaValidationException Class
   [Expand]TableNotSelectedValidationException Class
   [Expand]TableNullValidationException Class
   [Expand]TableQuery Class
   [Expand]TablesNotRelatedValidationException Class
   [Expand]UnnamedColumnValidationException Class
   [Expand]UnnamedTableValidationException Class
   [Expand]ValidationException Class
  [Expand]DevExpress.DataAccess.Sql.DataApi
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DataAccess.Web
  [Expand]DevExpress.DataAccess.Wizard
  [Expand]DevExpress.DataAccess.Wizard.Model
  [Expand]DevExpress.DataAccess.Wizard.Presenters
  [Expand]DevExpress.DataAccess.Wizard.Services
  [Expand]DevExpress.DataAccess.Wizard.Views
  [Expand]DevExpress.Diagram.Core
  [Expand]DevExpress.Diagram.Core.Layout
  [Expand]DevExpress.Diagram.Core.Localization
  [Expand]DevExpress.Diagram.Core.Shapes
  [Expand]DevExpress.Diagram.Core.Themes
  [Expand]DevExpress.DocumentServices.ServiceModel
  [Expand]DevExpress.DocumentServices.ServiceModel.Client
  [Expand]DevExpress.DocumentServices.ServiceModel.DataContracts
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.Entity.Model
  [Expand]DevExpress.Entity.ProjectModel
  [Expand]DevExpress.Export
  [Expand]DevExpress.Export.Xl
  [Expand]DevExpress.Map
  [Expand]DevExpress.Mvvm
  [Expand]DevExpress.Mvvm.DataAnnotations
  [Expand]DevExpress.Mvvm.DataModel
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office
  [Expand]DevExpress.Office.Crypto
  [Expand]DevExpress.Office.Drawing
  [Expand]DevExpress.Office.Export
  [Expand]DevExpress.Office.Export.Html
  [Expand]DevExpress.Office.Import
  [Expand]DevExpress.Office.Localization
  [Expand]DevExpress.Office.Options
  [Expand]DevExpress.Office.Services
  [Expand]DevExpress.Office.Utils
  [Expand]DevExpress.Pdf
  [Expand]DevExpress.Pdf.Localization
  [Expand]DevExpress.PivotGrid.Printing
  [Expand]DevExpress.Printing
  [Expand]DevExpress.Printing.Core
  [Expand]DevExpress.ReportServer.Printing
  [Expand]DevExpress.ReportServer.Printing.Services
  [Expand]DevExpress.ReportServer.ServiceModel.Client
  [Expand]DevExpress.ReportServer.ServiceModel.ConnectionProviders
  [Expand]DevExpress.ReportServer.ServiceModel.DataContracts
  [Expand]DevExpress.Schedule
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [Expand]DevExpress.Spreadsheet
  [Expand]DevExpress.Spreadsheet.Charts
  [Expand]DevExpress.Spreadsheet.Drawings
  [Expand]DevExpress.Spreadsheet.Export
  [Expand]DevExpress.Spreadsheet.Formulas
  [Expand]DevExpress.Spreadsheet.Functions
  [Expand]DevExpress.TreeMap
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Commands
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Filtering.Internal
  [Expand]DevExpress.Utils.IoC
  [Expand]DevExpress.Utils.Localization
  [Expand]DevExpress.Utils.Serializing.Helpers
  [Expand]DevExpress.WebUtils
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpo
  [Expand]DevExpress.Xpo.DB
  [Expand]DevExpress.Xpo.DB.Exceptions
  [Expand]DevExpress.Xpo.DB.Helpers
  [Expand]DevExpress.Xpo.Exceptions
  [Expand]DevExpress.Xpo.Helpers
  [Expand]DevExpress.Xpo.Metadata
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Printing
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraExport.Csv
  [Expand]DevExpress.XtraGauges.Base
  [Expand]DevExpress.XtraGauges.Core
  [Expand]DevExpress.XtraGauges.Core.Base
  [Expand]DevExpress.XtraGauges.Core.Drawing
  [Expand]DevExpress.XtraGauges.Core.Localization
  [Expand]DevExpress.XtraGauges.Core.Model
  [Expand]DevExpress.XtraGauges.Core.Primitive
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraPivotGrid
  [Expand]DevExpress.XtraPivotGrid.Customization
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPivotGrid.Localization
  [Expand]DevExpress.XtraPivotGrid.Selection
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.BarCode
  [Expand]DevExpress.XtraPrinting.DataNodes
  [Expand]DevExpress.XtraPrinting.Drawing
  [Expand]DevExpress.XtraPrinting.Export
  [Expand]DevExpress.XtraPrinting.Export.Web
  [Expand]DevExpress.XtraPrinting.Localization
  [Expand]DevExpress.XtraPrinting.Native
  [Expand]DevExpress.XtraPrinting.Shape
  [Expand]DevExpress.XtraPrinting.Shape.Native
  [Expand]DevExpress.XtraPrinting.WebClientUIControl.DataContracts
  [Expand]DevExpress.XtraPrinting.XamlExport
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports
  [Expand]DevExpress.XtraReports.Design
  [Expand]DevExpress.XtraReports.Parameters
  [Expand]DevExpress.XtraReports.ReportGeneration
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.API.Layout
  [Expand]DevExpress.XtraRichEdit.API.Native
  [Expand]DevExpress.XtraRichEdit.API.Native.Implementation
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Export.Html
  [Expand]DevExpress.XtraRichEdit.Export.Rtf
  [Expand]DevExpress.XtraRichEdit.Forms
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Localization
  [Expand]DevExpress.XtraRichEdit.Services
  [Expand]DevExpress.XtraRichEdit.Utils
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Compatibility
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Exchange
  [Expand]DevExpress.XtraScheduler.iCalendar
  [Expand]DevExpress.XtraScheduler.iCalendar.Components
  [Expand]DevExpress.XtraScheduler.Localization
  [Expand]DevExpress.XtraScheduler.Native
  [Expand]DevExpress.XtraScheduler.Outlook
  [Expand]DevExpress.XtraScheduler.Outlook.Interop
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.Tools
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraScheduler.Xml
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpreadsheet
  [Expand]DevExpress.XtraSpreadsheet.Export
  [Expand]DevExpress.XtraSpreadsheet.Export.Html
  [Expand]DevExpress.XtraSpreadsheet.Import
  [Expand]DevExpress.XtraSpreadsheet.Localization
  [Expand]DevExpress.XtraSpreadsheet.Services
[Expand]Tools and Utilities
 End-User Documentation

DevExpress.DataAccess.Sql Namespace

Contains classes that support binding to SQL data sources.

Expanded Classes

  Class Description
Public class AggregateQueryInvalidSortingValidationException An exception thrown when trying to execute an aggregate query with an invalid sorting criteria applied to it.
Public class AggregationWithoutAliasValidationException An exception thrown when an aggregation has been used without specifying its alias.
Public class AliasedBase The base for classes that provide the data column functionality.
Public class AllColumns Corresponds to all columns from one or more data tables selected by a SelectQuery.
Public class CircularRelationsValidationException An exception thrown when circular relations have been specified in a query.
Public class Column A column of a data table retrieved by a SelectQuery.
Public class ColumnBase The base for classes that provide the data column functionality.
Public class ColumnExpression A selected data column with or without an aggregate expression applied to it.
Public class ColumnInfo Obsolete. Use the corresponding functionality of the SelectQuery class instead.
Public class ColumnNotInSchemaValidationException An exception thrown when a query contains columns that are missing in the data source schema.
Public class ColumnNullValidationException An exception thrown when a query references a column that is null.
Public class ConfigureDataConnectionEventArgs Provides data for the ConfigureDataConnection events.
Public class ConnectionErrorEventArgs Provides data for the ConnectionError event.
Public class ConnectionOptions Specifies the data connection options of a SqlDataSource.
Public class CustomExpression A custom aggregate expression that can be applied to a data column or group/sorting criteria.
Public class CustomExpressionWithAmbiguousColumnValidationException An exception thrown when a custom expression references a column with an ambiguous name.
Public class CustomExpressionWithColumnOfMissingTableValidationException An exception thrown when a custom expression references a column contained in a table that has not been selected.
Public class CustomExpressionWithMissingInSchemaColumnValidationException An exception thrown when a custom expression references a column that is missing in the data source schema.
Public class CustomizeFilterExpressionEventArgs Provides data for the CustomizeFilterExpression event.
Public class CustomSqlQuery A custom query.
Public class CustomSqlQueryValidationException An exception thrown when a custom query validation fails.
Public class DatabaseConnectionException The exception occurring after a data source connection has failed.
Public class DBSchema An object schema that is used to manage database objects (e.g., DevExpress.Xpo.DB.DBTable objects or their descendants).
Public class DBSchemaProviderEx Provides a default implementation of the IDBSchemaProviderEx interface exposing virtual methods, which you can override in derived classes.
Public class DuplicatingColumnNamesValidationException An exception thrown when trying to select a column that has already been selected.
Public class DuplicatingTableNamesValidationException An exception thrown when trying to select a table that has already been selected.
Public class ExpressionBase The base for classes that provide expression functionality to SelectQuery.
Public class ExpressionNullValidationException An exception thrown when a query contains an expression that does not reference either a column or custom expression.
Public class ExpressionStringNullValidationException An exception thrown when an expression string is null.
Public class FilterByAmbiguousColumnValidationException An exception thrown when a query contains a filter criteria that references a column with an ambiguous name.
Public class FilterByColumnOfMissingTableValidationException An exception thrown when a query has a filter criteria that is not contained in any of the selected tables.
Public class FilterByMissingInSchemaColumnValidationException An exception thrown when a query has a filter criteria that is missing in the data source schema.
Public class Group Specifies the grouping options of a SelectQuery.
Public class GroupByAggregateColumnValidationException An exception thrown when a query has a grouping criteria that is an aggregate column.
Public class GroupByWithoutAggregateValidationException An exception thrown when a query has a grouping criteria and some of the selected columns have not been assigned an aggregate expression.
Public class GroupingInfo Obsolete. Use the corresponding functionality of the SelectQuery class instead.
Public class GroupingInfoList Obsolete. Use the corresponding functionality of the SelectQuery class instead.
Public class GroupNullValidationException An exception thrown when a query has a grouping criteria that is null.
Public class HavingWithoutGroupByValidationException An exception thrown when a query contains group filtering criteria and the data is not actually grouped.
Public class IncompleteRelationValidationException An exception thrown when a query contains a relation for which not all required information has been provided.
Public class InvalidExpressionStringValidationException An exception thrown when a query contains an invalid expression.
Public class Join A relation between two data tables created using a join operation in a SelectQuery.
Public class MasterDetailInfo Identifies the master-detail relationship defined by associated SQL queries.
Public class MasterDetailInfoCollection A collection of MasterDetailInfo objects.
Public class NegativeTopSkipValidationException An exception thrown when a negative Top or Skip value has been specified.
Public class NoColumnsValidationException An exception thrown when no columns have been selected for any of the selected tables.
Public class NoRelationColumnsValidationException An exception thrown when a query contains a relation for which no key columns have been specified.
Public class NoTablesValidationException An exception thrown when no tables have been selected by a query.
Public class PartialAggregationValidationException An exception thrown when a grouping and/or aggregate expression has not been applied to each of the selected columns.
Public class QueryExecutionException An exception thrown when a query execution has failed.
Public class QueryParameter A parameter passed to a SqlQuery.
Public class RecordsCount The total number of records in selected data tables or in each group.
Public class RelationColumnInfo Stores the master and nested keys of a data relation column.
Public class RelationColumnNotInSchemaValidationException An exception thrown when a key column of a data relation is missing in the data source schema.
Public class RelationColumnNullValidationException An exception thrown when the key column of a data relation is null.
Public class RelationException An exception thrown when attempting to assign a data relation to unrelated columns.
Public class RelationInfo Obsolete. Use the corresponding functionality of the SelectQuery class instead.
Public class RelationInfoList Obsolete. Use the corresponding functionality of the SelectQuery class instead.
Public class RelationNullValidationException An exception thrown when a data relation is null.
Public class RelationTableNotSelectedValidationException An exception thrown when a data relation references a table that has not been selected.
Public class ResultSchemaProvider The default implementation of the IResultSchemaProvider interface.
Public class SelectQuery A set of columns (from a single table or multiple joined tables), which forms a SELECT statement when executing a query.
Public class SelectQueryFluentBuilder Provides methods that can be chained within a single statement specifying a SelectQuery.
Public class SkipWithoutSortingValidationException An exception thrown when specifying the Skip property without sorting the corresponding table.
Public class SortByAggregateColumnValidationException An exception thrown when a query contains a sorting criterion that is an aggregate column.
Public class Sorting Specifies the sorting options of a SelectQuery.
Public class SortingBySameColumnTwiceValidationException An exception thrown when the same sorting criterion has been applied multiple times.
Public class SortingInfo Obsolete. Use the corresponding functionality of the SelectQuery class instead.
Public class SortingInfoList Obsolete. Use the corresponding functionality of the SelectQuery class instead.
Public class SortingNullValidationException An exception thrown when a query contains a sorting criterion that is null.
Public class SqlDataConnection A connection to a SqlDataSource.
Public class SqlDataSource The data source for Windows Forms data-aware controls that binds these controls to a database (in read-only mode) while allowing you to configure the data connection options.
Public class SqlQuery A formalized description of a database query used to select data from SqlDataSource.
Public class SqlQueryCollection A collection of SqlQuery objects in the SqlDataSource.
Public class SqlStringEmptyValidationException An exception thrown when an SQL string is null or empty.
Public class StoredProcNameNullValidationException An exception thrown when a stored procedure name has not been specified.
Public class StoredProcNotInSchemaValidationException An exception thrown when a referenced stored procedure is missing in the data source schema.
Public class StoredProcParamCountValidationException An exception thrown when there is a mismatch between the specified and expected number of parameters specified for a stored procedure.
Public class StoredProcParamNameValidationException An exception thrown when there is a mismatch between the specified and expected stored procedure parameter names.
Public class StoredProcParamNullValidationException An exception thrown when a stored procedure parameter is null.
Public class StoredProcParamTypeValidationException An exception thrown when there is a mismatch between the specified and expected stored procedure parameter types.
Public class StoredProcQuery A stored procedure call.
Public class Table A data table retrieved by an associated SelectQuery.
Public class TableInfo Obsolete. Use the corresponding functionality of the SelectQuery class instead.
Public class TableInfoList Obsolete. Use the corresponding functionality of the SelectQuery class instead.
Public class TableNotInSchemaValidationException An exception thrown when a query references a table that is missing in the data source schema.
Public class TableNotSelectedValidationException An exception thrown when a query references a column that is not contained in any of the selected tables.
Public class TableNullValidationException An exception thrown when a query references a table that is null.
Public class TableQuery Obsolete. Use the SelectQuery class instead.
Public class TablesNotRelatedValidationException An exception thrown when a query references multiple tables without specifying their relations.
Public class UnnamedColumnValidationException An exception thrown when a query references a column without specifying its name.
Public class UnnamedTableValidationException An exception thrown when a query references a table without specifying its name.
Public class ValidationException The exception occurring after a query validation has failed.

Expanded Interfaces

  Interface Description
Public interface IDBSchemaProvider For internal use. Use the IDBSchemaProviderEx interface instead.
Public interface IDBSchemaProviderEx Provides the capability to customize the database schema.
Public interface IResultSchemaProvider If implemented, enables you to obtain and customize a data source schema.

Expanded Delegates

  Delegate Description
Public delegate ConfigureDataConnectionEventHandler References a method that will handle the ConfigureDataConnection event.
Public delegate ConnectionErrorEventHandler A method that will handle the ConnectionError event.
Public delegate CustomizeFilterExpressionEventHandler References a method that will handle the CustomizeFilterExpression event.

Expanded Enumerations

  Enumeration Description
Public enum AggregationType Lists values that specify aggregation types.
Public enum ConditionType Lists the values that specify the relational operator type.
Public enum SchemaLoadingMode Lists the values specifying whether the data source schema should include stored procedures, tables (views), or both.
How would you rate this topic?​​​​​​​