Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collapse the table of content
Expand the table of content

System.Data.SqlServerCe Namespace

The System.Data.SqlServerCe namespace is the managed data provider for SQL Server Compact Edition. This data provider is a collection of classes that is used in the managed development environment to provide access to SQL Server Compact Edition databases. By using System.Data.SqlServerCe, you can create, manage, and synchronize SQL Server Compact Edition databases from a smart device, Tablet PC, or a desktop application.

Public classResultSetEnumeratorAn enumerator that can be used to iterate through a collection of records in a ResultSet object. The ResultSetEnumerator is not designed to be used directly from within your code. You will get more functionality by working directly with the SqlCeResultSet object.
Public classResultSetViewImplements data binding interfaces and provides a bridge between user interface controls and the SqlCeResultSet.
Public classRowViewImplements data binding interfaces as part of the ResultSetView. Not intended for use directly from your code.
Public classSqlCeCommandRepresents an SQL statement to execute against a data source.
Public classSqlCeCommandBuilderProvides a means of automatically generating single-table commands used to reconcile changes made to a DataSet with the associated Microsoft SQL Server 2005 Compact Edition database. This class cannot be inherited.
Public classSqlCeConnectionRepresents an open connection to a data source.
Public classSqlCeDataAdapterRepresents a set of data commands and a database connection that are used to fill the DataSet and update the data source.
Public classSqlCeDataReaderProvides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited.
Public classSqlCeEngineRepresents the properties, methods, and other objects of the Microsoft SQL Server 2005 Compact Edition Engine object. This class cannot be inherited.
Public classSqlCeErrorCollects information relevant to a warning or error returned by the data source. This class cannot be inherited.
Public classSqlCeErrorCollectionCollects all errors generated by the .NET Compact Framework Data Provider for Microsoft SQL Server 2005 Compact Edition. This class cannot be inherited.
Public classSqlCeExceptionThe exception thrown when the underlying provider returns a warning or error from a Microsoft SQL Server 2005 Compact Edition data source. This class cannot be inherited.
Public classSqlCeFlushFailureEventArgsEncapsulates event arguments for the FlushFailure event.
Public classSqlCeInfoMessageEventArgsProvides data for the InfoMessage event. This class cannot be inherited.
Public classSqlCeLockTimeoutExceptionThis exception is thrown if the lock timeout has been reached.
Public classSqlCeParameterRepresents a parameter to a SqlCeCommand and, optionally, its mapping to a DataSet column. This class cannot be inherited.
Public classSqlCeParameterCollectionCollects all parameters relevant to a SqlCeCommand as well as their respective mappings to DataSet columns.
Public classSqlCeRemoteDataAccessInitializes a new instance of the SqlCeRemoteDataAccess object. For more information about Remote Data Access, see the SQL Server Compact Edition Books Online.
Public classSqlCeReplicationInitializes a new instance of the SqlCeReplication object. For more information about SQL Server replication, see the SQL Server 2005 Books Online. For more information about merge replication with SQL Server Compact Edition, see the SQL Server Compact Edition Books Online.
Public classSqlCeResultSetAn updateable, scrollable, and bindable cursor.
Public classSqlCeRowUpdatedEventArgsProvides data for the RowUpdated event.
Public classSqlCeRowUpdatingEventArgsProvides data for the RowUpdating event.
Public classSqlCeTransactionRepresents an SQL transaction to be made at a data source. This class cannot be inherited.
Public classSqlCeTransactionInProgressExceptionOccurs when an attempt is made to modify a database while another transaction is in progress.
Public classSqlCeType 
Public classSqlCeUpdatableRecordRepresents a row of updatable values from the data source. A SqlCeResultSet object contains one or more UpdatableRecords.
Public classSqlMetaDataSpecifies and retrieves metadata information from parameters and columns retrieved from a database. This class cannot be inherited.

Public delegateOnStartTableDownloadA user-defined delegate to the event that fires at the start of downloading table changes from the server.
Public delegateOnStartTableUploadA user-defined delegate to the event that fires at the start of uploading table changes to the server.
Public delegateOnSynchronizationA user-defined delegate that consumes the ongoing synchronization events reported during the reconciler work.
Public delegateSqlCeFlushFailureEventHandlerThe delegate that must be implemented to listen for FlushFailure events.
Public delegateSqlCeInfoMessageEventHandlerRepresents the method that will handle the InfoMessage event of a SqlCeConnection.
Public delegateSqlCeRowUpdatedEventHandlerRepresents the method that will handle the RowUpdated event of a SqlCeDataAdapter.
Public delegateSqlCeRowUpdatingEventHandlerRepresents the method that handles the RowUpdating event of a SqlCeDataAdapter.

Public enumerationAddOptionDetermines whether the subscription will be added to an existing database or whether a new database will be created when the subscription is added.
Public enumerationCommitModeWhen passed to the Commit function, the CommitMode specifies when the commit occurs.
Public enumerationDbInsertOptionsSpecifies the options to use when using the System.Data.SqlServerCe.SqlCeResultSet.Insert method.
Public enumerationDbRangeOptionsSpecifies the options used by the SetRange method when specifying the index range over which to seek.
Public enumerationDbSeekOptionsOptions that specify how the Seek method will seek on an index.
Public enumerationDropOptionSpecifies whether to leave or delete the Microsoft SQL Server 2005 Compact Edition database when dropping a subscription using the DropSubscription method.
Public enumerationExchangeTypeSpecifies whether data is merged up to the Publisher only, or merge in both directions between the Publisher and the Subscriber.
Public enumerationNetworkTypeSpecifies the network protocol to use when setting the DistributorNetwork or PublisherNetwork properties of the SqlCeReplication object.
Public enumerationRdaBatchOptionSpecifies whether or not the rows associated with the Push should be batched together in a single transaction.
Public enumerationRdaTrackOptionSpecifies whether or not the table being pulled to the device is tracked.
Public enumerationRepairOptionWhen passed to the Repair method, RepairOption specifies the type of database repair to perform.
Public enumerationResultSetOptionsSets options for the ResultSetEnumerator.
Public enumerationResultSetSensitivitySets the sensitivity of the ResultSetEnumerator.
Public enumerationSecurityTypeSpecifies the mode of security to use when connecting to the Publisher or Distributor during Replication.
Public enumerationSnapshotTransferTypeControls how snapshot files are transferred from the Distributor to the computer running IIS.
Public enumerationValidateTypeSpecifies the type of data validation to perform.

Community Additions

© 2015 Microsoft