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

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft