How to Obtain a Single Value from a Host File System
You might need to return database information that is just a single value rather than in the form of a table or data stream. For example, you might want to return the result of an aggregate function such as COUNT(*), SUM(Price), or AVG(Quantity).
To obtain a single value from the Host File System
Make a call to
HostFileCommand.ExecuteScalar.ExecuteScalarreturns a scalar value: the value of the first column of the first row of the result set.
See Also
Working with the Managed Data Provider For Host Files
BizTalk Adapter for Host Files Configuration