Use this attribute to associate a method with a stored procedure in the database.
The FunctionAttribute type exposes the following members:
- IsFunction - gets or sets whether a method is mapped to a function or to a stored procedure.
- Name - gets or sets the name of the function.
- CommandText - gets or sets explicit SQL to be executed with this function.
- FunctionType - gets or sets the type of the function. The values for this property are predefined in the FunctionTypeEnumeration, which exposes the following fields:
- Scalar - specifies that the function will return scalar value.
- PersistentType - specifies that the function will return a Persistent Type.
- ComplexType - specifies that the function will return a complex type.
| C# |
 Copy Code |
|
[Function("RetrievePersons")]
public int GetPersons([Parameter("personId", OpenAccessType = OpenAccessType.Int32, Mode = ParameterMode.InOut, IsNullable = false)] int PersonID)
{
PersonID = PersonID * 2;
return PersonID;
} |
| VB.NET |
Copy Code |
<FunctionAttribute( "RetrievePersons")> Public Function GetPersons(<Parameter( "personId", OpenAccessType := OpenAccessType.Int32, Mode := ParameterMode.InOut, IsNullable := False)> ByVal PersonID As Integer) As Integer PersonID = PersonID * 2 Return PersonID End Function |