SqlFunctionAttribute.DataAccess Property

  • Reference

Definition

Namespace:
Microsoft.Data.SqlClient.Server
Assembly:
Microsoft.Data.SqlClient.dll
Package:
Microsoft.Data.SqlClient v1.0.19269.1
Package:
Microsoft.Data.SqlClient v1.1.4
Package:
Microsoft.Data.SqlClient v2.0.1
Package:
Microsoft.Data.SqlClient v2.1.4
Package:
Microsoft.Data.SqlClient v3.0.1
Package:
Microsoft.Data.SqlClient v3.1.0
Package:
Microsoft.Data.SqlClient v4.0.1
Package:
Microsoft.Data.SqlClient v4.1.0

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

public:
 property Microsoft::Data::SqlClient::Server::DataAccessKind DataAccess { Microsoft::Data::SqlClient::Server::DataAccessKind get(); void set(Microsoft::Data::SqlClient::Server::DataAccessKind value); };
public Microsoft.Data.SqlClient.Server.DataAccessKind DataAccess { get; set; }
member this.DataAccess : Microsoft.Data.SqlClient.Server.DataAccessKind with get, set
Public Property DataAccess As DataAccessKind

Property Value

DataAccessKind

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

Remarks

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 Read property should be set.

Applies to