Kunal-Chowdhury.com - Microsoft Technology Blog for developers and consumers

Windows Phone 7 (Mango) Tutorial - 24 - Local Database Support, CRUD operation with Demo

In the last two chapters of the tutorial series, we discussed about the local database support in Windows Phone 7 (Mango). We learnt how to create a DataContext class from existing SQL CE database and also we learnt about the issues that arises once we add the class file in the project to build. We learnt the steps to resolve those issues too.

 

In this article, we are going to discuss about the CRUD operations that we can do using the DataContext class with a small application. We will learn how to create and delete a database, we will also learn how to insert or fetch records. After reading this tutorial you will also be able to do other operations like edit, search etc.



Download Windows Phone SDK 7.1 Beta 2 (Mango) - Web and Offline Installer

Microsoft released Windows Phone 7.1 SDK Beta 2 today, 29th June 2011. It has a no. of new features as well as some breaking changes respect to previous Beta 1 release.

 

In this post, find the link to download the Beta 2 SDK of Windows Phone 7.1 (Mango) which includes both the web and standalone offline installer. Also find the links towards new and breaking changes.


Windows Phone 7 (Mango) Tutorial - 23 - Local Database Support, Configuring Project

Hope you read my previous post on Windows Phone 7.1 (Mango) local database support. If you didn't read the earlier post, you need to read it before reading this one. You can find it here: "Create DataContext". That will give you the basic context about the same.

 

In this post (I will rather calling it as a Tip), we will configure the project by adding the generated DataContext class and in the next post, we will learn what are the various CRUD operations we can do with a sample application. That will give you complete visibility to this new feature implementation.


Windows Phone 7 (Mango) Tutorial - 22 - Local Database Support, Create DataContext

Do you know that, Windows Phone 7.1 (Mango) now supports local database? Yes, you can now use local database inside your Phone 7 device and use it to CRUD operations. You can now create a DataContext class from an existing database and use it as the entry point class to do DB operation.

 

In this chapter we will learn how to create a DataContext class for local SQL CE database. At the end of this tutorial our data context class will be ready for further DB operations.


Windows Phone 7 (Mango) Tutorial - 21 - Small Demo of Accelerometer Application

Last two days we learned about Accelerometer class, it's base class and the accelerometer tool that comes with the Phone emulator. Hope those posts gave you some basic idea about it.

 

Here in this post, we will learn the use of this feature with a small demo application. We will also learn how to use the phone to write application that depends on the gravitational force applied to the sensors. This will give you better idea to create game application that will work when the user moves his phone device.


Weekly News Digest @SilverlightZone - 19-June-2011 to 25-June-2011

Here comes the weekly news digest of Silverlight-Zone.com from 19th June 2011 to 25th June 2011. We have submitted 72 article links during the week on various topics like Silverlight, Windows Phone 7, LightSwitch, Expression Blend and even Windows 8.

 

During this week, top news was on Windows 8 Rumour to Windows Phone 7 future followed by several Windows Phone 7 related articles. In this post, I am going to share the top 5 posts as well as the links to daily news digest at Silverlight-Zone.com. Read to know more.



Windows Phone 7 (Mango) Tutorial - 20 - Know about the Accelerometer Tool

Yesterday, we came to know about Accelerometer of Windows Phone 7. We also learnt about the structure of the Accelerometer class and it's base class. Now, it's the time to see how to run the same inside the Phone emulator. In this post we are going to see the accelerometer tool that comes with the Phone 7 emulator.

 

Read more to know how to run the accelerometer tool and what customization we can do with this tool. This will be beneficial for you when we discuss more about the topic with a sample application.


Windows Phone 7 (Mango) Tutorial - 19 - What is WP7 Accelerometer?

Accelerometer defines the force applied to the Windows Phone 7 device which can be used to determine the measure of direction that has been applied by the user by moving the device. This values are represented as a 3D vector coordinates in X, Y and Z axis. Using the Accelerometer class present in the library, we can programmatically control the device's 3D acceleration.

 

In this article we will learn about the class that we will use to demonstrate the same feature. Read to learn more about it.


Windows Phone 7 (Mango) Tutorial - 18 - Know about various Phone Tasks

Last two days, we learnt about Alarm and Reminder class present for Windows Phone 7 application development. We came to know about the class structure and demoed the implementation with small application created in step-by-step process. We also learnt about the use of Task while discussing the same.

 

In this tutorial chapter we will learn more about the tasks present for Mango devices. After reading this part you will be able to understand the different tasks and their uses. Read more to learn about them with visual code snippet and huge screenshots.


Windows Phone 7 (Mango) Tutorial - 17 - How to Create a WP7 Reminder Application?

Yesterday we discussed about the Alarm class and also demonstrated the use of it using a small demo app. Today in this post we will learn about Reminder class and will see the structure of the same. We will also demonstrate the implementation with a small demo.

 

Like Alarm class, Reminder class is also part of the "Microsoft.Phone.Scheduler" namespace and inherits the same base class. Let's read more about it and explore each and every step to create a simple Windows Phone 7 Reminder application.


Windows Phone 7 (Mango) Tutorial - 16 - How to Create a WP7 Alarm Application?

Windows Phone 7.1 now supports scheduled tasks which runs even the application is not running. We can now schedule a task and when the bell hits, it starts executing the said task. In this chapter of the tutorial series, we will explore this using the Alarm class.

 

Alarm class creates an instance which runs in the background using the task agent and at the specified time, it will raise the event to execute. If your application is not running at that time too, it will execute and show the alarm screen. Read to know more about the class with a small demonstration.


 
© 2008-2017 Kunal-Chowdhury.com - Microsoft Technology Blog for developers and consumers | Designed by Kunal Chowdhury
Back to top