How do I write queries to do the following in SubSonic / C #?
select isNull (col, someDefaultValue) from table
select x = case when (condition) then col1 else col2 end from table
I don't have SubSonic and it works locally, but it looks like it supports the coalesce feature and that seems to be your first request. (Coalesce takes any number of parameters and returns the first nonzero option.)
You probably want to use the example Inline Query function in subsonicproject