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:
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
Show: