DirectAccess Class Methods
- Last UpdatedMar 17, 2026
- 2 minute read
For a list of all members of this type, see DirectAccess members.
| Name | Description | |
|---|---|---|
  | ClearSpParameterCache | Overloaded. The ClearSpParameterCache() methods clear the parameter cache in the MES middleware for custom stored procedures (SPs). For performance reasons, the middleware caches the parameter list of an SP the first time the SP is called. If a custom SP's parameter list is subsequently changed, the middleware might not correctly call the SP until the cache is cleared. |
| ExecSp | The ExecSp() method allows calls to stored procedures in the MES database that do not return a DataSet, but might return output parameters. To define the input parameters that will be passed, use the methods in the SpParameter class. After calling the ExecSp() method, you can use the methods in the SpReturnValues class to get the returned values from the ExecSp() method call. |
| GetDsBySp | The GetDsBySp() method allows calls to stored procedures in the MES database that return a DataSet. To define the input parameters that will be passed, use the methods in the SpParameter class. |