Get entities
Gets a list of entities based on a query agains a SQL Server database.
An entity is a .NET object with one or more properties, for example
public record Customer(string VATNumber, string Name, string Address);
This actions returns a list of entities with properties as specified by the Entity properties configuration, for example
List<Customer> customers;
Returns
A List of custom .NET objects with properties specified by the Entity properties configuration.
Properties
| Name | Data type | Description |
|---|---|---|
| Title | Optional | The title or name of the command. |
| Connection | Required | The SQL Server connection. |
| SQL expression and parameters | Required | The command to execute along with any parameters. |
| Entity name | Optional | |
| Entity properties | Required | |
| Result variable name | Required | Name of resulting list of entities variable |
| Result data type | Optional | |
| 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. |