System.Data.SqlServerCe Namespace Overview
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.
System.Data.SqlServerCe classes
The following table describes the classes in the System.Data.SqlServerCe namespace.
| Class | Description |
|---|---|
Represents an SQL statement that is run against the SQL Server Compact Edition data source. |
|
Uses the SELECT command from a SqlCeDataAdapter object to generate INSERT, UPDATE, and DELETE commands. |
|
Represents a connection to the SQL Server Compact Edition data source. |
|
Represents a set of SqlCeCommand objects and a SqlCeConnection object that are used to fill a DataSet object and to update the data source. |
|
Provides a way of reading data from a SQL Server Compact Edition data source in a forward-only stream of data rows. |
|
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. |
|
Collects information about a specific SqlCeException object returned by a SQL Server Compact Edition data source. |
|
Collects all errors generated by the data provider for SQL Server Compact Edition. |
|
Represents the exception that is thrown when the underlying provider returns a warning or error from the SQL Server Compact Edition data source. |
|
Provides data for the InfoMessage event, which occurs when SQL Server Compact Edition sends a warning or informational message. |
|
Represents a parameter used with a SqlCeCommand object and, optionally, the parameter's mapping to a column in a DataSet object. |
|
Collects all parameters relevant to a SqlCeCommand and the parameters' mappings to columns in a DataSet object. |
|
Provides the methods and properties needed to synchronize data with Microsoft SQL Server anonymously by using remote data access. |
|
Provides the methods and properties needed to synchronize data with Microsoft SQL Server by using merge replication. |
|
Provides a scrollable, updateable cursor that is faster than a DataSet and more flexible than a DataReader. |
|
Provides data for the RowUpdated event, which occurs during an update of a SQL Server Compact Edition data source, after the command is run. |
|
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. |
|
Represents an SQL transaction to be made on the SQL Server Compact Edition data source. |
Delegates
| Delegate | Description |
|---|---|
Represents the method that will handle the InfoMessage event of a SqlCeConnection. |
|
Represents the method that will handle the RowUpdated event of a SqlCeDataAdapter. |
|
Represents the method that will handle the RowUpdating event of a SqlCeDataAdapter. |
Enumerations
| Enumeration | Description |
|---|---|
Specifies the source of the newly created SQL Server Compact Edition database. |
|
Options used by SetRange when specifying the index range over which to Seek. |
|
Options that specify how to Seek on an index. |
|
Specifies whether to leave or delete the SQL Server Compact Edition database during a drop subscription. |
|
Specifies whether data merges up to the Publisher or in both directions between the Publisher and the Subscriber. |
|
Specifies the network protocol used. |
|
Specifies whether the rows associated with the Push should be batched together in a single transaction. |
|
Specifies whether the table being pulled to the device is tracked. |
|
Specifies the mode of security enforced. |
|
Specifies the type of data validation to perform. |
See Also
Reference
Programming Reference (SQL Server Compact Edition)
Concepts
Comparing Native and .NET Language Objects (SQL Server Compact Edition)
Other Resources
Building Managed Applications (SQL Server Compact Edition)
IBuySpy Delivery 2005 Sample Application (SQL Server Compact Edition)