Search

Rudi Grobler takes a quick look at the Sterling database available on WP7.

Source: Rudi Grobler in the Cloud

Sterling is a lightweight object-oriented database implementation for Silverlight and Windows Phone 7 that works with your existing class structures. Sterling supports full LINQ to Object queries over keys and indexes for fast retrieval of information from large data sets.

In this post, Rudi Grobler shares with you his list of WP7 must-have toolkits.

Source: Rudi Grobler in the Cloud

If you do ANY serious Windows Phone 7 development, here are a couple of toolkits you MUST HAVE.

In this article, Jeremy Likness discusses Sterling and WP7 Database Triggers.

Source: C#er : IMage

Sterling changeset 72063 [browse the source code here] introduces triggers. The trigger is a powerful feature that allows you to universally intercept database operations. Their application in Sterling resolves several concerns, including: 

• Validation — prevent a save operation from succeeding if data integrity is compromised, or prevent a delete operation when prerequisites are not met
• Data-specific concerns — should the business layer be concerned with a "last modified date" that relates to the database? Use a trigger to set the date consistently without involving other pieces of your application
• Post-save processing (for example, clear a "dirty flag" once the item is persisted)

This post of Jeremy Likness is intended to introduce you to Sterling (an object-oriented database that Jeremy created) and also to provide guidance for using it on the Windows Phone 7.

Source: C#er : IMage

Sterling is an object-oriented database that I created to facilitate ease of serialization of data in both Silverlight 4 (soon 5) and Windows Phone 7 projects. Sterling was designed with a few goals in mind. It is not a true relational database and not intended to replace one. I'm confident certain offerings such as SQLite or even a trimmed down version of SQL Server will make their way to the phone eventually, backed by experienced teams and highly optimized code.

Ramesh Sringeri explains how to start using Sterling for your Windows Phone 7 app.

Source: Braincells2pixels.net

The codeplex home of Sterling has everything you need to start using this excellent storage solution for your Windows Phone 7 app. Source, sample code, documentation (MS Word and PDF formats). You get everything. However, I did run into a few hiccups and hopefully my findings below will help you get past any blocks. This is not a replacement for the excellent documentation for Sterling. I am filling a few gaps that will help those not familiar with Silverlight and/or Windows Phone 7 get Sterling setup quickly.