Querying Databases (SQL Server Compact)

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

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



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 Note

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