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

Using SQLite as a local store for the MyTasks App

In this recipe let's explore how to use the SQLite file we created in the first recipe, Overview of SQLite Studio, as the local data store for our MyTasks app.

Getting ready

For this recipe we shall use the project template we created in the Chapter 1, Data Binding to UI Elements.

How to do it...

In the following steps, we will create a MyTasks project to use the sample SQLite database file we created in the preceding recipe and then learn how to use the SQLite Client API to insert and display the results.

  1. Create a project from the CH1_MyTasks template and name it Ch5_MyTasks_SQLiteClient.

  2. Add the existing file MyDatabase.sqlite we created in the first recipe, Overview of SQLite Studio, and add it to the project root folder.

  3. Copy the DBHelper.cs file from the SQLite Client project in the new folder Helpers.

  4. Add a project reference to the assembly Community.CsharpSqlite.WP.dll.

  5. Open the App.xaml.cs file and add using declaratives at the top of the...

Previous Section
End of Section 5
Next Section