Sql.Coalesce method (1 of 2)
namespace: Serenity.Data assembly: Serenity.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
- class Sql
Sql.Coalesce method (2 of 2)
namespace: Serenity.Data assembly: Serenity.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
- interface IQueryWithParams
- class Sql