In Brief

  • SQL Server CE is a small implementation of Microsoft SQL Server that provides rich support for data storage and retrieval.

  • The SqlCeEngine class provides access to core SQL Server CE functionality, such as creating, opening, and closing a SQL Server CE database.

  • The SqlCeDataReader class provides fast, forward-only access to the data stored in a SQL Server CE database.

  • The SqlCeDataAdapter class and the DataSet class provide simple, easy data synchronization between your application and the SQL Server CE database.

  • The SqlCeCommandBuilder class can automatically generate SqlCommand objects for the SqlCeDataAdapter.

Get Microsoft® .NET Compact Framework Kick Start now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial