Specifies whether the driver connects to read-write databases or requests read-only routing to connect to read-only database replicas. Read-only routing only applies to connections in Microsoft SQL Server 2012 where Always On Availability Groups have been deployed.
Valid Values
0 | 1
Behavior
If set to 0 (READWRITE), the driver connects to a read-write node in the Always On environment.
If set to 1 (READONLY), the driver requests read-only routing and connects to the read-only database replicas specified by the server.
Notes
By setting ApplicationIntent to 1 (ReadOnly) and querying read-only database replicas when possible, you can improve efficiency of your environment by reducing the work load on read-write nodes.
When ApplicationIntent is enabled, the virtual network name (VNN) of the availability group listener must be specified in the Host Name connection option.
By setting ApplicationIntent to 1 (ReadOnly) and querying read-only database replicas when possible, you can improve efficiency of your environment by reducing the work load on read-write nodes.