[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]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
  Core Library Assemblies
 [Expand]DevExpress Data Library
 [Expand]DevExpress Pivot Grid Core 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.DataFederation
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Json
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Collapse]DevExpress.DataAccess.Sql
   [Expand]AggregateQueryInvalidSortingValidationException Class
    AggregationType Enumeration
   [Expand]AggregationWithoutAliasValidationException Class
   [Expand]AliasedBase Class
   [Collapse]AllColumns Class
     AllColumns Members
     AllColumns Constructor
    [Expand]AllColumns Properties
   [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
  [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.Gantt
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office.Crypto
  [Expand]DevExpress.PivotGrid.Printing
  [Expand]DevExpress.Printing
  [Expand]DevExpress.Printing.Core
  [Expand]DevExpress.Printing.ExportHelpers
  [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.Security.Resources
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [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.Utils.Svg
  [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.Helpers
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Native
  [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.Caching
  [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.Expressions
  [Expand]DevExpress.XtraReports.Parameters
  [Expand]DevExpress.XtraReports.ReportGeneration
  [Expand]DevExpress.XtraReports.UI
  [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.XtraSpellChecker.Rules
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

AllColumns Class

Corresponds to all columns from one or more data tables selected by a SelectQuery.

Namespace:DevExpress.DataAccess.Sql
Assembly:DevExpress.DataAccess.v19.2.dll

Expanded Syntax

Expanded Remarks

An AllColumns object is returned by the SelectQuery.SelectAll method.

Setting the Table property to null will select all columns from all selected data tables.

Expanded Inheritance Hierarchy

System.Object
    ColumnBase
       AllColumns

Expanded See Also

Is this topic helpful?​​​​​​​