SqlFunctionAttribute.DataAccess Property

 

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

Namespace:   Microsoft.SqlServer.Server
Assembly:  System.Data (in System.Data.dll)

public DataAccessKind DataAccess { get; set; }

Property Value

Type: Microsoft.SqlServer.Server.DataAccessKind

DataAccessKind.None: Does not access data. DataAccessKind.Read: Only reads user data.

The default is None.DataAccess is also required when connecting to remote servers if transactions integration is required (the default).

If a Transact-SQL query is executed from inside a table-valued function (TVF), the DataAccessKind.Read property should be set.

.NET Framework
Available since 2.0
Return to top
Show: