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 LINQ to SQL for creating the service

LINQ to SQL is the family of LINQ technologies targeting relational databases where data is mapped as objects. LINQ to SQL provides the fastest way to create an interface to the backend. The only disadvantage is it can only map one level of relationship. So, if you need deeper relationship management, the Entity Framework is the way to go. Some of the features of LINQ to SQL are as follows:

  • Translates LINQ expression to T-SQL (Transact-SQL)

  • Provides an easy way to query objects instead of SQL statements

  • Has the ability to create databases and tables in the database

  • Provides a way to query the database using regular T-SQL statements

In this recipe, let's build the MyTask service like the preceding recipe, but instead of using the Entity Framework we will use LINQ to SQL classes.

Getting ready

Open the Visual Studio and create a new project using the WCF Service Application template and name it Recipe4_LINQToSQL under the CH7 folder. Right-click on App_Data...

Previous Section
End of Chapter 7
Next Chapter