SqlFunctionAttribute.DataAccess Property

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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
Available since 2.0
Return to top
Show: