Chapter 6. Manipulating the Database

IN THIS CHAPTER

In the previous chapters you learned how to define a database structure and manage database operations such as repair and compact. In this chapter you will learn how to access and manipulate data in the SQL Server Compact Edition database. There are two main scenarios in which you will be querying or updating a database:

  1. Executing the SQL Queries on an SQL Server Compact Edition database either using tools or programmatically.

  2. Using ADO.NET or OLE DB provider for SQL Server Compact Edition to execute queries programmatically.

While developing applications for SQL Server Compact Edition, you ...

Get Microsoft SQL Server 2005, Compact Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial