SqlUpdate.Format method
namespace: Serenity.Data assembly: Serenity.Net.Services
Formats an SQL UPDATE statement.
public static string Format(string tableName, string where, List<string> nameValuePairs,
ISqlDialect dialect = null)
| parameter | description |
|---|---|
| tableName | Table name (required). |
| nameValuePairs | Field name and values. Should have structure of [field1, value1, field2, value2, ...., fieldN, valueN]. This array is required and must have even number of elements. |
| where | WHERE clause (can be null). |
| dialect | Target dialect |
Return Value
Formatted UPDATE query.
See Also
- interface ISqlDialect
- class SqlUpdate