Sql.Coalesce method (1 of 2)

Creates a COALESCE() expression.

public static string Coalesce(params string[] statements)

parameter	description
statements	The statements.

Return Value

The COALESCE() expression.

Exceptions

exception	condition
ArgumentNullException	fields is null or empty.

See Also

• class Sql

---

Sql.Coalesce method (2 of 2)

Creates a COALESCE() expression while adding values to the specified query as parameters.

public static string Coalesce(this IQueryWithParams query, params object[] values)

parameter	description
query	The query.
values	The values.

Return Value

The COALESCE() expression.

Exceptions

exception	condition
ArgumentNullException	values is null or empty.

See Also

• interface IQueryWithParams
• class Sql