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

Overview of SQLite Studio

In this recipe, we shall learn how to use the SQLite Studio for creating, editing, and querying an embedded SQLite database file.

Getting ready

First, let's download SQLite Studio, a free tool available online at http://sqlitestudio.one.pl/. SQLite Studio has a simple graphical user interface that helps in creating, inserting, and updating tables. Save the SQLite Studio .exe file to your local drive and then launch it.

How to do it...

In this recipe, we are going to create a database using SQLite Studio, and then create a table and add different columns. Once the table schema is created, we then add a couple of test records using the insert query statements.

  1. Launch SQLite Studio and navigate to Databases | Add Database. Pick the folder you want to create this database in and select the option Type name in field below: and then type MyDatabase. You can also pick the version of SQLite you want to create. Click on OK to create and add the database file.

  2. Once you open the...

Previous Section
End of Section 3
Next Section