SqlFunctionAttribute::DataAccess Property
.NET Framework (current version)
Indicates whether the function involves access to user data stored in the local instance of SQL Server.
Assembly: System.Data (in System.Data.dll)
public: property DataAccessKind DataAccess { DataAccessKind get(); void set(DataAccessKind value); }
Property Value
Type: Microsoft.SqlServer.Server::DataAccessKindDataAccessKind.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
Available since 2.0
Show: