C# – isNull(col, ”)

ccaseisnullsubsonic

How to write queries to do the followings in SubSonic/C#?

select isNull(col, someDefaultValue) from table

select x =
case
when (condition) then col1
else col2
end
from table

Best Answer

I don't have SubSonic up and running locally, but it looks like it supports the coalesce function, which is what your first query seems to be doing. (Coalesce takes any number of parameters and returns the first non-null one.)

Related Solutions

C# – Can a Byte[] Array be written to a file in C#

Based on the first sentence of the question: "I'm trying to write out a Byte[] array representing a complete file to a file."

The path of least resistance would be:

File.WriteAllBytes(string path, byte[] bytes)

Documented here:

System.IO.File.WriteAllBytes - MSDN

Rename fields in SubSonic select statement

I believe Alias's are only available for aggregate columns. You could just add properties of the same names as your columns to your class or a partial and map them to the properties you do use ala calculated field:

public class Songs

{

private string _songTitle;
public string SongTitle {
    get { return _songTitle; }
    set { _songTitle = value; }
}

public string SongName {
    get { return _songTitle; }
    set { _songTitle = value; }
}

}

Best Answer

Related Solutions

C# – Can a Byte[] Array be written to a file in C#

Rename fields in SubSonic select statement

Related Topic