SQL CE in Mango–Updating the Schema

In my previous post I talked about general usage of SQL CE database in Mango.  In this example I am going to talk about keeping the database schema updated. For example, I want to add a column to Person table from previous post.  I would like to add Notes column with the following definition:         …

Continue reading ‘SQL CE in Mango–Updating the Schema’ »

Using sorting functions with Linq for Objects

If you have written Linq queries, you are familiar with OrderBy clause.  Here is a quick example: from one in selected select one).OrderBy(one => one.Name)   If you only need to sort by single field, or even many fields, you are OK.  Here is an example: from one in selected select one).OrderBy(one => one.Name).ThenBy(one=>one.Title) But …

Continue reading ‘Using sorting functions with Linq for Objects’ »