Richards blog

There are two simple methods available: OrderBy/OrderByDescending and Sort. The one you choose depends on your intended outcome. If you want 'in place' sorting (ie: within the existing object), then use myItems.Sort((x,y) => string.Compare(x.MyProperty, y.MyProperty)); If you want to assign the outcome to a new variable, the use var mySortedResults = myItems.OrderBy(x=> x.MyProperty).ToList()

I tried to add a 'not null' column to an existing table, but SQL Server (rightfully) complained. I had two options - give the column a default value (no thanks) or add a nullable column and change it. I chose the latter. 1. Add a nullable column Alter table [Foo] add [MyFoo] int null 2. Set all the values to a value Update [Foo] set [MyFoo] = 1 3. Set the column to be 'not null' Alter table [Foo] Alter Column [MyFoo] int not null