Microsoft® .NET Compact Framework Kick Start

Creating a Microsoft SQL Server CE Database

There are two options for creating a SQL Server CE database. One option is to use the SQL Server CE Query Analyzer to graphically create and design a SQL Server CE database. To learn more about the Query Analyzer, see Microsoft SQL Server CE Books Online.

You can also create a SQL Server CE database programmatically by using the SQL Server CE Data Provider classes defined in the System.Data.SqlServerCE namespace. When creating a database programmatically, you only need to interact with one SQL Server CE Data Provider class, System.Data.SqlServerCe.SqlCeEngine. The SqlCeEngine class provides programmable access to the engine-specific features in SQL Server CE. The SqlCeEngine provides two major pieces ...