CRUD на сервере

QueryCase queryCase = new QueryCase();
//,CASE WHEN su.SxPhone != '' then  su.SxPhone else ResultSelect.MobilePhone end 
QueryCondition queryCondition = new QueryCondition(QueryConditionType.NotEqual) {
	LeftExpression = new QueryColumnExpression(Column.SourceColumn("su", "SxPhone"))
};
queryCondition.RightExpressions.Add(Column.Parameter(string.Empty));
queryCase.AddWhenItem(queryCondition, Column.SourceColumn("su", "SxPhone1"));
 
queryCase.ElseExpression = new QueryColumnExpression(Column.SourceColumn("ResultSelect","MobilePhone"));
 
 
var sel = (new Select(UserConnection)
			//.Top(1)
			.Column(queryCase)
			.From("Account")
 
 
            ) as Select;

Пащенко Александр Сергеевич,

спасибо за пример!