Function Element (SSDL)

Artigo
04/12/2011

The Function element in store schema definition language (SSDL) specifies a stored procedure that exists in the underlying database.

The Function element can have the following child elements (in the order listed):

Documentation (zero or one)
CommandText (zero or one)
Parameter (zero or more)
Annotation elements (zero or more)

Stored procedures that are specified in the storage model can be imported into the conceptual model of an application. For more information, see How to: Import a Stored Procedure. The Function element can also be used to define custom functions in the storage model. For more information see How to: Define Custom Functions in the Storage Model.

Applicable Attributes

The following table describes the attributes that can be applied to the Function element.

Note

Some attributes (not listed here) may be qualified with the store alias, which is the alias for the https://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator namespace. These attributes are used by the Update Model Wizard when updating a model.

Attribute Name	Is Required	Value
Name	Yes	The name of the stored procedure.
ReturnType	No	The return type of the stored procedure.
Aggregate	No	True if the stored procedure returns an aggregate value; otherwise False.
BuiltIn	No	True if the function is a built-in1 function; otherwise False.
StoreFunctionName	No	The name of the stored procedure.
NiladicFunction	No	True if the function is a niladic2 function; False otherwise.
IsComposable	No	True if the function is a composable3 function; False otherwise.
ParameterTypeSemantics	No	The enumeration that defines the type semantics used to resolve function overloads. The enumeration is defined in the provider manifest per function definition. The default value is AllowImplicitConversion.
Schema	No	The name of the schema in which the stored procedure is defined.

1 A built-in function is a function that is defined in the database. For information about functions that are defined in the storage model, see CommandText Element (SSDL).

2 A niladic function is a function that accepts no parameters and, when called, does not require parentheses.

3 Two functions are composable if the output of one function can be the input for the other function.

Note

Any number of annotation attributes (custom XML attributes) may be applied to the Function element. However, custom attributes may not belong to any XML namespace that is reserved for SSDL. The fully-qualified names for any two custom attributes cannot be the same.

Example

The following example shows a Function element that corresponds to the UpdateOrderQuantity stored procedure. The stored procedure accepts two parameters and does not return a value.

<Function Name="UpdateOrderQuantity" 
          Aggregate="false" 
          BuiltIn="false" 
          NiladicFunction="false" 
          IsComposable="false" 
          ParameterTypeSemantics="AllowImplicitConversion" 
          Schema="dbo">
  <Parameter Name="orderId" Type="int" Mode="In" />
  <Parameter Name="newQuantity" Type="int" Mode="In" />
</Function>

Partilhar via

Function Element (SSDL)

Applicable Attributes

Example

See Also

Concepts

Other Resources

Recursos adicionais