Export (0) Print
Expand All

System.Data.SqlServerCe Namespace Overview

SQL Server 2005

The System.Data.SqlServerCe namespace provides programmatic access to Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) databases from a managed application. System.Data.SqlServerCe provides a set of classes that make available the functionality of SQL Server Compact Edition. For more information, see Managed Data Provider (SQL Server Compact Edition).

Note:
Links to System.Data.SqlServerCe reference topics function only when the .NET Framework 2.0 SDK is installed and when both it and the SQL Server Compact Edition Books Online collection are included in the same collection. For more information, search for "Visual Studio 2005 Combined Help Collection Manager" in the Microsoft Visual Studio 2005 documentation or search for "SQL Server 2005 Combined Help Collection Manager" in SQL Server 2005 Books Online.

The following table describes the classes in the System.Data.SqlServerCe namespace.

Class Description

SqlCeCommand

Represents an SQL statement that is run against the SQL Server Compact Edition data source.

SqlCeCommandBuilder

Uses the SELECT command from a SqlCeDataAdapter object to generate INSERT, UPDATE, and DELETE commands.

SqlCeConnection

Represents a connection to the SQL Server Compact Edition data source.

SqlCeDataAdapter

Represents a set of SqlCeCommand objects and a SqlCeConnection object that are used to fill a DataSet object and to update the data source.

SqlCeDataReader

Provides a way of reading data from a SQL Server Compact Edition data source in a forward-only stream of data rows.

SqlCeEngine

Represents the properties, methods, and other objects of the SQL Server Compact Edition engine. This class is used to create, modify, and delete a SQL Server Compact Edition database.

SqlCeError

Collects information about a specific SqlCeException object returned by a SQL Server Compact Edition data source.

SqlCeErrorCollection

Collects all errors generated by the data provider for SQL Server Compact Edition.

SqlCeException

Represents the exception that is thrown when the underlying provider returns a warning or error from the SQL Server Compact Edition data source.

SqlCeInfoMessageEventArgs

Provides data for the InfoMessage event, which occurs when SQL Server Compact Edition sends a warning or informational message.

SqlCeParameter

Represents a parameter used with a SqlCeCommand object and, optionally, the parameter's mapping to a column in a DataSet object.

SqlCeParameterCollection

Collects all parameters relevant to a SqlCeCommand and the parameters' mappings to columns in a DataSet object.

SqlCeRemoteDataAccess

Provides the methods and properties needed to synchronize data with Microsoft SQL Server anonymously by using remote data access.

SqlCeReplication

Provides the methods and properties needed to synchronize data with Microsoft SQL Server by using merge replication.

SqlCeResultSet

Provides a scrollable, updateable cursor that is faster than a DataSet and more flexible than a DataReader.

SqlCeRowUpdatedEventArgs

Provides data for the RowUpdated event, which occurs during an update of a SQL Server Compact Edition data source, after the command is run.

SqlCeRowUpdatingEventArgs

Provides data for the RowUpdating event, which occurs during an update of a SQL Server Compact Edition data source, but before the command is run.

SqlCeTransaction

Represents an SQL transaction to be made on the SQL Server Compact Edition data source.

Delegate Description

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 will handle the RowUpdating event of a SqlCeDataAdapter.

Enumeration Description

AddOption

Specifies the source of the newly created SQL Server Compact Edition database.

DbRangeOptions

Options used by SetRange when specifying the index range over which to Seek.

DbSeekOptions

Options that specify how to Seek on an index.

DropOption

Specifies whether to leave or delete the SQL Server Compact Edition database during a drop subscription.

ExchangeType

Specifies whether data merges up to the Publisher or in both directions between the Publisher and the Subscriber.

NetworkType

Specifies the network protocol used.

RdaBatchOption

Specifies whether the rows associated with the Push should be batched together in a single transaction.

RdaTrackOption

Specifies whether the table being pulled to the device is tracked.

SecurityType

Specifies the mode of security enforced.

ValidateType

Specifies the type of data validation to perform.

Community Additions

ADD
Show:
© 2014 Microsoft