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)

property DataAccessKind DataAccess {
	DataAccessKind get();
	void set(DataAccessKind value);

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