Chapter 5. Using On-Device Databases

In this chapter, we will:

  • Get an overview of SQLite Studio
  • Explore creating and editing an SQLite file
  • Learn how to use SQLite as an embedded database
  • Get an overview of Microsoft SQL CE
  • 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
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset