Sql class

namespace: Serenity.Data assembly: Serenity.Net.Services

Contains SQL expression generation helpers.

public static class Sql

Public Members

name	description
static Avg(…)	Creates an AVG() expression. (3 methods)
static Case(…)	Creates a CASE() expression. (2 methods)
static Coalesce(…)	Creates a COALESCE() expression. (2 methods)
static Convert(…)	Creates a Convert() expression.
static Count()	Returns COUNT(*).
static Count(…)	Creates a COUNT() expression. (3 methods)
static Max(…)	Creates a MAX() expression. (3 methods)
static Min(…)	Creates a MIN() expression. (3 methods)
static SubString(…)	Creates a SUBSTRING() expression.
static Sum(…)	Creates a SUM() expression. (3 methods)
class CaseBuilder	CASE statement builder