Learn how to create and delete data in SQL CE using LINQ to SQL
Cover McObject's Perst as an embedded object data store
Learn to save and delete data in the Perst database
Introduction
In Chapter 3, XML as a Data Store, we learned how we can persist data to local storage using Object serialization and XML. In this chapter, we shall discuss different options available for both commercial and open source on-device databases.
SQLite Client for Phone 7: This is ported from the popular SQLite to work on Phone 7 devices
Microsoft SQL CE: This is the Microsoft SQL Server Compact Edition
McObject's Perst: This is a commercial On-Device database