NorthwindOleDb Native Sample Application
NorthwindOleDb is a Visual C++ for sample application that shows the use of OLE DB to create and interact with a SQL Server Compact 4.0 database. The application creates a database through OLE DB, creates a table, inserts data using SQL statements, and then retrieves data from the database by using IRowsetSeek.
The NorthwindOleDb Native sample can be downloaded from the SQL Server Compact Download site. The installation location of the sample is %Program Files%\Microsoft SQL Server Compact Edition\v4.0\Samples.