[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]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [Expand]DevExpress ORM Tool
 [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.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
  [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.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.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
  [Collapse]DevExpress.Xpo.DB
   [Expand]AccessConnectionProvider Class
   [Expand]AccessConnectionProviderMultiUserThreadSafe Class
    AutoCreateOption Enumeration
   [Expand]BaseStatement Class
   [Expand]CachedDataStoreClient Class
   [Expand]CachedDataStoreService Class
   [Expand]ConnectionProviderSql Class
   [Expand]DataCacheNode Class
   [Expand]DataCacheNodeLocal Class
   [Expand]DataCacheRoot Class
   [Expand]DataStoreBase Class
   [Expand]DataStoreClient Class
   [Expand]DataStoreLogger Class
   [Expand]DataStoreService 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]FirebirdConnectionProvider Class
   [Expand]ICachedDataStore Interface
   [Expand]ICachedDataStoreService Interface
   [Expand]ICacheToCacheCommunicationCore Interface
   [Expand]IDataStore Interface
   [Expand]IDataStoreService Interface
   [Expand]InMemoryDataStore Class
   [Expand]InsertStatement Class
   [Expand]ISerializableObjectLayerService Interface
   [Expand]ISqlDataStore Interface
   [Expand]JoinNode Class
   [Expand]JoinNodeCollection Class
    JoinType Enumeration
   [Expand]ModificationResult Class
   [Expand]ModificationStatement Class
   [Expand]MSSqlConnectionProvider Class
   [Expand]OleDBConnectionProvider Class
   [Expand]OperationResult Class
   [Expand]OperationResult<T> Class
   [Expand]ParameterValue Class
   [Expand]PostgreSqlConnectionProvider Class
   [Expand]QueryOperand Class
   [Expand]QueryOperandCollection Class
   [Expand]QueryParameterCollection Class
   [Expand]QuerySortingCollection Class
   [Expand]SelectedData Class
   [Expand]SelectStatement Class
   [Expand]SelectStatementResult Class
   [Expand]SerializableObjectLayerProxyBase Class
   [Expand]SerializableObjectLayerService Class
   [Expand]SerializableObjectLayerServiceClient Class
   [Expand]ServiceBase Class
   [Expand]ServiceExceptionEventArgs Class
   [Expand]SortingColumn Class
    SortingDirection Enumeration
    UpdateSchemaResult Enumeration
   [Expand]UpdateStatement Class
  [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.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.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.Xpo.DB Namespace

Contains classes that handle operations on a data store.

Expanded Classes

  Class Description
Public class AccessConnectionProvider Implements data-aware operations for working with MS Access databases.
Public class AccessConnectionProviderMultiUserThreadSafe Implements an MS Access connection provider that can be used in multi-user and multi-threaded applications.
Public class BaseStatement Serves as the base class for the classes that represent statements.
Public class CachedDataStoreClient A cached data store provider (an ICachedDataStore implementation) for client applications transferring data via WCF.
Public class CachedDataStoreService The base class for WCF services providing access to data via cached data stores (objects implementing the ICachedDataStore interface).
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 DataStoreClient A data store provider (an IDataStore implementation) for client applications transferring data via WCF.
Public class DataStoreLogger Enables operations performed by a specific IDataStore object to be logged.
Public class DataStoreService The base class for WCF services providing access to data directly via data store providers (IDataStore implementors).
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 FirebirdConnectionProvider Implements data-aware operations for working with a Firebird database.
Public class InMemoryDataStore Stores persistent objects in memory. Intended for testing environment.
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 MSSqlConnectionProvider Implements data-aware operations for working with an MS SQL Server or MS SQL Azure database.
Public class OleDBConnectionProvider Implements the base functionality for providers that connect to OLE DB data sources.
Public class OperationResult The result of an operation performed by the DataStoreService, CachedDataStoreService, or SerializableObjectLayerService.
Public class OperationResult<T> The result of an operation performed by the DataStoreService, CachedDataStoreService, or SerializableObjectLayerService.
Public class ParameterValue This class supports the internal infrastructure and is not intended to be used directly from your code.
Public class PostgreSqlConnectionProvider Implements data-aware operations for working with a PostgreSQL database.
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 SerializableObjectLayerProxyBase The base class for DevExpress.Xpo.SerializableObjectLayer proxies.
Public class SerializableObjectLayerService The base class for WCF services providing access to data via distributed object access layers (DevExpress.Xpo.ISerializableObjectLayer implementors).
Public class SerializableObjectLayerServiceClient A distributed object access layer (an DevExpress.Xpo.ISerializableObjectLayer implementation) for client applications transferring data via WCF.
Public class ServiceBase The base class for XPO WCF services.
Public class ServiceExceptionEventArgs Arguments, passed to the GlobalServiceExceptionThrown and ServiceExceptionThrown events.
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 ICachedDataStoreService Defines a WCF service contract to access data stored in cached data stores (objects implementing the ICachedDataStore interface).
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 IDataStoreService Defines a WCF service contract to access data directly via data store providers (objects implementing the IDataStore interface).
Public interface ISerializableObjectLayerService Defines a WCF service contract to access data via DevExpress.Xpo.SerializableObjectLayer objects.
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?​​​​​​​