Microsoft.SqlServer.Server.SqlFunctionAttribute

SqlFunctionAttribute

public class SqlFunctionAttribute : Attribute

Used to mark a method definition of a user-defined aggregate as a function in SQL Server. The properties on the attribute reflect the physical characteristics used when the type is registered with SQL Server.

public DataAccessKind DataAccess { get; set; }

Indicates whether the function involves access to user data stored in the local instance of SQL Server.

public string FillRowMethodName { get; set; }

The name of a method in the same class which is used to fill a row of data in the table returned by the table-valued function.

public bool IsDeterministic { get; set; }

Indicates whether the user-defined function is deterministic.

public bool IsPrecise { get; set; }

Indicates whether the function involves imprecise computations, such as floating point operations.

public string Name { get; set; }

The name under which the function should be registered in SQL Server.

public SystemDataAccessKind SystemDataAccess { get; set; }

Indicates whether the function requires access to data stored in the system catalogs or virtual system tables of SQL Server.

public string TableDefinition { get; set; }

A string that represents the table definition of the results, if the method is used as a table-valued function (TVF).

public SqlFunctionAttribute()

An optional attribute on a user-defined aggregate, used to indicate that the method should be registered in SQL Server as a function. Also used to set the DataAccess, FillRowMethodName, IsDeterministic, IsPrecise, Name, SystemDataAccess, and TableDefinition properties of the function attribute.