[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
 [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.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Json
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Expand]DevExpress.DataAccess.Sql
  [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.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.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.WebUtils
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpo
  [Collapse]DevExpress.Xpo.DB
    AutoCreateOption Enumeration
   [Expand]BaseStatement Class
   [Expand]ConnectionProviderSql Class
   [Expand]DataCacheNode Class
   [Expand]DataCacheNodeLocal Class
   [Expand]DataCacheRoot Class
   [Expand]DataStoreBase Class
   [Expand]DataStoreLogger Class
   [Expand]DBColumn Class
    DBColumnType Enumeration
   [Expand]DBForeignKey Class
   [Expand]DBIndex Class
   [Expand]DBNameTypePair Class
   [Expand]DBPrimaryKey Class
   [Expand]DBStoredProcedure Class
   [Expand]DBStoredProcedureArgument Class
    DBStoredProcedureArgumentDirection Enumeration
   [Expand]DBStoredProcedureResultSet Class
   [Expand]DBTable Class
   [Expand]DBTableMultiColumnGadget Class
   [Expand]DeleteStatement Class
   [Expand]ICachedDataStore Interface
   [Expand]ICacheToCacheCommunicationCore Interface
   [Expand]IDataStore Interface
   [Expand]InsertStatement Class
   [Expand]ISqlDataStore Interface
   [Expand]JoinNode Class
   [Expand]JoinNodeCollection Class
    JoinType Enumeration
   [Expand]ModificationResult Class
   [Expand]ModificationStatement Class
   [Expand]ParameterValue Class
   [Expand]QueryOperand Class
   [Expand]QueryOperandCollection Class
   [Expand]QueryParameterCollection Class
   [Expand]QuerySortingCollection Class
   [Expand]SelectedData Class
   [Expand]SelectStatement Class
   [Expand]SelectStatementResult Class
   [Expand]SortingColumn Class
    SortingDirection Enumeration
    UpdateSchemaResult Enumeration
   [Expand]UpdateStatement Class
  [Expand]DevExpress.Xpo.DB.Exceptions
  [Expand]DevExpress.Xpo.DB.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.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]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

DevExpress.Xpo.DB Namespace

Contains classes that handle operations on a data store.

Expanded Classes

  Class Description
Public class BaseStatement Serves as the base class for the classes that represent statements.
Public class ConnectionProviderSql Implements the base functionality for SQL-based data store adapters, including the MSSqlConnectionProvider and other adapters listed in the Database Systems Supported by XPO topic.
Public class DataCacheNode The Node element that is used to connect to a cached data store's Root or Node element.
Public class DataCacheNodeLocal The Node element that is used to connect to a cached data store's Root or Node element located on the local host.
Public class DataCacheRoot The Root element that is used to connect Node elements to a cached data store.
Public class DataStoreBase The base class for data store providers (the objects providing access to specific data stores).
Public class DataStoreLogger Enables operations performed by a specific IDataStore object to be logged.
Public class DBColumn The schema of a column in a DBTable.
Public class DBForeignKey The foreign key of a table.
Public class DBIndex For internal use. An index of a table.
Public class DBNameTypePair Stores a pair of values, specifying a DBColumnType along with its corresponding name.
Public class DBPrimaryKey The primary key of a table.
Public class DBStoredProcedure A stored procedure.
Public class DBStoredProcedureArgument Provides information about a stored procedure's parameter.
Public class DBStoredProcedureResultSet A result set of a stored procedure.
Public class DBTable A table that stores a persistent object's data.
Public class DBTableMultiColumnGadget An abstract base class for DBPrimaryKey, DBForeignKey and DBIndex.
Public class DeleteStatement Represents the delete statement.
Public class InsertStatement Represents the insert statement.
Public class JoinNode Serves as a base for the BaseStatement class.
Public class JoinNodeCollection Represents a collection of JoinNode objects.
Public class ModificationResult Represents the result of an update operation on a data store.
Public class ModificationStatement Serves as the base class for classes that represent modification statements.
Public class ParameterValue This class supports the internal infrastructure and is not intended to be used directly from your code.
Public class QueryOperand Represents a query operand.
Public class QueryOperandCollection Represents a collection of QueryOperand objects.
Public class QueryParameterCollection Represents a collection of DevExpress.Data.Filtering.OperandValue objects.
Public class QuerySortingCollection Represents a collection of SortingColumn objects.
Public class SelectedData Represents the result of batch select queries made to a data store.
Public class SelectStatement Represents the select statement.
Public class SelectStatementResult Represents the result of a single select query to a data store.
Public class SortingColumn Represents a sorting column in a query.
Public class UpdateStatement Represents the update statement.

Expanded Interfaces

  Interface Description
Public interface ICachedDataStore The interface for objects that need to interact with a cached data store.
Public interface ICacheToCacheCommunicationCore Provides methods for transferring data between cached data store elements.
Public interface IDataStore The interface for objects that need to interact with a data store.
Public interface ISqlDataStore Represents the interface for objects that need to interact with SQL Server databases,

Expanded Enumerations

  Enumeration Description
Public enum AutoCreateOption Lists the values that specify the action which is performed when a session is connected to a data store.
Public enum DBColumnType Lists the supported database column types.
Public enum DBStoredProcedureArgumentDirection Lists the directions available for a stored procedure's parameter.
Public enum JoinType Lists the values that specify the join type.
Public enum SortingDirection Lists the values that specify the sort order.
Public enum UpdateSchemaResult Lists the values that specify the result of the data store schema update operation.
Is this topic helpful?​​​​​​​