SqlMethodAttribute Class
Assembly: System.Data (in system.data.dll)
'Declaration <SerializableAttribute> _ <AttributeUsageAttribute(AttributeTargets.Method, AllowMultiple:=False, Inherited:=False)> _ Public NotInheritable Class SqlMethodAttribute Inherits SqlFunctionAttribute 'Usage Dim instance As SqlMethodAttribute
/** @attribute SerializableAttribute() */ /** @attribute AttributeUsageAttribute(AttributeTargets.Method, AllowMultiple=false, Inherited=false) */ public final class SqlMethodAttribute extends SqlFunctionAttribute
SerializableAttribute AttributeUsageAttribute(AttributeTargets.Method, AllowMultiple=false, Inherited=false) public final class SqlMethodAttribute extends SqlFunctionAttribute
For a property, the SqlMethodAttribute should be used on the setter or the getter directly.
Inherits from a SqlFunctionAttribute.
The following example shows a UDT method that is attributed to indicate that the method will not be invoked on a null reference (Nothing in Visual Basic) instances of the type, that the method will not change the state of the type, and that the method will not be called when a null reference (Nothing in Visual Basic) parameters are supplied to the method invocation.
' Distance from Point to the specified x and y values method. <SqlMethod(OnNullCall:=False, IsMutator:=False, InvokeIfReceiverIsNull:=False)> _ Public Function DistanceFromXY(ByVal ix As Int32, ByVal iy As Int32) _ As Double Return Math.Sqrt(Math.Pow(ix - _x, 2.0) + Math.Pow(iy - _y, 2.0)) End Function
System.Attribute
Microsoft.SqlServer.Server.SqlFunctionAttribute
Microsoft.SqlServer.Server.SqlMethodAttribute
Windows 98, Windows 2000 SP4, Windows Millennium Edition, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.