Insert entity
Inserts a row to a SQL Server table using data from an entity.
Logically, this action performs the following:
INSERT INTO tableName (Property1, Property2) VALUES(entity.Property1, enity.Property2)
Note
Each property name in the entity must exist in the target table. If the database collation is case sensitive, the properties and columns must match by case in addition to name.
Properties
| Name | Type | Description |
|---|---|---|
| Title | Optional | A descriptive title for the action. |
| Connection | Required | The SQL Server Connection. |
| Dynamic connection | Optional | Use this option of you needs to use a connection from the Create Connection action. |
| Entity | Raquired | Select the entity (object) to insert. |
| Table name | Required | Select where to insert the data. |
| Result variable name | Optional | Name of the variable returning number of rows affected. |
| Command timeout (sec) | Optional | The time limit for command execution before it times out. Default is 120 seconds. |
| Description | Optional | Additional notes or comments about the action or configuration. |