This course explores the various ways Windows Phone applications access data. Parts 1 and 2 look at creating and accessing a local SQL database on the phone. Part 3 examines the user data APIs which let applications work with contacts and calendar on the phone. Part 4 discusses accessing an external data service from a phone application. All modules focus on real-world, no-nonsense scenarios involving querying, displaying, and in some cases updating domain-specific application data.
Yacine has been involved in the development of database-driven, n-tier web applications for over 10 years. Over time he has taken on various roles, including development, project management, offshore platform management and technical consulting. He has helped build a few solutions for Microsoft North Africa.
Phone database part1 Welcome to this course on Windows Phone Data. This is Yacine Khammal with Pluralsight. In this course we'll explore accessing and handling several different types of data within the phone application. Specifically, we'll look at using a local database on the device, accessing user data, such as contacts and calendar that's maintained as part of the native phone experience, and accessing external data that's exposed over the network as OData feeds. So we'll begin this course with a two module series focusing on defining and accessing a local SQL database on the phone itself. And we'll start off with an overview of what Windows Phone has to offer in terms of database capabilities. Which scenarios are targeted and what infrastructure are available to us for these data operations. Then we'll dive in and look at how we define our data model in our logical schema, using a code first approach, and LINQ to SQL mappings. Next, we'll examine a couple of different approaches to generating our application database on the device. And we'll finish part one with a look at how we select and retrieve data from our phone database using linked to SQL queries, and how we can actually use that data in our phone application. In part two, we'll continue our exploration with a closer look at data ride operations, schema updates, and schema imports.
Phone database part2 Hi, this is part two of this course on Windows Phone Data. In this talk we continue our exploration of of the Windows Phone local database, which we started in part one. And we'll start with a discussion of the way that data is inserted, updated, and deleted in the local device database, always through the LINQ to SQL layer using a unit of word pattern. Then we'll look a feature available on the phone that lets us easily update our data model and DB schema without affecting existing data stored in the data file. We'll then consider the scenario in which we need to import an existing database schema from outside the phone application, including from a SQL Server instance into the application using the SqlMetal Tool. And finally, we'll review some important considerations and best practices that we should always keep in mind when working with local databases on the device. . . .
User data Hi, this is Yacine Khammal for Pluralsight, and welcome to Module 2 of this Windows Phone Data course. In this module we'll look at the phones new user data APIs. And we'll start with an overview of the user data programming features, which are consistent across both contacts and calendar data, namely through the common concept of user data aggregation. Next we dive into the specifics of the contacts API. And we'll look at the contact related data model available to us within our phone application. And we also examine the ways searches are performed on the phone's contacts database, using a combination of highly optimized built-in searches and custom LINQ query. And finally, we move on to the Calendar API. And we examine the object model that's exposed, as well as the search capabilities available for searching through appointments drawn from various calendar sources.
OData Welcome to Module 4 of this Windows Phone Data course. This is Yacine Khammal with Pluralsight, and in this module we'll discuss accessing an OData service from a Windows Phone application. We begin this talk with a brief review of some of the key concepts behind OData and. NETs implementation of these concepts. Then we explore the OData client for Windows Phone, which is now in-line with other existing OData clients in. NET. We then take a detailed look at querying the data from the phone, using LINQ and two different APIs available to us in the client. We also see how to handle paging, and we'll look at different ways of loading related data on the other end of a parent child relationship defined in in a data model. Next, we examine updating and inserting data from our phone application and leveraging the Unit of Work approach that the client exposes. And we finish with a look at data state persistence in the client, in the face of the phone's lifecycle events.