Export (0) Print
Expand All

Development Environment

SQL Server 2000

Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE) supports two development environments: Microsoft Visual Studio® .NET and Microsoft eMbedded Visual Tools. Both environments provide a set of data access application programming interfaces (APIs) and a subset of SQL syntax that work specifically with SQL Server CE.

Microsoft Visual Studio .NET

Microsoft Visual Studio .NET provides an application development platform for Microsoft Windows CE-based devices. Using Microsoft Visual Basic® .NET or Microsoft Visual C#™ .NET, you can develop Windows CE-based applications that communicate with databases in SQL Server and SQL Server CE.

Note  This feature has been designed to be used in conjunction with a prerelease version of an anticipated successor to Microsoft Visual Studio .NET. Check the documentation accompanying the commercially released version for any updates.

The following illustration shows the relationship of the different components.

Illustration showing the relationship of the different components that interact with SQL Server CE in the Visual Studio .NET development environment.

For more information, see Development Tools.

Microsoft eMbedded Visual Tools

By using Microsoft eMbedded Visual Basic 3.0 or Microsoft eMbedded Visual C++® version 3.0 and version 4.0, you can apply your knowledge of Visual Basic or Visual C++ to develop Windows CE-based applications. You can create application code using a code editor, form editor, and property pane, which are similar to those used in Visual Basic or Visual C++. Like Visual Basic and Visual C++, eMbedded Visual Tools also provides an integrated development environment (IDE).

The following illustration shows the relationship of the different components.

Illustration showing how the different components that interact with SQL Server CE relate in the eMbedded Visual Tools development environment.

To develop applications with the eMbedded Visual Tools, the software development kit (SDK) for Handheld PC 2000, Pocket PC, or Pocket PC 2002 must be installed on the device. These SDKs include Windows CE-based device emulators, which provide the look of a physical device on the desktop computer. SQL Server CE-based applications can be created on a desktop computer and then tested on the emulator; so, no device is required.

For more information, see Development Tools.

Familiar Data Access Technologies

SQL Server CE is implemented as a set of dynamic-link libraries (DLLs) that support the following data access technologies:

  • Microsoft ActiveX® Data Objects for Windows CE 3.1 (ADOCE) and Microsoft ActiveX Data Objects Extensions for Data Definition Language (DDL) and Security (ADOXCE)
  • OLE DB Provider for SQL Server CE

ADOCE, ADOXCE, and ADO.NET are based on ADO, which is a high-level interface to all types of data. ADOCE provides consistent, high-performance access to data for developers using eMbedded Visual Basic to program applications for Windows CE. ADOCE is the most widely used interface for creating, accessing, and modifying SQL Server CE databases. ADOXCE extends ADOCE to expose additional objects for creating, modifying, and deleting schema objects. Schema objects are the attributes of the database, such as columns, indexes, tables, and properties. A subset of ADO.NET, which provides the same high-performance access to data for developers who are using Visual Basic .NET and C# as ADOCE, is available for Windows CE-based devices.

OLE DB is a low-level data interface technology. OLE DB for SQL Server CE can be used from eMbedded Visual C++, and it provides more granular capabilities than ADOCE or ADOXCE when used with SQL Server CE. Of all the data access APIs, OLE DB for SQL Server CE provides the fastest data manipulation and access.

For more information about programming with these objects, see Building Applications.

Familiar SQL Grammar

SQL Server CE includes SQL grammar that allows applications to query a database and insert, update, and delete data in the database. This grammar is compatible with the SQL grammar of other versions of Microsoft SQL Server. Most statements that run on SQL Server CE also run on SQL Server databases.

SQL Server CE also supports intrinsic functions that are consistent with functions provided in SQL Server.

For more information, see SQL Reference for SQL Server CE.

© 2016 Microsoft