Querying Databases (SQL Server Compact)

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.