An update introduces support for the AlwaysOn features in SQL Server 2012 or a later version to the .NET Framework 3.5 SP1

Introduction

This update introduces support for the following AlwaysOn features in Microsoft SQL Server 2012 or a later version to the Microsoft .NET Framework 3.5 Service Pack 1 (SP1):

ApplicationIntent

When the ApplicationIntent property is set to ReadOnly, the client requests a read access operation when it connects to an AlwaysOn-enabled database. The server will enforce the read-only access operation both at connection time, and during a USE database statement, but only to an AlwaysOn-enabled database. When the ApplicationIntent property is set to ReadWrite, the client requests a regular (read-write) access operation when it connects to an AlwaysOn-enabled database. The default setting for the ApplicationIntent property is ReadWrite.

Read-Only Routing

Read-only routing is a feature that can guarantee the availability of a read-only replica of a database. To enable read-only routing:

You must connect to an Always On Availability Group availability group listener.

The ApplicationIntent connection string keyword must be set to ReadOnly.

The Availability Group must be configured by the database administrator to enable read-only routing.

MultiSubnetFailover (including support for the named instance)Always specify MultiSubnetFailover=True when you connect to an availability group listener or a failover cluster availability group listener in SQL Server 2012 or a later vesion. MultiSubnetFailover enables faster failover for all availability groups and all failover cluster instances in SQL Server 2012 or a later version, and will significantly reduce failover time for single-subnet and multi-subnet AlwaysOn topologies. During a multi-subnet failover, the client will try connections in parallel.This hotfix also includes support for AlwaysOn named instances connectivity.

Note This hotfix does not add support for the SqlConnectionStringBuilder.ApplicationIntent property or for the SqlConnectionStringBuilder.MultiSubnetFailover property. Instead, these properties can be accessed by using the SqlConnectionStringBuilder["ApplicationIntent"] indexer and the SqlConnectionStringBuilder["MultiSubnetFailover"] indexer.

More Information

For more information about the SQL Server AlwaysOn feature, visit the following Microsoft website:

Note When you install the update package, you may notice that the update package applies to the .NET Framework 2.0. This is because the code fix is in the .NET Framework 2.0 layer, which is included in the .NET Framework 3.5 SP1.

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Prerequisites

To apply this update, you must have the .NET Framework 3.5 SP1 installed on the computer.

Registry information

To use the update in this package, you do not have to make any changes to the registry.

Restart requirement

You do not have to restart the computer after you apply this hotfix if the affected files are not being used.

Update replacement information

This update does not replace a previously released update.

File information

The global version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

For all supported x86-based versions of Windows XP SP3

File name

File version

File size

Date

Time

Platform

System.data.dll

2.0.50727.5713

2,972,672

23-Jan-2012

07:33

x86

For all supported x64-based versions of Windows XP SP3

File name

File version

File size

Date

Time

Platform

System.data.dll

2.0.50727.5713

3,145,216

22-Jan-2012

23:15

x64

System.data.dll

2.0.50727.5713

2,972,672

23-Jan-2012

07:33

x86

For all supported IA-64-based versions of Windows XP SP3

File name

File version

File size

Date

Time

Platform

System.data.dll

2.0.50727.5713

3,301,888

22-Jan-2012

23:29

IA-64

System.data.dll

2.0.50727.5713

2,972,672

23-Jan-2012

07:33

x86

For all supported x86-based versions of Windows Server 2008 SP2

File name

File version

File size

Date

Time

Platform

System.data.dll

2.0.50727.5730

2,972,672

08-May-2012

10:58

x86

For all supported x64-based versions of Windows Server 2008 SP2

File name

File version

File size

Date

Time

Platform

System.data.dll

2.0.50727.5730

3,145,216

08-May-2012

10:58

x64

System.data.dll

2.0.50727.5730

2,972,672

08-May-2012

10:58

x86

For all supported IA-64-based versions of Windows Server 2008 SP2

File name

File version

File size

Date

Time

Platform

System.data.dll

2.0.50727.5730

3,301,888

08-May-2012

10:51

IA-64

System.data.dll

2.0.50727.5730

2,972,672

08-May-2012

10:58

x86

For all supported x86-based versions of Windows Server 2008 R2 SP1

File name

File version

File size

Date

Time

Platform

System.data.dll

2.0.50727.5718

2,972,672

30-Jan-2012

23:34

x86

For all supported x64-based versions of Windows Server 2008 R2 SP1

File name

File version

File size

Date

Time

Platform

System.data.dll

2.0.50727.5718

3,145,216

30-Jan-2012

23:29

x64

System.data.dll

2.0.50727.5718

2,972,672

30-Jan-2012

23:34

x86

For all supported IA-64-based versions of Windows Server 2008 R2 SP1

File name

File version

File size

Date

Time

Platform

System.data.dll

2.0.50727.5718

3,301,888

30-Jan-2012

23:23

IA-64

System.data.dll

2.0.50727.5718

2,972,672

30-Jan-2012

23:34

x86

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.