Querying Databases (SQL Server Compact)

  • Article

Microsoft SQL Server Compact 4.0 supports querying its databases by using various query tools and APIs.

In This Section

The topics in this section provide an overview of how to query SQL Server Compact 4.0 databases.

Section

Description

Using SQL Grammar

Describes how to use SQL syntax to query a database.

Using Query Tools (SQL Server Compact)

Explains the tools you can use to query a SQL Server Compact 4.0 database: Visual Studio Transact-SQL Editor.

Using Programming Interfaces

Describes the process of querying a database by using APIs.

Note

The Transact-SQL Editor is supported for SQL Server Compact 4.0 databases beginning with Visual Studio 2010.