SqlInsert class

namespace: Serenity.Data assembly: Serenity.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.