SelectValue

◷ Reading Time: 1 minute

Summary

This command returns a single value from the database.

Parameters

1. command
   1. Description: The Select command
   2. Mandatory: Yes
   3. Type: String
2. return
   1. Description: Name of the variable in which the row will be stored
   2. Mandatory: Yes
   3. Type: String
3. storedProcedure
   1. Description: Determines whether the command should execute a stored procedure in the database
   2. Mandatory: False
   3. Type: Boolean (true/false)

Internal Commands

Param

Sample

<Database connection-ref="cnn" type="MsSql">
  <SelectValue command="select FName from person where id = @id" return="name">
    <Param name="id" type="System.Int32" value="1"/>
  </SelectValue>
</Database>