A new book has been published this spring, which supplements the other books available on Windows Mobile development with SQL Server Compact. It covers from a very practical and hands-on perspective many facets of Windows Mobile development (now a legacy platform). It attempts to cover use cases for even the more obscure Windows Mobile technologies, like MSMQ, Infrared and Bluetooth, and Pocket Outlook, so it cover a lot of ground.
In terms of data access, there are three chapters devoted to various aspects of this domain:
Building the Data Tier: Describes how to build a data provider independent data layer, and implement this with both SQL Server Compact and Oracle Lite.
Building Search Functionality: Describes how to implement a standard parameterized search function, and also how to implement full text search for SQL Server Compact (a question often asked in the MSDN forums).
Data Synchronization: Describes how to implement Microsoft Sync Services on Windows Mobile, including adding filters and conflict resolution.
Optimizing for Performance: Describes how to optimize for performance using caching and indexes. As the data access layer is based on DataSet, there is no mention of using SqlCeResultSet, Seek and similar APIs for SQL Server Compact.
You can read more about the book here.