Sql class

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

Contains SQL expression generation helpers

public static class Sql

Public Members

name	description
static Avg(…)	Creates a 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