SqlInsert class

namespace: Serenity.Data   assemblySerenity.Net.Data

Class to generate queries of the form INSERT INTO tablename (field1, field2..fieldN) VALUES (value1, value2..valueN)

public class SqlInsert : QueryWithParams, ISetFieldByStatement

Public Members

name description
SqlInsert(…) Creates a new SqlInsert query.
Clone() Clones the query.
Dialect(…) Sets the dialect (SQL server type / version) for query.
IdentityColumn() Gets the identity column.
IdentityColumn(…) Sets the identity column.
SetNull(…) Assigns NULL as the field value.
SetTo(…) Sets field value. (2 methods)
override ToString() Gets string representation of the query.
static Format(…) Formats an INSERT query.

See Also