Book Image

Windows Phone 7.5 Data Cookbook

By : Ramesh Thalli
Book Image

Windows Phone 7.5 Data Cookbook

By: Ramesh Thalli

Overview of this book

Windows Phone 7.5 Mango contains support for apps written in Silverlight or XNA. These apps can store data on the device, and also load and manipulate data from "the cloud" and other web services.This Windows Phone 7.5 Data Cookbook has a range of recipes to help you apply data handling concepts. You will be able to apply the knowledge gained from these recipes to build your own apps effectively. This Windows Phone 7.5 Data Cookbook starts with data binding concepts at the UI layer and then shows different ways of saving data locally and externally in databases. The book ends with a look at the popular MVVM software design pattern. The recipes contained in this book will make you an expert in the areas of data access and storage.

Related Content you might be interested in

Current Title:

Small book image
Windows Phone 7.5 Data Cookbook
Ramesh Thalli
Oct, 2011 | 224 pages
No titles found
Table of Contents (15 chapters)
Windows Phone 7.5 Data Cookbook
Windows Phone 7.5 Data Cookbook
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Data Binding to UI Elements
Data Binding to UI Elements
Introduction
Element binding
DataContext
Data Templates
How DataMode is used
Converting data for display
Building a simple app
2
Isolated Storage
Isolated Storage
Introduction
Saving user settings
Opening and creating a file
Saving username and password to a local store
Saving a background image to local storage
3
XML as a Data Store
XML as a Data Store
Introduction
Opening a local XML file
Navigating the XML file
Opening a remote XML file
Object serialization to XML
4
Using Open Data
Using Open Data
Introduction
Consuming OData services
Searching OData services
CRUD operations with OData
5
Using On-Device Databases
Using On-Device Databases
Introduction
Overview of SQLite Studio
SQLite Client as an embedded database
Using SQLite as a local store for the MyTasks App
SQL CE as a local store
McObject Perst as an embedded object database
6
Representational State Transfer—REST
Representational State Transfer—REST
Introduction
Consuming RSS Feeds
Using the Twitter API
Building a simple REST service
7
Windows Communication Framework—WCF
Windows Communication Framework—WCF
Introduction
Writing and consuming a simple web service
Building a service layer using WCF
WCF using ADO.NET Entity Framework
Using LINQ to SQL for creating the service
8
Model View ViewModel
Model View ViewModel
Introduction
Simple MVVM application
Using MVVM Light Toolkit
Updating the MVVM application
Index
Index

SQL CE as a local store

In this recipe, let's explore how we can use SQL CE—an embedded database from Microsoft—as a local store. Some of the features of SQL CE are as follows:

  • It is totally free without any license restrictions.

  • Embedded database means you don't even need to install in order access the database; you can just copy the binary into the project folder and use it like a file.

  • There are two ways to use the SQL CE in Phone applications; one is as a device storage, which allows read/write access, and the other is as an App storage, which allows read-only access. A scenario for the App storage is when you want to ship something like dictionary data or searchable data that doesn't need to be updated by the user.

  • It is supported by Visual Studio for creating and editing databases. Also, you can modify indexes.

  • You can use Entity Framework (EF) to create the model code. WP7 applications only support LINQ to SQL for now.

Getting ready

First, you need to make sure you download and install Visual...

Previous Section
End of Section 6
Next Section