System.Data.SqlServerCe Namespace
The System.Data.SqlServerCe namespace is the managed data provider for SQL Server Compact 3.5 SP1. This namespace is a collection of classes that provide access to SQL Server Compact 3.5 SP1 databases. By using System.Data.SqlServerCe, you can create, manage, and synchronize SQL Server Compact 3.5 SP1 databases from a smart device or a computer.
The following features are available for creating SQL Server Compact 3.5 SP1 desktop applications.
Support for the System.Transaction.TransactionScope class.
SQL Server Compact 3.5 SP1 provider for the Entity Framework (System.Data.SqlServerCe.Entity.dll).
Support for Visual C++ Express Edition and Visual Basic Express Edition application development in Visual Studio 2008.
Support for synchronizing data by using Sync Services for ADO.NET.
Classes
| Class | Description |
|---|---|
| ResultSetEnumerator | An 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. |
| ResultSetView | Implements data binding interfaces and provides a bridge between user interface controls and the SqlCeResultSet. |
| RowView | |
| SqlCeChangeTracking | Provides the tracking functions needed by Sync Framework providers. |
| SqlCeCommand | Represents an SQL statement to execute against a data source. |
| SqlCeCommandBuilder | Provides a means of automatically generating single-table commands used to reconcile changes made to a DataSet with the associated database. This class cannot be inherited. |
| SqlCeConnection | Represents an open connection to a SQL Server Compact 3.5 SP1 data source. |
| SqlCeDataAdapter | Represents a set of data commands and a database connection that are used to fill the DataSet and update the data source. |
| SqlCeDataReader | Provides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited. |
| SqlCeEngine | Represents the properties, methods, and other objects of the SQL Server Compact 3.5 SP1 Engine object. This class cannot be inherited. |
| SqlCeError | Collects information relevant to a warning or error returned by the data source. This class cannot be inherited. |
| SqlCeErrorCollection | Collects all errors generated by the .NET Compact Framework Data Provider for SQL Server Compact 3.5 SP1. This class cannot be inherited. |
| SqlCeException | The exception thrown when the underlying provider returns a warning or error from a SQL Server Compact 3.5 SP1 data source. This class cannot be inherited. |
| SqlCeFlushFailureEventArgs | Encapsulates event arguments for the FlushFailure event. |
| SqlCeInfoMessageEventArgs | Provides data for the InfoMessage event. This class cannot be inherited. |
| SqlCeInvalidDatabaseFormatException | Throws an exception from SQL Server Compact data source when you try to open the database file of an older or newer version of SQL Server Compact. |
| SqlCeLockTimeoutException | This exception is thrown if the lock timeout has been reached. |
| SqlCeParameter | Represents a parameter to a SqlCeCommand and, optionally, its mapping to a DataSet column. This class cannot be inherited. |
| SqlCeParameterCollection | Collects all parameters relevant to a SqlCeCommand as well as their respective mappings to DataSet columns. |
| SqlCeProviderFactory | Represents a set of methods for creating instances of a provider's implementation of the data source classes. |
| SqlCeRemoteDataAccess | Initializes a new instance of the SqlCeRemoteDataAccess object. For more information about Remote Data Access, see Using Remote Data Access (RDA). |
| SqlCeReplication | Initializes a new instance of the SqlCeReplication object. For more information about SQL Server replication, see the SQL Server Books Online. For more information about merge replication with SQL Server Compact 3.5 SP1, see the SQL Server Compact 3.5 SP1 Books Online. |
| SqlCeResultSet | An updateable, scrollable, and bindable cursor. |
| SqlCeRowUpdatedEventArgs | Provides data for the RowUpdated event. |
| SqlCeRowUpdatingEventArgs | Provides data for the RowUpdating event. |
| SqlCeTransaction | Represents an SQL transaction to be made at a data source. This class cannot be inherited. |
| SqlCeTransactionInProgressException | Occurs when an attempt is made to modify a database while another transaction is in progress. |
| SqlCeType | |
| SqlCeUpdatableRecord | Represents a row of updatable values from the data source. A SqlCeResultSet object contains one or more UpdatableRecords. |
| SqlMetaData | Specifies and retrieves metadata information from parameters and columns retrieved from a database. This class cannot be inherited. |
Delegates
| Delegate | Description |
|---|---|
| OnStartTableDownload | A user-defined delegate to the event that fires at the start of downloading table changes from the server. |
| OnStartTableUpload | A user-defined delegate to the event that fires at the start of uploading table changes to the server. |
| OnSynchronization | A user-defined delegate that consumes the ongoing synchronization events reported during the reconciler work. |
| SqlCeFlushFailureEventHandler | The delegate that must be implemented to listen for FlushFailure events. |
| SqlCeInfoMessageEventHandler | Represents the method that will handle the InfoMessage event of a SqlCeConnection. |
| SqlCeRowUpdatedEventHandler | Represents the method that will handle the RowUpdated event of a SqlCeDataAdapter. |
| SqlCeRowUpdatingEventHandler | Represents the method that handles the RowUpdating event of a SqlCeDataAdapter. |
Enumerations
| Enumeration | Description |
|---|---|
| AddOption | Determines whether the subscription will be added to an existing database or whether a new database will be created when the subscription is added. |
| CommitMode | When passed to the Commit function, the CommitMode specifies when the commit occurs. |
| DbInsertOptions | Specifies the options to use when using the System.Data.SqlServerCe.SqlCeResultSet.Insert method. |
| DbRangeOptions | Specifies the options used by the SetRange method when specifying the index range over which to seek. |
| DbSeekOptions | Options that specify how the Seek method will seek on an index. |
| DropOption | Specifies whether to leave or delete the database when dropping a subscription using the DropSubscription method. |
| ExchangeType | Specifies whether data is merged up to the Publisher only, or merge in both directions between the Publisher and the Subscriber. |
| NetworkType | Specifies the network protocol to use when setting the DistributorNetwork or PublisherNetwork properties of the SqlCeReplication object. |
| PurgeType | Contains values specifying the type of data deletion (purging) to perform. |
| RdaBatchOption | Specifies whether or not the rows associated with the Push should be batched together in a single transaction. |
| RdaTrackOption | Specifies whether or not the table being pulled to the device is tracked. |
| RepairOption | When passed to the Repair method, RepairOption specifies the type of database repair to perform. |
| ResultSetOptions | Sets options for the ResultSetEnumerator. |
| ResultSetSensitivity | Sets the sensitivity of the ResultSetEnumerator. |
| SecurityType | Specifies the mode of security to use when connecting to the Publisher or Distributor during Replication. |
| SnapshotTransferType | Controls how snapshot files are transferred from the Distributor to the computer running IIS. |
| TrackingKeyType | Contains values specifying the type of key identification when tracking is enabled. |
| TrackingOptions | Determines which operations on a table are tracked. |
| ValidateType | Specifies the type of data validation to perform. |
| VerifyOption | These options determine the level of database verification to use. |