Sql.Coalesce method (1 of 2)

namespace: Serenity.Data   assemblySerenity.Net.Data

Creates a COALESCE() expression.

public static string Coalesce(params string[] statements)
parameter description
statements The statements.

Exceptions

exception condition
ArgumentNullException fields is null or empty

See Also


Sql.Coalesce method (2 of 2)

namespace: Serenity.Data   assemblySerenity.Net.Data

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

public static string Coalesce(this IQueryWithParams query, params object[] values)
parameter description
query The query.
values The values.

Exceptions

exception condition
ArgumentNullException values is null or empty

See Also