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 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)

In this article, Mahesh Sabnis explores the mechanism of communicating with the local SQL Database using the out-of-browser features of Silverlight 4 with elevated trust permissions.

Source: Dot Net Curry

I started my carrier as a VB 6.0 Developer 12 yrs ago. During this period, I used to work with ADO (the data access technology during that time) for accessing data and performing CRUD operations. It’s been a long time since then. Now I use the latest .NET technologies for various types of application development and training. Currently I am using Silverlight 4.0 which contains some fantastic features like COM enhancement programming.

We tweet all news and content updates - follow us on Twitter! 

EffiProz Silverlight Database Online Demo  http://www.effiproz.com/SL4QTDemo.aspx

EffiProz-SL embedded database for Silverlight applications is written 100% in C# and comes with an ADO.NET style programming interface. EffiProz-SL Supports creating In-Memory and Silverlight Isolated Storage databases. Some of the product features are SQL Stored Procedures, Multi-Version Concurrency Control, Role Based Access Control, Multi-Schema Support and the ability to create encrypted databases. New Silverlight 4 release includes a Out-of-Browser applications support,Data Binding Support for Silverlight Controls and ability to create databases in local file system special folders (like My Documents, etc.).

Michael Washington has a demo of a simple attendance application using the Silverlight Sterling Database.

Source: Code Project

To demonstrate the functionality of Sterling, I decided to demonstrate using a small but non-trivial example. This attendance application is small, but it is not without it's complications. You are able to choose a day, and you will only see the students enrolled on that day. When you enter an attendance status it is saved immediately.

We tweet all news and content updates - follow us on Twitter! 

Source: CodePlex

The goal behind Sterling is to keep it:

• Non-intrusive. You shouldn't have to change your classes just to persist them.
• Lightweight. As of this writing, the DLL for Sterling is under 70 Kb. No one needs to bloat their project for something as simple as persisting data.
• Flexible. While the core is light, Sterling is designed to handle any serialization task and make it ultra-easy to query databases using LINQ-to-Objects.
• Portable. Sterling is designed to run on both Silverlight 4.0 and the Windows Phone 7.

We tweet all news and content updates - follow us on Twitter! 

The CTP4 release of the “EF Code-First” functionality provides a pretty nice code-centric way to work with data.  It brings with it a lot of productivity, as well as a lot of power.  Hopefully these two blog posts provides a glimpse of some of the possibilities it provides. 

 The main features added are:

• POCO support- now a storable class is not mandatory anymore to implement ISqoDataObject or to inherit from SqoDataObject
• Indexes support added – now you can index by a property/field so queries are much faster if index is involved.
• Attributes like Index, UniqueConstraint, MaxLength, Ignore can be used also on automatic properties
• Added new methods on Siaqodb class like:DeleteObjectBy(…) or LoadObjectByOID(…)
• Support for just released WP7 developer tools BETA

It supports multiple strongly typed tables, basic Linq based operations, addition and deletion of ranges of items, deletion of items based on condition.  You can also directly bind data to UI in Silverlight because base table inherits from ObservableCollection.  It supports encryption along with lazy loading of table.